Access 2007 database query question

10 pts.
Tags:
Access 2007
Access 2007 functions
Access Database
Access query
QuerySave
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

Answer Wiki

Thanks. We'll let you know when a new response is added.

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

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • carlosdl
    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.
    68,820 pointsBadges:
    report
  • carlosdl
    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).
    68,820 pointsBadges:
    report
  • carlosdl
    Disregard my previous comment. I was referring to a post that has been deleted.
    68,820 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following