Compare a query to a table

[Scott]

I am trying to have a query read a date field from a
different and separate table and provide back a comparison
(a list of records that match the table date). For example:

=[Query]![Date]<=

![Date]

When I run the query it prompts me to enter a parameter
value for the date and even if a date was entered no data
is provided. The date field in

![Date] has a valid
date entered.

Any help is appreciated.

Scott

 

[Lynn Trapp]

Is there just one record with one date in the table you are using for
comparison?

 

[Scott]

Yes, but the date will change and I would rather not have
the users enter a date.

-----Original Message-----
Is there just one record with one date in the table you are using for
comparison?

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm

I am trying to have a query read a date field from a
different and separate table and provide back a comparison
(a list of records that match the table date). For example:

=[Query]![Date]<=

![Date]

When I run the query it prompts me to enter a parameter
value for the date and even if a date was entered no data
is provided. The date field in

![Date] has a valid
date entered.

Any help is appreciated.

Scott

.

 

[Lynn Trapp]

Then give this a try:

Select *
From YourFirstTable
Where YourDateField = (Select ComparisonDate
From ComparisonTable);


--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm

Yes, but the date will change and I would rather not have
the users enter a date.

-----Original Message-----
Is there just one record with one date in the table you are using for
comparison?

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm

I am trying to have a query read a date field from a
different and separate table and provide back a comparison
(a list of records that match the table date). For example:

=[Query]![Date]<=

![Date]

When I run the query it prompts me to enter a parameter
value for the date and even if a date was entered no data
is provided. The date field in

![Date] has a valid
date entered.

Any help is appreciated.

Scott

.