Access 2007 database query question
I have imported a 2007 excle spread sheet. There are mutible columns that have date information. I need two types of gueries. First query to look at one column and only list records that have todays date, previous dates and dates through 7 days in the future. the query also need to reference a 2nd column and only allow the records that do not have a date at all. Example: column A date is 6/3/11 and there is no date in column B = list record. Second query should list record is a date is in column C and no date in column D
Software/Hardware used:
2007 access
Software/Hardware used:
2007 access
ASKED:
June 1, 2011 11:39 AM
UPDATED:
August 17, 2011 1:28 PM
Answer Wiki:
Download the free program Expressor and have them do their free webinar. If you have the excel doc they will base the webinar off that and teach you everything you need to do. <a href="http://www.expressor-software.com/">Expressor
To see all answers submitted to the Answer Wiki: View Answer History.
That is very basic.
I’m sure many community members could (and probably will) give you the complete answer, but I think it would be better if you learn how to do it, so you don’t need to ask for help any time you need something similar.
Take a look at these pages:
Writing SQL Queries: Let’s Start with the Basics
Access – Tables & Queries:Select Query
My suggestion: Try to do it by yourself, and post any specific questions/problems you encounter.
9899543860: You asked the same question in 3 different threads. Please don’t do that.
Asking the same question many times won’t get you more or better answers.
To make sure your question gets the attention it deserves, please Create a New Question (include as much details as possible, and some example data).
Disregard my previous comment. I was referring to a post that has been deleted.