Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works

trouble making date query in Access

  • Please log in to reply



    New Member

  • Member
  • Pip
  • 1 posts
I'm am trying to do a task which involves making a query with a specific date in mind. Say for example this:

I'm a rep for a parent cheese company and I visit cheese companies from all over many areas. I am meant to visit once a month to each place. I have a table with Name of company, area, and date they were last visited.

What i'm trying to add in is say today is 18 march 2007 and the date i last visited all the cheese companies was all in feb except for say 1. Which i last visited on 2 Jan.

I need to make a query that will see that today is the 18 march and to calculate what companies have not been visited in over a month.

Can you help please :)

Sorry... been solved, please delete or close

Thank you

Edited by suprra, 19 August 2008 - 01:25 AM.

  • 0


Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP