|
|
Date Query by
Stefan
I would like to create a filter in my query that returns all days in a month
from 2 months ago.
Example. it is July so I want to return all values with any...
|
|
3 |
65 |
|
|
Date Query by
Sandra P
I have a start date field and an end date field which are service dates.
What I want to be able to do is a query that says I want all records returned
for...
|
|
4 |
71 |
|
|
Date query by
Matt Dawson
I currently have a query that lists all contracts set up in a certain month.
However, what I need to do is not have just the month that the start date
lies...
|
|
1 |
182 |
|
|
Date query by
ExcelDummie
New to access, doing a query to find out who has done first aid
qualifications. Have done this but need to show people who have valid
qualifications so the...
|
|
1 |
81 |
|
|
Date Query by
mazbaz
I am having trouble retrieving all records between the first day and last day
of a month. I am using == where and
are fields in a Table of all months...
|
|
5 |
95 |
|
|
Date Query by
Vinnie
Hi,
I've got two tables:
(1) Rate table - details the rate charged from a certain date (two columns:
date and rate)
(2) Transaction table - details...
|
|
1 |
62 |
|
|
Date Query by
terry
I am making a Database with client occupying a room at a date (Date In) and
leaving the room at a date (Date Out). I need a report to list which client
is in...
|
January 12th, 2007 04:34 PM
by terry
|
2 |
138 |
|
|
Date Query by
Travler
I have the following query which should return records more than 14 days old
for loaned equipment. The query is as follows:
SELECT AD_LOANEDASSETS.AssetNumber,...
|
|
3 |
76 |
|
|
date query by
Steve Scott
I want to compare two dates so that the query only returns records for dates
that do not apear in the same month. eg 1/3/06 compared with 15/3/06 would
not be...
|
March 8th, 2006 04:30 PM
by Darren
|
2 |
77 |
|
|
Date Query by
Chris Simpson
I am having some problems getting a Date lookup to work properly. I am using
code from http://allenbrowne.com/casu-08.html method #2. It all works fine
until...
|
|
0 |
80 |
|
|
date query by
naulerich
I have a table with the following data:
2/12/2006 235556 5/18/2006
I need to trend the tickets opened weekly for a...
|
|
8 |
91 |
|
|
Date query - link w/Oracle by
mary
I just upgraded from Access 97 to Access 2002. I have tables linked with
Oracle 8. In the old version of Access, this query worked:
StartDate: =Date() And...
|
|
1 |
97 |
|
|
Date query - simple by
Ken Smedley
I have used a simple query for years to sort records by by date:
#mm/dd/yyyy#. I've reloaded Access 2000 and the existing DB on a new
computer and now it...
|
|
3 |
86 |
|
|
date query / multiple fields by
MARTIN95
i have one table with lastname, first name, (10) date fields with a service
and price field connected to each date.
i'm trying to create a weekly sales report...
|
|
1 |
73 |
|
|
Date Query again... by
Angie K.
I posted yesterday the message below about a function to
find out the current workweek for a deadline list. The
answer below helps me find out the weekday,...
|
|
1 |
221 |
|
|
Date query allowing user to enter dates by
No1momof3
HI
I have a DB where I am trying to set up a search criteria using 2 tables and
one field out of each.
Table - Services Field - Service
Table -...
|
|
1 |
331 |
|
|
Date query and previous year by
David
Hello all,
I have this query which works fine when the start date is 1/1/2007 and end
date of 7/6/2007. When I use a start date of 12/31/2006 and end date...
|
|
5 |
99 |
|
|
Date query criteria by
Andy Bailey
I'm trying to put together a query that will find records between two dates.
The two dates are entered via a form and, if cleared, should return...
|
|
4 |
86 |
|
|
Date query Criteria by
Dave
Access 2003
In a query with a date date field I need to limit to dates since the most
recent Sunday
date()-7 does not work as that limits to the last seven...
|
|
4 |
74 |
|
|
|
|
1 |
322 |