|
|
Date Problem by
Bryan Hughes
Hello,
I have a query that searches for the last date meeting a certain criteria.
This query works fine.
' EED = Ending Eligibility Date
' LstCAD = Last Case...
|
|
1 |
177 |
|
|
Date problem by
golfinray
I have 7 fields (columns) of dates in a table, one for each event that occurs
in a project. I would like to know how many projects where all 7 were null on...
|
|
2 |
71 |
|
|
date problem by
Jean-Paul
Hi
In following SQL i have a date-problem:
sql = "SELECT .Datum_bezoek, .Naam, .bezoeken, .Datum_bezoek
FROM WHERE .Datum_bezoek Date And
.Bezoeken...
|
|
1 |
74 |
|
|
Date problem by
julief
I have a table into which I import a date field, this is set to short date in
the property but does import in ddmmyy:hhmm format, some records import with...
|
|
7 |
131 |
|
|
Date Problem by
Neill M. Pinkney
Access 2003 on Windows XP Pro
I have a date field in a query, with the crriteria:-
Between !!txtStart and !!txtEnd
I have a form (frmReports) with two text...
( 1 2)
|
|
11 |
223 |
|
|
|
July 21st, 2004 07:42 AM
by Philip
|
3 |
97 |
|
|
date problem in parameter query by
anil
hi all
i have written a query as follows:
SELECT LabData.ParameterName, LabData.SAMPLE_NO, Month()
AS AMonth, Year() AS Ayear, LabData.RESULT
FROM...
|
May 8th, 2006 01:07 AM
by anil
|
6 |
109 |
|
|
Date Problem in query result by
Anver
Dear all,
I have the following fields
order-id value items date
1 100 item1 10/2/07
2 200 item2 15/2/07
3 ...
|
|
1 |
83 |
|
|
Date problem Urgent please by
Trever B
I have a imported file that reads all fields as text.
My problem is that I have 3 text fields and need to turn answer into 2 date
fields by an append...
|
|
3 |
79 |
|
|
Date projections by
KevinS
In my database is a certification field that should be less than a year old.
I would like to project which certifications are going to expire in the next
3...
|
June 2nd, 2009 07:18 PM
by KevinS
|
4 |
107 |
|
|
Date prompt input mask in query by
Zachry1
During query, i have a Between date parameter. The user gets prompted "Start
Date" then "End date" but neither of these take on the input mask, so the
use has...
|
|
4 |
233 |
|
|
Date queries by
Kirk P.
I'm querying a table with subscription information that contains customerID
and end date. I want to query for all subscriptions ending in December, so
I'm...
|
|
1 |
81 |
|
|
Date queries by
woods1119
I have tried all the angles I can think of to get this query(ies) to work but
to no avail.
I have tPtData and tVisit. I need information from both...
|
|
3 |
119 |
|
|
Date Queries by
Iluzion74
Hi,
I am having a real problem with birthday queries. Just started using access
a week ago.
1. List all your contacts who have birthdays in December or are...
|
|
3 |
130 |
|
|
date queries by
Bob Griendling
I have a simple table of dates over several years and two fields of prices
in dollars for each date. I want to write a query that would look at ONLY
dates...
|
|
7 |
88 |
|
|
date queries by
JayneHampson
I am setting up a training database with multiple training dates where
updated training needs to occur every 3 years.
Two types of training a basic and an...
|
|
1 |
64 |
|
|
Date Queries within Travel Database by
John Buckingham
Hi ....calling all access experts!
I am responsible for maintaining a UK based travel database which retains
comprehensive information about overseas...
|
|
3 |
106 |
|
|
Date Querry by
jb ellis
My db has a birthday field in short date format (mm/dd/yyyy).
How do I querry for all birthdays in say Jan, regardless of day or year?
|
|
4 |
140 |
|
|
date quert by
debbie813
how to get the number of years between a date and a "start" date already in
table
|
|
1 |
61 |
|
|
date query by
lez
I am trying to run a group query Where the date is Now() and want a count of
date to show the numbers of calls made.
I have tried the obvious:
SELECT...
|
May 1st, 2008 06:08 PM
by lez
|
2 |
81 |