Adding Year-to-Date Data

P

PAJ

I have a report where a parameter asks for a begin date (01/01/05) and end
date (1/31/05) that shows sales by customers for that range. Now I would
like to include year to date (01/01/05 - 2/28/05) sales data to my report.
How do I do this? Thanks
 
S

Sprinks

Create a Totals query that groups by customer and sums the Sales field, with
the following criteria:
=DateVal("1/1/" & Year(Date())) AND < =Date()
Click to expand...

Save the query, and create a new query joing the prior query to whatever
tables you need, linking by the Customer primary key.

Hope that helps.
Sprinks
 
V

VAP

Your parameter field refers to a date field? Remove the parameter from that
field, add the field again to the query and use the function year in front of
the field. Make the criteria for that field to be 2005 and that should
always give you year to date
 
V

VAP

Couldn't you remove the paramter from the date field and put the function
year in front of the date field and make the criteria to be 2005? This
should always give you year to date info.
 
Top