|
|
Date expressions by
Robbie132
I would be grateful for some help in writing a date expression in a query and
report (Access 2003).
I need the query/report to display all records where the...
|
|
2 |
67 |
|
|
Date Expressions by
Alicia[_3_]
Does anyone know how to make an expression pull dates that are greater
that two months old? I'm looking at building a database that will
allow me to track the...
|
|
2 |
53 |
|
|
Date Expressions & Calculations by
Vylent Fyre[_2_]
Hello, everyone! :) It's me again.. *oh no!*
Seriously, I'm having some issues with getting the dates and expressions I'm
using to pull the right...
|
|
3 |
78 |
|
|
Date expressions that can exclude weekends by
michelle
When using the expressions
Date()-1
and
-
is there anyway I could get them to not count weekends?
Date()-1 works well until I need it to show Fridays totals on...
|
|
1 |
182 |
|
|
Date Expressions/Criteria by
V_Ernst
I am running a query and basing the results of that query on a Close Date
field in one of my tables.
I am using the normal expression for date range in my...
|
|
1 |
87 |
|
|
date extraction by
samuel
i have a value in a tbl -
2006022410503300
how do i convert this to a day of the week ?
|
|
2 |
85 |
|
|
date Field by
mccloud
I have a date field in a query pulling from our ERP system. I've used a
between statement in the past to get the data I need. I now have a need to
calculate...
|
|
1 |
109 |
|
|
DATE FIELD by
angie
i have a query that consists of the following fields and corresponding
criteria:
1) date field, criteria= between and
2) currency field, which stands for...
|
|
4 |
106 |
|
|
Date field by
John
I need a date field in a digits form so for example
3/12/2004, I need to be 03122004. Does anyone have a
formula or way already in a query to be able to take...
|
August 5th, 2004 05:41 PM
by Gassy
|
3 |
128 |
|
|
Date field by
horseman
I have Access 97. I am doing a database for someone. The database is for
travelling allowances. He has a Field called serial no. in this field the
serial...
|
|
2 |
71 |
|
|
date field - filtering by
dls25
This is what I have in a date field:
Between And
Is there a way I can enter the date simpler, maybe by using the calender
add-in, or an other way?
When...
|
|
1 |
70 |
|
|
Date field - automation by
[email protected]
Version 2002. How can I have the date field automatically adopt the
date of the creation of the record? I've checked the help file but
I'm either asking the...
|
|
3 |
66 |
|
|
|
February 16th, 2007 05:48 PM
by fredg
|
1 |
202 |
|
|
|
|
1 |
98 |
|
|
Date field in a query by
PJ
I have two date fields and I need the number of days from one date to the
other. My fields are and Date: . I want the
number of days between the two. So...
|
|
2 |
82 |
|
|
Date field in query by
klr
I need to add criteria to pull through all records where visit date is
current month and next 2 months (i.e. 01.09.06 to 30.11.06). Can
anyone advise what I...
|
|
2 |
73 |
|
|
|
|
5 |
94 |
|
|
Date Field problem by
Lucien
I have a table that I am trying to pull data from in where the table has many
fields. In one field my criteria is:
In...
( 1 2)
|
|
10 |
143 |
|
|
Date field problem by
Yanick
I created an Access 97 database a year ago and it always worked fine. Since
this morning, it does not work anymore.
I received the error : This expression...
|
March 28th, 2007 01:10 AM
by Yanick
|
2 |
67 |
|
|
date field question by
Database User
is there a criteria that i can put in a query
Date() - 1 Years
or
Date() - 2 Years
or
Date() - 1 month
or
Date() - 2 months
|
|
2 |
78 |