printing criteria dates

[tcommis]

hello all - kind of new at access but know enough to get around.

I have a report being generated off a query that is asking for a start and end date. Problem is I can't display the dates (or don't know how too) because it screws up my sum command. no big deal in the query but I need that criteria printed on the report and can't seem to figure out what I need to do to get that done. I've looked though the post and didn't see anything address it. Am I missing something? Thanks in advance for any help.

Tcommis

 

[jtvcs]

If your query has parameter questions when you run the report (that's how you're providing the Start and End dates) then in the report place a text box for each and for the Control Source property type in =[same phrase you used in query parameter question]. HTH JT

 

[tcommis]

Jt - I tried that, but because I'm hiding the date in the query results it doesn't show up in my control list in my report. If I unhide the date in the query - yes it prints out, but then my query doesn't sum correctly. I'm really not sure if its a report problem or query problem, but thats for the help

 

[tcommis]

JT -- disregard my last post -- it worked! i must have been doing something wrong

Thanks Again!