|
|
Date Function Not Available by
Sash
I've been running an application for 2 years with many Date functions.
Recently the machine was upgraded to Windows 2000 (not sure if it's related)
and now...
|
September 14th, 2004 04:48 PM
by StCyrM
|
2 |
178 |
|
|
Date function problem by
Alan Ibbotson
I am trying to return the current date.
Using VBA, in an event procedure I have:
MsgBox (Date), I have tried entering Date() but it reverts back to...
|
|
3 |
116 |
|
|
|
|
1 |
107 |
|
|
Date function voodoo in my query by
chris23892 via AccessMonster.com
I'm pulling my hair out...In my query, I want to use the following criteria
to filter:
"Sort all records in the past 7 days from a specific date". I can not...
|
|
7 |
101 |
|
|
date functions by
Mitchell_Collen via AccessMonster.com
Does anybody know how to calculate dates? I believe that it can be done
however, I am not sure where to start.
I have admit date and discharge date on several...
|
|
2 |
205 |
|
|
date functions by
kate
I have a query that is looking at a text filed showing a date like this
19990431 I need that format changed to be a date field so i can run a start
date and an...
|
|
2 |
107 |
|
|
date gaps by
buckpeace
I am trying to count members that may have had a gap in enrollment of 30
days. How can I write a query to show me which members had gaps in
enrollment. ...
|
|
3 |
77 |
|
|
Date Generation. by
Bill
Hi,
Probably a numpty question but .....
I need a query to generate a list of dates of every date in the year. Is
there a way to do this that is independent...
|
|
2 |
113 |
|
|
Date greater then two weeks by
Lp12
Hi All,
i have a query with OpenDate as date.
I want to show the records where the OpenDate is greater than two weeks time
(in the criteria)
How can i...
|
February 12th, 2006 07:47 AM
by Lp12
|
3 |
101 |
|
|
Date group by
dogpigfish
I used a crosstable query to combine information. I need to know how to
combine all date groups of the same date. I may have two or three fields of
5/05/05,...
|
|
1 |
119 |
|
|
Date Grouping Query by
Kenny Holden
Hi List,
I have a table of tasks;
tasks
====
task_number
task_opened
task_closed
|
|
1 |
86 |
|
|
Date Groups by
Justin
I'm creating a report for total sales. The user will enter the date range
and time period (days, weeks, months, years) for the grouping. This all
works...
|
|
1 |
164 |
|
|
Date Help by
Raj
I have a corsstab query that give the orders completed for today and
yesterday. What I need help is on Monday have it show the totals for Friday
with me having...
|
October 13th, 2004 06:01 PM
by Raj
|
6 |
121 |
|
|
DATE HELP by
Alan
Hello All
Sorry but really struggling with this Date Query
I have a table that holds Dates and times (General Date Format) of various
daily server logs that...
|
|
2 |
156 |
|
|
Date help please by
golfinray
I asked this question yesterday, but everything I have tried still isn't
getting me what I want. I have 7 columns of dates that are dates that mark
stages in...
|
|
4 |
84 |
|
|
Date Help Request by
Cy
I hope someone might be able to offer some assistance. I posted a
similar post, but the solution provided didn't work.
Here here goes.
We have crews that go...
|
|
1 |
117 |
|
|
date in a query by
soj
I am using Office XP or Office 2000 Premium.
On some of my compagnys computers, the expression for today, date(), is
accepted in a query, and on other...
|
|
1 |
141 |
|
|
date in a sql statement by
Joel
What is the criteria to put a data in a query. I what to have the user
select the correct date. I've tried
##
Please help me out.
thanks
|
May 25th, 2005 09:01 PM
by Rick B
|
1 |
84 |
|
|
Date in Access field is ######## by
CSR@AEWJL
I recently ran a query based on the date field. Ever since then, some of the
dates in the field show up as ###### instead of the date I originally
entered. ...
|
|
1 |
171 |
|
|
Date in Field Returns Y for Yes by
JanetF
Hello,
I have a query in which there is a date field. I need to write a SQL
statement that says if there is a date, then populate the field with a "Y"
for...
|
August 17th, 2005 05:30 PM
by JanetF
|
3 |
114 |