Me again,

Sorry to start new threads all the time but I have two problems that have been bugging me for a while and this is the second.

I run a report from a query that gives me a percentage breakdown of sales by product over a given period. In the query, the period is defined by week numbers (for example: Between "21" and "25") but because the sales are summed in the report, the dates do not show up.

Therefore, I wanted to place a date box in the Report header which pulls the week number through on the report. I read in another thread that this can be done by putting =([Week Number]) in an unbound text box, but because I use the Between "21" and "25" query search it only pulls through the first week number in the unbound text box.

Does anyone know how I can resolve this so that I can have a date range listed in the report header?

Thanks (again!),

Alex

Alex, I would just build a simple pop-up form for this and pull the values from text boxes for criteria and then reference them on the report as well...

Hope this helps - :)

How do you get the input from the user (what's the WHERE clause look like)?

Alex, I would just build a simple pop-up form for this and pull the values from text boxes for criteria and then reference them on the report as well...

Hope this helps - :)

Hi Ken,

Thanks for your response - could you please explain what you think I should do in layman's terms. Sorry but I have no experience in Access programming and do not know how to create a pop-up form.

Thanks,

Alex

Hi Ken,

Thanks for your response - could you please explain what you think I should do in layman's terms. Sorry but I have no experience in Access programming and do not know how to create a pop-up form.

Thanks,

Alex

OK - I created a pop-up that gave me an option to put a date i, but the reports are being run over a date RANGE.

Does anyone know how to create a pop-up box that lets you put in a date range to pull the records from?

Any help would be very much appreciated! :)

Thanks,

Alex

Alex - In a nutshell you simply create two unbound text boxes, one for the beginning date of the range and the other for the ending date. Then use these as criteria in the reports underlying query.