|
|
|
|
5 |
343 |
|
|
Date differences by
GiBB
Hello,
Im a little stuck trying to do a datediff query.
i have two fields "request date" and "done date", and i need the query to
show all records which...
|
|
1 |
86 |
|
|
Date Differences by
Mark
Hi all
Wondering if anyone knows how to do a date difference calc from a table that
looks like the following:
Date PurchaseName
28/01/2005 ...
|
|
1 |
58 |
|
|
|
|
5 |
181 |
|
|
Date Display by
Dez
I have a query set up to pull all employee weekly time records charged to a
certain category. I want to summarize the total hours charged to that
category...
|
August 31st, 2007 03:14 PM
by Dez
|
2 |
151 |
|
|
Date Error in linked tables query by
Keith in Australia
I am using access to link to tables within the database (SQL) of our company
software package, when writing a query I am unsuccessful when using a date
range...
|
November 25th, 2005 04:58 PM
by Chris2
|
9 |
88 |
|
|
|
|
8 |
69 |
|
|
Date Evaluation by
dave rivera
I am trying to evaluate how long it takes to complete tasks. Results can be
one of two - either the start date and end date are the same date = 0 or the
end...
|
|
0 |
67 |
|
|
Date Evaluation by
dave rivera
I am attempting to evaluate the number of days it takes to complete tasks.
Results can be same date for both start and end dates or end date greater
than...
|
|
1 |
73 |
|
|
|
|
4 |
247 |
|
|
date evaluation on Day and Month Only by
Walter Steadman
Greetings all,
Is there a way to get a query to look at Days and Months of a Date.
I have a field called Birthdate and another field called startdate
I am...
|
|
1 |
140 |
|
|
Date expression by
Mark[_9_]
Greetings all
I need to create a query that will add 30 days to another date field every
month. I need assistance with the expression.
As always, thanks in...
|
|
1 |
97 |
|
|
DATE EXPRESSION by
[email protected]
Can someone offer a date expression that will pull records of the
current month from a query which lists the dates as follows mmddyy
i tried Month=Now() but...
|
|
4 |
91 |
|
|
Date Expression by
Loggical via AccessMonster.com
I use this expression in the criteria in a Query. How can I modify it to
obtain records for a 24 hour time period? At present it produces records for
the...
|
|
9 |
313 |
|
|
Date Expression by
Candace
I need to add criteria to a query field so that the only records shown are
those for which 14 days have past from a date in a specific field. The
expression I...
|
|
2 |
74 |
|
|
Date Expression by
Chris
I have this Expression in a query which creates the following field:
ECPONumber: & "/04"
The 04 meant the year 2004. Now I need to have a 05 at the end of it,...
|
January 10th, 2005 03:17 PM
by Chris
|
4 |
121 |
|
|
Date expression in Query by
Steve Stad
I am getting 'undefined function' w/this expression in my qry.
Expr1: IIf(today(),"cur","exp")
How do I insert or use todays date in a Query.
|
|
4 |
195 |
|
|
date expression question by
Slez via AccessMonster.com
What kind of expression in the criteria of a date field would accomplish this?
I'd like to return related records of a date field where the value is...
|
|
1 |
70 |
|
|
|
November 27th, 2006 07:34 PM
by fredg
|
4 |
183 |
|
|
|
|
2 |
97 |