|
|
date query without year by
Ian
I have a series of dates spanning several years and I'd like my where clause
to limit the dates between Nov 1 and Apr 30 regardless of year. Is there a
way...
|
|
3 |
153 |
|
|
Date Query-show records 1 day old. by
naiveprogrammer
I have a db that needs to show all records that are over a day old. Yet my
query isn't working. It shows records that are over 2 days old. Can someone
tell...
|
October 27th, 2005 09:23 PM
by Ofer
|
1 |
87 |
|
|
Date query...again by
woods1119
SELECT tPtData.ingPtID, tPtData.strLastName, tPtData.strFirstName,
tPtData.strFrstSeen, tVisit.dtmVisitDate, tVisit.,
tVisit., tVisit.ysnLimbLoss
FROM tPtData...
|
|
2 |
66 |
|
|
|
|
6 |
80 |
|
|
Date Question by
scott04
Hello everyone,
I have a database that has two fields that are used in order for a record to
be complete. The are DateSatRsp (Date of Satisfactory Response)...
|
|
2 |
90 |
|
|
Date question by
Amin
How do I query for all dates after a certain date?
e.g.
WHERE DateField 11/01/2008
This is data mismatch obviously. How should I be writing...
|
|
2 |
60 |
|
|
Date Question by
Gary F Shelton[_2_]
I have pulled some fields out of our mainframe which a
Century Year Month Day
So in Access I first tried to perform a Cdate of Date:...
|
|
4 |
78 |
|
|
Date question by
[email protected]
I have a date field, I want to lookback 15 days from today for all
PO's, in the criteria what would I put in there? I know theres a
dateadd is there a...
|
|
3 |
93 |
|
|
Date Question by
Terry
Hi, I have a file in which I have an order date column, the date is in the
form of MM/DD/YYYY, what i am trying to do is to find all files More then a
month...
|
|
2 |
95 |
|
|
Date question by
Crystal McKee
I am sure I am making this much worse than it should be, but what I am trying to do is this:
I have a form that is a menu for selecting reports. There is an...
|
|
2 |
251 |
|
|
Date question by
confusedinc
I am trying to figure out how I can produce the following:
I need to show accounts that have (0)zero days left before they need to be
paid.
I have created the...
|
|
4 |
67 |
|
|
Date question by
taft71
I have 2 calculated date field which sometimes end on Saturday or Sunday.
When that happens I would like them to end on the prior Friday. Any help?
|
March 16th, 2005 04:09 AM
by Spectra
|
4 |
115 |
|
|
Date question by
Spectra
I have 2 dates, date delivered & date due. The date due is the date delivered
+ 3 days. If the due date ends up on a Saturday, I want to add 2 days to the
date...
|
March 22nd, 2005 12:30 PM
by Andreas
|
5 |
477 |
|
|
Date question formula by
Fly Boy 5
I have a field for date of service and another field for invoice date. A
date range is entered for date of service and I need to allow invoice dates
between...
|
|
4 |
147 |
|
|
Date Question, not sure which forum by
Walter Steadman
Greetings all,
I have built a DB that tracks pilot hours and it is working (but very
clunky, and bad design). Here is where I am stuck.
Pilots hours are...
|
|
2 |
78 |
|
|
Date Question... by
116
I am trying to create a query to give me the results from the first weds of
each month back to the following day after weds. Having trouble formatting
the...
|
May 18th, 2010 12:36 PM
by 116
|
5 |
915 |
|
|
Date Questions in a Query I think by
Walter Steadman
Hello all,
I have posted a question similar to this before, but I did not
understand what the responder was conveying so going to post again.
I have a...
|
|
4 |
97 |
|
|
Date questions in query by
Tami
I know this has been asked before, but I still can not figure out how to do
it. Sorry,
I have three tables
Job Costing, Employee & Pay History
Job...
( 1 2)
|
|
12 |
134 |
|
|
date quieries by
Shirley
I have a parameter querie set up to ask for dates between beginning and
endding date. "7/1/2008 through 7/31/2008" and when you enter those dates,
wyou get...
|
|
2 |
77 |
|
|
Date range by
AlbertaRose
I am having issues with my reports pulling information between dates from my
queries. It doesn't seem to be recognizing there are parameters in those
fields...
|
|
3 |
93 |