Running & Setting Up Queries - Page 499

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.

Thread / Thread Starter	Last Post	Replies	Views
Date format issue by [email protected] I am under-going a college project that involves a supermarket delivery system. One of the fields in my tables looks up a date from another table. However,...	March 6th, 2007 09:45 AM by [email protected]	3	99
Date Format Issues by DB I have a query that stores dates inputted into the long date format automatically (time stamp). I have created a table with short date format matching...	December 19th, 2006 07:50 PM by DB	4	73
date format lost in UNION query by Marge I've merged the results of 2 queries into a UNION query, however I suspect that one of the fields has lost it's date format. The reason I think so is that...	December 8th, 2009 08:10 PM by Dale Fye	4	787
date format not recognised in 2003 by Kim R. Is there a reason 2003 doesn't read formats in queries the same as in 2002? Our office recently switched half of us over, and people with 2003 are unable to...	January 11th, 2008 12:11 AM by John W. Vinson	1	76
date format problem by vik I was wondering if anyone can help. I have two files with dates in them that I would like to cross match. One is an odbc link with date in the format...	August 14th, 2004 10:25 PM by John Spencer (MVP)	5	120
Date Format Problem by x-rays Hello All, I got a little problem with the data I want to fetch limited by a date range. What are my settings and what I use: 1) My regional settings are...	August 4th, 2006 02:40 PM by x-rays	4	139
Date format problem by Warren Siu I've got two tables, say table1 and table2 and they have date type fields and respectively. They are in Medium Date format. I've made a loop on all records...	November 22nd, 2004 02:33 AM by Douglas J. Steele	1	174
Date Format problem in parameter query by [email protected] i have a simple query that references a text box on a form as a parameter. the text box holds a date and uses the Short Date format for its Format...	November 18th, 2005 05:47 PM by [email protected]	2	167
Date format problem? by Jonathan I feel like the answer is staring me in the face. I have a table with a date field where some of the data is imported from an external source in general date...	August 14th, 2008 06:57 PM by Jonathan	2	84
Date Format Question by geo-wv Scenario: I have a WORD document that is merged with an ACCESS query. My date field currently is: (i.e., April 05, 2005). I would like to add the "day of...	April 5th, 2005 06:42 PM by MGFoster	1	122
Date format to display month name by reji[_2_] I am using Access 2000. In a query I have a field called docdate. I wish to display this field's month name in same query as January, February, and so on . So...	May 25th, 2008 03:52 PM by Chris O'C via AccessMonster.com	2	166
Date Format with Pass Through and form fields by David Hello All, I am using a bit of code in VBA to edit an existing Pass Through Query. I am using the dates the user selected on a form and passing it to the...	September 5th, 2008 06:15 AM by David	2	86
date format/sort problem by JohnLute I have a formatted field: ProdDate1: (Format(,"mmm"" '""yy")) This works fine and the query sorts in chronological order however when I use this same field...	September 14th, 2007 04:44 PM by JohnLute	5	74
Date Format: Year + 1 by RichNida Date Format not accurate Format(,"yy")+1 The date format does not work correctly on all dates, 04-May-94 returns 95 (correct) 04-May-99 returns 100 (should be...	May 2nd, 2009 03:57 PM by raskew via AccessMonster.com	3	106
date formats by Tim Peterson I am using Access 2003 to gather accounting data and create a table that is exported to a text file for transmission via the internet. The web application...	August 29th, 2005 10:58 PM by Douglas J. Steele	1	139
Date formats by nick Hi I am trying to design a query in design view and need to insert the dates under the criteria. when i give the dates for example as 01/01/2007, it changes...	June 22nd, 2007 12:50 AM by Dale Fye	5	79
date formats by CathyZ Hi, I am using the function Format(,"ww") to get the week number from certain dates. I can get a number from 1 to 53, but it there any way to make numbers...	August 22nd, 2005 08:46 PM by CathyZ	3	82
date formats in queries by Alexey[_2_] Hi Using MonthID: Month() in a query would give me the month of the field in numeric format -e.g. 9 for Septmeber. Is it possible to adjust the query...	September 19th, 2008 06:08 AM by fredg	3	71
Date Formats-Weeks in Date No by [email protected] Good morning, I have a graph that runs from a query. Recipients of a group wanted data shown in weeks so I entered: Week No: (Format(,"ww"" '""yy")) Results...	June 7th, 2007 04:05 PM by [email protected]	2	158
Date Formatting by Dan Wells I have a query that sums daily oil production and groups it by month. This is a make table query. I use DateValue(Format(,"mm/yyyy")) to group the date by...	September 29th, 2006 03:34 PM by Dan Wells	5	75

Forum Tools	Search this Forum
Mark This Forum Read View Parent Forum	Search this Forum : Advanced Search

	New posts		Hot thread with new posts
	No new posts		Hot thread with no new posts
	Thread is closed