Grand Totals

[Guest]

I have a report that is filtered by a form. I need to be able to get a count
of the total amount of items in the table including what is being filtered.

Thanks in Advance for your help!!!

 

[Rick B]

You would use criteria in your query to pull the data from the first day of
the year to the current date. I think it would be...

Between DateSerial(Year(Date()), 1, 1) and Date()

 

[Guest]

Rick, Where would I add this in the query?

thanks.

 

[Rick B]

Under your date field.

--
Rick B

Rick, Where would I add this in the query?

thanks.

 

[Guest]

Rick,
thanks, but this still not giving me a count of data in the table for my
report.

 

[Rick B]

You know, I just read through this post, and I don't think my responses were
intended for you. My post was intended for someone that asked a question
about year-to-date totals.

I am so sorry. Please disregard my posts.

You may want to repost your question because I doubt anyone will look at the
old one at this point.