Conditional Query Data in a Report

S

silva

Is there a way to include the search criteria from a query in a report?

More specifically, I use a date condition in a query to produce a report,
and I'd like to add the date entered in the message box to the report. Is
there a way to do that?
 
J

Jeff Boyce

If you are trying to do this using only a query and a report, I'm not
familiar with a way.

If you want to do this, the one way I know of is to use a form to "collect"
the criteria that your query uses, then refer to the value entered in the
form from within the report.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
F

fredg

Is there a way to include the search criteria from a query in a report?

More specifically, I use a date condition in a query to produce a report,
and I'd like to add the date entered in the message box to the report. Is
there a way to do that?
Click to expand...

I think you mean you are using a parameter prompt in the query to
filter the records and you wish to show the parameter dates in the
report.
If that is correct, then, assuming the query criteria was:
Between [EnterStartDate] and [EnterEndDate]
add an unbound text control to the report Header.
Set it's control source to:

="For sales between " & [EnterStartDate] & " and " & [EnterEndDate]

The text within the brackets must be identical to the bracketed text
in the query parameter.
 
K

KARL DEWEY

You can use calculated fields like this --

Report Start: [EnterStartDate]
Report End: [EnterEndDate]
Or like this --

Report Period: [EnterStartDate] & " through " & [EnterEndDate]

The text within the brackets must be identical to the bracketed text
in the query parameter.


As fredg said the text within the brackets must be identical to the
bracketed text in the query parameter.
 
S

silva

Yes, this is exactly what I was looking for. Sorry, I forgot the term
"parameter", I suppose that would have helped clarify what I was asking. But
yes, this fits what I was looking for perfectly.

fredg said:
Is there a way to include the search criteria from a query in a report?

More specifically, I use a date condition in a query to produce a report,
and I'd like to add the date entered in the message box to the report. Is
there a way to do that?
Click to expand...

I think you mean you are using a parameter prompt in the query to
filter the records and you wish to show the parameter dates in the
report.
If that is correct, then, assuming the query criteria was:
Between [EnterStartDate] and [EnterEndDate]
add an unbound text control to the report Header.
Set it's control source to:

="For sales between " & [EnterStartDate] & " and " & [EnterEndDate]

The text within the brackets must be identical to the bracketed text
in the query parameter.
Click to expand...
 
Top