|
|
Date Formula by
Aurora
I am using Access 2000
I have a query with a formula that basicly says -
DateSSigned: IIf( Is Null," ",Date())
(When the supervisor signs the date field
...
|
October 15th, 2004 07:29 PM
by JO
|
3 |
193 |
|
|
Date Formula ? Conditional on Day of Week by
sfleck
I have the following that determines the number of days from a specific date.
I would like to modify so that if the result lands on a Friday, Saturday, or...
|
June 5th, 2008 07:46 PM
by Klatuu
|
3 |
107 |
|
|
Date formula help by
Joe Cilinceon
I need help with this badly. I can't seem to get my mind around a way to do
it in a balance due query.
Here is what I need to do. Say someone is paid thru...
|
|
1 |
102 |
|
|
Date formulas by
Jessica
I need help with a date formula i have. I have three field one call Admin
Review which had the dates the review was done, then i have next admin
review, which...
|
November 7th, 2005 02:51 PM
by Ofer
|
1 |
62 |
|
|
date formulas by
skigal
I need to be able to search a table for any records that are equal to a given
date field and if no records have that date exactly to have it present the
next...
|
|
3 |
92 |
|
|
date from form by
Dale and Sandi Brown
I have a form with a text box that has a date in it. When I try to have a
query access this box it does not work. Not sure what is wrong. The where
clause in...
|
October 1st, 2005 12:00 PM
by Baz
|
5 |
101 |
|
|
date from text box as query criteria by
papa jonah
I have a text box called:
!!
I have a query that I want this text box to feed. I want the query to
look at everything that is greater than the entered...
|
|
1 |
68 |
|
|
Date Function by
Chris
I'm looking for a date function that I can use that will always just pull
the current month. Any suggestions?
Thanks,
Chris
|
|
3 |
118 |
|
|
Date Function by
Chris
Hi,
I have a field: DateLoggedIn, which stores the date when data is entered,
What I am looking for is a function, and how to apply this function, i.e. in
a...
|
February 29th, 2008 06:40 PM
by babs
|
7 |
204 |
|
|
Date Function by
rollover99 via AccessMonster.com
I am running a query from a table that limits the output of data to a
specific time frame. I am working on the last month minus 12 months. So
what I want to...
|
|
7 |
110 |
|
|
Date Function by
Chris
What is a good date function that I can use to grab the 13th month in a
period of time? In this case it would be January 06. I want this to be an
automated...
|
|
2 |
89 |
|
|
Date Function by
Goopie
Im currently using this:
=DSum("Cost","Stock"," DOD Between #01/07/08# And #31/12/08#")
I'd like to substitute the 08 to obtain the current year, as well as...
|
September 9th, 2008 03:51 PM
by Goopie
|
5 |
108 |
|
|
date function by
Chris
Hello all. This should be a pretty easy question. The following date
function I'm using gives me the date one year from the current date.
However, it only...
|
September 18th, 2009 06:42 PM
by Chris
|
3 |
117 |
|
|
Date Function by
lmossolle
I have a Querie that pulls the date from a table using a short date. I would
like to see only month and year. Can someone help?
|
|
1 |
73 |
|
|
DATE FUNCTION by
angie
i have a field named "credit". each client has multiple credits on various
dates.
i want to create a field (function) that shows the credit amount of...
|
|
1 |
79 |
|
|
Date Function by
Mahesh
Hi
I have a query which has the following fields.
Registration Number, Meeting Number, Client ID, Registration Date,
Attended, Cancelled, No Show, Date...
|
|
6 |
84 |
|
|
Date function in a query by
Sarah
=DATE(YEAR( ! ),MONTH(
! )+4,DAY( ! ))
This query returns the error that there the expression has the wrong number
of arguments - please help!
|
|
2 |
77 |
|
|
Date Function in query by
RoyS1031
I have two tables. One is INVOICES, the other is "INVENTORY. Each has a
DATEMODIFIED field. The dates in INVENTORY are formatted dd/mm/yyyy
hh:mm:ss. Yet...
|
November 20th, 2009 07:32 PM
by RoyS1031
|
3 |
150 |
|
|
Date Function in Query builder by
The Joker via AccessMonster.com
Hello All,
I have the following code in a query expression:
IIf ( ! = "Daily", Date(), IIf ( !
= "CD" , DateSerial(Day= ! ), WeekDay(Day+
! ) )
I am...
|
|
5 |
138 |
|
|
date function issue by
[email protected]
I am trying to extract data from a database through an access query.
One of the fields in my query has a time-stamp date (i.e. the date
entered in the database...
|
|
9 |
92 |