A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Post New Thread
Threads in Forum : Running & Setting Up Queries Forum Tools Search this Forum Feed Icon
  Thread Reverse Sort Order / Thread Starter Last Post Replies Views
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 Go to last post
2 123
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...
June 15th, 2005 04:25 AM
by Alan Ibbotson Go to last post
3 67
Date function that changes Julian to Gregorian Dates? by goose
Is there a function or expression that changes a Julian date (e.g 106094) to a Gregorian Daten (4/4/2006). I haven't had any luck locating one. Thanks.
September 21st, 2006 10:26 PM
by John Vinson Go to last post
1 62
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...
January 7th, 2009 02:39 PM
by chris23892 via AccessMonster.com Go to last post
7 69
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...
May 1st, 2007 06:31 PM
by Mitchell_Collen via AccessMonster.com Go to last post
2 75
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...
November 7th, 2005 12:52 PM
by John Spencer Go to last post
2 61
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. ...
August 24th, 2006 01:11 PM
by John Spencer Go to last post
3 52
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...
March 6th, 2006 05:36 PM
by John Spencer Go to last post
2 58
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 Go to last post
3 69
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,...
June 8th, 2005 12:47 AM
by John Vinson Go to last post
1 81
Date Grouping Query by Kenny Holden
Hi List, I have a table of tasks; tasks ==== task_number task_opened task_closed
January 25th, 2005 11:15 PM
by MGFoster Go to last post
1 58
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...
June 26th, 2008 09:40 PM
by Michel Walsh Go to last post
1 102
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 Go to last post
6 69
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...
January 14th, 2010 05:02 PM
by Clifford Bass via AccessMonster.com Go to last post
2 58
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...
April 8th, 2009 04:50 PM
by golfinray Go to last post
4 53
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...
December 1st, 2007 05:59 PM
by Ken Sheridan Go to last post
1 83
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...
February 6th, 2007 11:47 PM
by Jerry Whittle Go to last post
1 104
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 Go to last post
1 47
Date in Access field is ######## by [email protected]
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. ...
January 7th, 2010 09:41 PM
by Jerry Whittle Go to last post
1 114
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 Go to last post
3 72
Post New Thread

Display Options
Showing threads 10001 to 10020 of 43289
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

All times are GMT +1. The time now is 02:06 AM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 OfficeFrustration.
The comments are property of their posters.