query date and greater than date

  • Thread starter Thread starter Bill Malmgren
  • Start date Start 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
 
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
parameter query for greater than date 8
Date Calculation and Formatting 3
Date Brackets as an IIf statement 3
sumif date is greater than or equal chosen date 2
Difference between two dates if greater than 14 1

Back
Top