Help - parameters will not show in report!!!

[ericschramm2000]

I'm tryin to have my Beginning Date and Ending Date parameters show up in a report. The report is based on a query (call it query #1). Query#1 is based on two queries (#2 and #3). The parameters stem from Query #2, which inturn proceeds to #1 and to the report.

How do I show these dates on my report?

I've searched the forums with no luck, everything is spelled correctly, I have and "=" before the expression, and I've been trying to use the forms:

=Reports![Report Name]![Beginning Date]
=[Query #1]![Beginning Date]
=[Query #2]![Beginning Date]

none of which work. I just get either the #Name? or #Error? messages.

BTW, my tables are linked from an ODBC database, but I don't think that has anything to do with it.

 

[FoFa]

The dates will have to passed through all the way to the query the report is based on (Query 3). But where are you getting these dates from? If they are input on a form, and the form is open you could pull them from that also using the =FORM!MyFormName!MyControlName. There maybe other ways to obtain these elements depending on how you feed them to the queries.

 

[ericschramm2000]

The dates will have to passed through all the way to the query the report is based on (Query 3). But where are you getting these dates from? If they are input on a form, and the form is open you could pull them from that also using the =FORM!MyFormName!MyControlName. There maybe other ways to obtain these elements depending on how you feed them to the queries.

The dates are from Query #2. See Query #1 takes data from both #2 and #3. #2 and #3 take data from linked tables. In the criteria section of a date field in Query#2 I put in the following expression :

Between [Beginning Date] And [Ending Date]

Which works great for narrowing down the results of both Query #2 and Query #1 to data between those dates.

For my end result, I want to have a chart (report) that is based of of Query #1. So, you will have to enter the beginning and ending dates to narrow down the results that are displayed in the chart. I've got that part down fine. The thing I'm stuck on is how to document the Beginning Date and Ending Date on the chart. I don't have this in any forms.

 

[FoFa]

Well, you don't have visibility of these dates to the report. So you could use a form to supply the dates, and your query (#2) could reference the form fields instead of asking for the dates, then you could also use them in the report. The only other thing you could do , is use the MIN(date) and MAX(date), but this may not give you the date range used if there is no date on the actual date input. The form input is better.