Item Count Query

[Steven Smith]

I'm sure this is really simple but I just can't get my
head around it...

I've got Invoice_Header & Invoice_Detail tables as part
of my app, what I want to do is knock up a query that
simply counts the number of items in the Invoice_Detail
table relating to each Invoice_Header record...

Any help or guidance you can offer is much appreciated,
thanks in advance...

Regards Steve

 

[Steven Smith]

Its OK guys, I figured it out from the Count Schools in
Districts query post made earlier...

Apologies for the waste of space...

 

[Steven Smith]

Heh just realised that even though the query now gives me
the correct result I'm nut sure how to display this as a
running total on my invoice form...

thanks in advance

Regards steve...