Make Parameter available for querie based report

[Steve Roberts]

I need to use a parameter to enter a date in the following query. I want the
Parameter to also be available for a report that's based on this query. When
I use this query, it prompts me twice instead of just using the [Enter Start
Date] AS StartDate parameter that I already entered.

Any ideas?

Thanks Steve

SELECT Manhole_ID.Last_Maintenance_Date, Manhole_ID.Diameter, [Enter Start
Date] AS StartDate

FROM Manhole_ID

WHERE (Manhole_ID.Last_Maintenance_Date > StartDate);

 

[Duane Hookom]

Have you tried:
SELECT Manhole_ID.Last_Maintenance_Date, Manhole_ID.Diameter,
[Enter Start Date] AS StartDate
FROM Manhole_ID
WHERE (Manhole_ID.Last_Maintenance_Date > [Enter Start Date]);

 

[Michel Walsh]

Hi,


In Jet, the WHERE clause cannot recuperate aliases defined in the SELECT
clause. Try

WHERE (Manhole_ID.Last_Maintenance_Date > [Enter Start Date]);


Hoping it may help,
Vanderghast, Access MVP

 

[Steve Roberts]

Thanks guys that fixed it.

It was so easy I couldn't see it!

Hi,


In Jet, the WHERE clause cannot recuperate aliases defined in the SELECT
clause. Try

WHERE (Manhole_ID.Last_Maintenance_Date > [Enter Start Date]);


Hoping it may help,
Vanderghast, Access MVP

I need to use a parameter to enter a date in the following query. I want
the Parameter to also be available for a report that's based on this
query. When I use this query, it prompts me twice instead of just using
the [Enter Start Date] AS StartDate parameter that I already entered.

Any ideas?

Thanks Steve

SELECT Manhole_ID.Last_Maintenance_Date, Manhole_ID.Diameter, [Enter
Start Date] AS StartDate

FROM Manhole_ID

WHERE (Manhole_ID.Last_Maintenance_Date > StartDate);