Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
sql query to return records 45 days old
I figured it out... WHERE mycolumn > DATEADD('d', -45, now()) Works using ASP and Access DB for those out there that might need to know this.. Agmac -
sql query to return records 45 days old
Need help with an sql query that returns only those records in a table that are 45 days old. The table does have a date/time column (called re_time) that used the now() function to place the date/time into it. Agmac -
need help with SQL query
George, I think I got it... I am going to try it out... Thank you very much! Agmac -
need help with SQL query
I am trying to run a query off of a form where customers can choose from multiple items to select either a specific item or 'all' items froma a particular field, while being specific in others.. hope I explained that properly..:) For example.. Lets say, I have a database called "CARS" with 5...
