Hello again:

Well, I've made a bit of progress, and I feel like I'm almost there...but not quite. I'm using this as the detail for my second matrix:

=Format(CountDistinct(Fields!CardSwipeID.Value)/CountDistinct(Fields!StudentID.Value), "#.###")

...and the only...

Hi, Jack:

I did try using the AVG() function, but since I need to average a COUNT, it throws an error about not being able to nest aggregate functions. What would...

Thanks, GSquared! You've definitely gotten me on the right track. I think I have some sort of mental block when it comes to recursive relationships. 🙂 As for your suggestion...

Thanks so much to you both! Happycat, your code works perfectly! Jack, I tried yours and got the error "startIndex cannot be larger than length of string." Did I do...

Hi, Luke:

Thanks for getting me on the right track! The code that ended up working isn't exactly like yours, but it's very similar:

SELECT

person.name,

orders.ID,

orders.customer,

item.type,

detail.item,

detail.qty,

customer.phone,

item.name,

detailassoc.date,

detailassoc.time

FROM person,

...

Hello, all:

Unfortunately I'm an idiot and I realized through trying and failing to use your suggestions that I need to write this in VBA, not in SQL. I'm really sorry...

1. Do you really need all the OUTER JOIN's? Can you have an order without a customer? I normally would think that would not be possible.

2. ...

FYI, I re-posted this question here:

Jack, thank you so much. That worked perfectly. You and Gift are both lifesavers--if I could give you a virtual hug, I would. :Wow:

Thank you thank you thank...

Oh, my god, Jack, you're a genius. It works! Thanks so so so much!! Now just one last thing and I swear I'll leave you alone forever: Do you know...

Hi, Gift:

Again, thanks so much for your help. That was the code that I used, but I can't declare parameters because this report needs to have only one parameter, OrderNumber....

Thanks to you guys for bearing with me, but that code didn't work--it throws the same error, "Conversion from type 'TimeSpan' to type 'Date' is not valid." I don't know...

Okay, well, I came upon this code somewhere:

Dim ts As TimeSpan

Dim dt As DateTime = DateTime.MinValue.Add(ts)

Dim s As String

s = ts.ToString()

st = dt.ToString("hh:mm tt")

...but I don't know enough about proper...

Hi, Gift:

I actually really would like to use the DateTime datatype, but the problem is that the existing datatype is TimeSpan and it won't convert. I don't want a time...

Hello:

Gift, unfortunately I'm very new at this, and I know nothing at all about .NET--I don't even know what you mean by "function box." Please excuse my ignorance! :unsure:

Jack, the...