Parameters

[TanisAgain]

I have created a report from the results of a query. The query has 2 parameters.

SELECT Nonconformances.DateRaised, Nonconformances.Customer
FROM Nonconformances
WHERE (((Nonconformances.DateRaised) Between [Enter start date] And [Enter end date])) OR (((Nonconformances.Customer) Like [Enter customer name] & "*"));

Now the problem is that I have been asked to add the search criteria to the report header. If the search criteria came from a form, no problem, but the user enters the criteria into a parameter box generated by the query. So if the start date was 1/5/05 and end date was 31/12/05 and the customer search was F.C, how do I capture this and show it on the report?

Any help appreciated.

 

[KenHigg]

I'm affraid your best option here is to bite the bullet and do a form...

 

[MStef]

Look at "DemoRptCriteriaA2000.mdb".
Open Report1, Enter From = 200, Enter To = 500.

 

[KenHigg]

Look at "DemoRptCriteriaA2000.mdb".
Open Report1, Enter From = 200, Enter To = 500.

Cool - Never thought of doing it that way. Thanks for the tip

 

[MStef]

Hello Ken!

I always learn something new, too.

 

[TanisAgain]

Excellent. I thought I would have to do a form!

Many thanks for the help.

David

 

[LLB]

Look at "DemoRptCriteriaA2000.mdb".
Open Report1, Enter From = 200, Enter To = 500.

I'm having the exact same issue, but am stuck with A97. Can this solution be converted to A97 and would it work for A97?

 

[MStef]

Hello LLB!

Here it is.

 

[LLB]

Thanks so much.... worked brilliantly, and of course, so simple.

In my case the parameter is a date. Is there an equally simple way to get the formatting to work for the text box that holds the parameter?

 

[MStef]

Hello LLB!

I don't know what's the problem with Date,
look at Demo a new one. Look at Query2, Report2.
For criteria write a date from and date to.

 

[LLB]

Thanks for posting the sample. This illistrates the problem. If you change the formating to Medium Date for example, the paramater field will still only show exactly as entered. Is there a way around this? Can it be formated in the query criteria?