=sum(IIf fields in a date range query

[weeblebiker]

I think there is a little miscomunication.
I just want the dates I enter into the "enter parameter value" popup to apear on the form or report so when I print it out the paper has the date range on it, not to be able to enter the dates in a field on a form or report and those entries are used as the parameter values.
I was thinking of Dlookup([]), but I don't know what or where the date is I'm looking up are, since the date is nested in the criteria line of a query field.

Does that make enough sense?

btw I'm not sure of this forums edicate: I'm are way off initial topic now! When should I be breaking the thread and starting a new thread?
The vw automotive forums I frequent are kinda picky about this as going off topic and thread jacking make information harder to search for by other people, which leads to repetitive Q and A threads.
I actually did spend some time searching here before I posted.

 

[Brianwarnock]

This thread has not been hijacked or gone off topic.
You asked that the date parameters appear in the report.

The best way in many peoples opinion to run queries and reports that have input parameters is to use a form.
The parameters are entered in textboxes that can have formatting and validation, they can be used multiple times, and can be passed to a report.
I personally view popups as the cheap and nasty way, and are a damn pain during testing.

Brian

 

[vbaInet]

The best way in many peoples opinion to run queries and reports that have input parameters is to use a form.
The parameters are entered in textboxes that can have formatting and validation, they can be used multiple times, and can be passed to a report.
I personally view popups as the cheap and nasty way, and are a damn pain during testing.

Brian

I concur. I never use them.