Item Count Query

  • Thread starter Thread starter Steven Smith
  • Start date Start date
S

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
 
Its OK guys, I figured it out from the Count Schools in
Districts query post made earlier...

Apologies for the waste of space...
 
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...
 
Back
Top