|
|
Date Labels by
Andy
I am trying to generate a master dates table that holds a number of groups
that a date may belong to.
Amongst them are some that I can create using date...
|
|
1 |
140 |
|
|
Date Last Changed by
FA
Please help.
I'm trying to produce a product price list from a table that records all the
price history for each item. The query should show only the last...
|
September 14th, 2005 12:37 PM
by FA
|
9 |
257 |
|
|
|
|
4 |
129 |
|
|
Date Limit in Crosstab from Union query by
Molasses26
Hello! I have a union query that links together multiple tables and it works
like a charm, however when I try to run a crosstab query based on it and
limit...
|
|
2 |
125 |
|
|
Date Limits Query by
NeonSky via AccessMonster.com
Good Afternoon,
I have a rather challenging question for your consideration. Please consider
my existing process/sample data....
...
|
|
1 |
115 |
|
|
Date lookup in Table by
JGal01
I have two tables. In one table, there are lines with various dates which
contain information that I will eventually summarize based on Fiscal Months.
In...
|
January 25th, 2006 08:16 PM
by JGal01
|
2 |
63 |
|
|
date manipulation by
angie
i have two date fields: expiration date and payment date.
i want to create an update query that updates records containing null
payment date value to ...
|
|
2 |
55 |
|
|
Date manipulation by
NetworkTrade
This works in a query design view column:
WeekOf:
IIf((Weekday()=1),(-6),(DateAdd("d",-(Weekday()-2),)))
It looks at the date field and assigns it to the...
|
|
3 |
140 |
|
|
Date Match by
George
In my data base I have everyones birtdates. How could I
write an expression to have a query find all records that
match todays month and date only.
Here is my...
|
September 17th, 2004 06:43 PM
by fredg
|
1 |
117 |
|
|
Date math in query - strange results by
David
My query returns:
OpenDate, CloseDate, DaysOpen
with
iif(NZ(T.CloseDate,"")="",Now() - T.OpenDate,T.CloseDate - T.OpenDate) AS DaysOpen
It seems to work when...
|
|
1 |
318 |
|
|
Date Math to Milliseonds by
Jack
Hello,
I noticed the datediff function will provide date math to the nearest
second, but how can I perform date math to the nearest millisecond?
Thanks in...
|
|
2 |
90 |
|
|
Date Minues Month by
Thorson
I currently have a query that sets the criteria of the records by a date
entered into a control on a form. I would like to create another query that
has the...
|
|
9 |
89 |
|
|
|
|
3 |
87 |
|
|
Date not coming up! by
mem
Hi, I am trying to get results in a query using the between two dates. (ie
between 1/1/2008 and 1/31/2008) The date is formated in date plus time. (ie...
|
February 5th, 2008 09:44 PM
by mem
|
7 |
77 |
|
|
Date not in list by
jdbit2byte
Say an input form stores data in these fields in tbl_Time:
EmployeeID
Date
LaborHours
TravelHours
What kind of query would I run on tbl_Time to find out which...
|
|
3 |
168 |
|
|
Date not within range query by
Cory
I am working with a database that has a number of related tables. The query
I am building only concerns two however. Entities and Last Seen. I have...
|
|
3 |
131 |
|
|
Date of Edit by
Claire
Hi:
On my query, I need to have a field that shows the date that a record was
updated, however, the date can not change until the record is changed. I...
|
|
3 |
222 |
|
|
Date of Local Machine by
Babadog
hello
My DataBase have one field i use Date/Hour the name is NASCIMENTO
In my querie i need return alls birthday using the Date of my local machine.
For...
|
|
1 |
96 |
|
|
Date of Month vs. Now by
Walter Steadman
Greetings again all,
I think I figured out where I need to go with the Date thing. In my
table tblPilot the Pilots Birthday is listed. His/Her Age is...
( 1 2)
|
|
10 |
494 |
|
|
Date or Time range by
LtFass
I am building a program for a fire dept to keep trak of thier daily log. I
have a form where the daily data is entered. below the form is subform bound
to a...
|
October 4th, 2004 06:23 AM
by LtFass
|
5 |
103 |