Compare a query to a table

  • Thread starter Thread starter Scott
  • Start date Start date
S

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
 
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



Scott said:
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
Click to expand...



.
Click to expand...
 
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



Scott said:
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



Scott said:
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
Click to expand...



.
Click to expand...
Click to expand...
 
Back
Top