I have a membership table with a subdata table (one membership to many years) containing one column for subscription paid date. How do I filter/query who...

I wish to have a query that gives me a range from a date to a date ie all records between and I cannot find how to do this, help please TIA Steve

I wish to have a query that gives me a range from a date to a date ie all records between and I cannot find how to do this, help please TIA Steve

I wish to add a +60 day ireld for a query from a field called . this to automatically add 60 days from the date in ideas please TIA steve

I wish to run a query that adds 60 days to a date. ie +60 Days ideas please TIA Steve

Can someone suggest how to take a date field and search for all records that are = 3 months from today? i'm not sure how to handle this and the expression...

I need to select all records where the date is more than 3 years old. I've tried "5/1/06" and "Before 5/1/06" and neither seemed to work. Please help. ...

Dear All I sent in this post a little while ago :- I have a field which contains a due date for an inspection. This date can be between now and a year from...

I would like to set a query whereby I will locate data that will occur on a future date. That is, if I have a date field with 01/01/1999 and that data...

I wish to have a query that gives me a range from a date to a date ie all records between and I cannot find how to do this, help please TIA Steve

I want to make a date query. I have multiple records that are the same except with different dates. How would I write a query that would display the last...

I am having difficulty running a simple date query. I have two tables and they both have target date and completion date columns. I am trying to build a...

In Access 2003, I want to make a query that selects records based on a date. I have a form with a combo box labeled: "All Records Since:" The choices...

There is a database that has the following: Date of Notification to Sponsor field Date Case Closed field I need to calculate days open - I put this info in...

hi how can i make a query which will automatically run 2nd tuesday of every month. Can some one help me on this please. thanks in advance --

I need to create a query that gives me everyone who has a start date that is 45 or more days old. The field that I am querying is Start Date and the format is...

I have a table that includes a date field txtexpirydate with dates in the future. I want to set up a query that finds all records where the date field is in...

I am trying to write a select query to return records within 10 days of being due. For example, my field name is SA_To_Be_Mailed_Date. I would like to have...

Hi I'm trying to write a query that selects records based on a date range and Uses the Date of Birth if the Date entered is blank (null) or uses the date...

I always have trouble with date fields. I realize it is a pretty simple query, but could someone give me (a generic) expression to calculate what a date...