query date and greater than date

B

Bill Malmgren

Please reenter this question. I somehow deleted it off my computer and do
not know if an answer was sent.
----- Original Message -----
From: "Bill Malmgren" <[email protected]>
Newsgroups: microsoft.public.access.gettingstarted
Sent: Saturday, February 05, 2005 10:06 AM
Subject: query date and greater than date
 
R

Rick B

You don't need to look on your computer. Go look at thenewsgroup, or do a
Google search.

You only got one response. It is...

------------------------------------------------------
You didn't post any specifics about what you're doing, but guessing that
you're putting the ">" operator character into the table with the date
string...don't do that. Operators cannot be "inserted" as characters this
way unless you build the SQL string in code.

Just write your query with the > character in it, and get the "greater than"
date value from the table.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

query date and greater than date 1
MS Query - Filtering all dates greater than the current date 1
Minimum Date Greater Than Observation Start Date 2
Date Calculation and Formatting 3
parameter query for greater than date 8
sumif date is greater than or equal chosen date 2
Date Brackets as an IIf statement 3
Counting if Date1 is after and Date2 is before another date 5

Top