Running & Setting Up Queries - Page 505

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 parameter query on timestamp field by Adam Molinaro I'm not sure if this is correct newsgroup or not; please let me know if I should try another... I have a timestamp field in a table, and I would like place a...	May 27th, 2005 01:52 PM by Adam Molinaro	2	119
Date parameter question by pat67 I have a query that pulls data. What I am trying to get it to do is pull the data greater than a specific date. Is there a way to do it other than just...	November 10th, 2009 09:50 PM by pat67	2	111
Date Parameter SQL by Scott M. If anyone who knows SQL would be so kind as to write a statement for me, this is what I need: I have two date boxes on a form, one to specify the lower of the...	August 10th, 2004 05:39 PM by	3	285
date parameter trouble by ferde My data entry table has a field called seizure with another field listing the dates . I am trying to enter a parameter query which will give me the number of...	August 2nd, 2006 05:04 PM by fredg	4	68
Date Parameter Values by BrianP I have several queries that ask for Between and via a parameter value dialog box and I have other queries that contain hard coded date values. But, what I...	June 13th, 2007 11:14 AM by TC	6	88
Date Parameters and Querys by Kath via AccessMonster.com Hello all, I need some help in having a query automatically pull a date apart and select quarters based on the dates I specifiy. IE: Qtr 1 = between 02 month,...	June 15th, 2006 06:23 PM by KARL DEWEY	2	61
Date Parameters Irritation by knowshowrosegrows I have a query with the below SQL. Can someone explain why I get two sets of "Choose Beginning Census Date" and Choose Ending Census Date" message boxes...	December 22nd, 2008 07:39 PM by Dale Fye	5	103
Date Parameters not working consistently by Frustrated in AL I have a query based on a table that will continue to have data added to it. The query in question is based on date parameters. The actual "Count" is...	March 14th, 2007 05:21 PM by Frustrated in AL	4	98
Date parsing by Minnow I have a table called t, it has three fields called CustomerID, DateOrdered, QuantityOrdered. Now I want to know how many items ordered totally in each...	September 18th, 2005 12:08 AM by Ofer	1	96
Date Part by sacredarms I am using "QRT: DatePart("q",,1,0)" and it works great. What I would like to know is can I have it return QRT 1, QRT 2 etc instead of 1,2,3, & 4? Thanks	March 19th, 2005 11:15 PM by Ken Snell [MVP]	2	107
Date Part Function? by NeonSky via AccessMonster.com Hello! I have a query and a table... queryONE FieldYear 2007 2008 2009	December 23rd, 2008 03:29 PM by NeonSky via AccessMonster.com	3	126
date period query by chill Hi i have a db with employees and their traveling. the traveling table has a departure and arrival date. All im trying to do is to make a query for finding ...	March 6th, 2007 12:34 PM by Jamie Collins	5	94
Date Picker Crazy! by Kerry Purdy Hi I have a Main Switchboard form with 2 unbound fields StartDateEntry = Date Picker controlled - user will always choose a Monday EndDateEntry = Date...	August 21st, 2006 05:24 PM by Kerry Purdy	0	50
Date Problem by mn I have a table with two TEXT fields : Date1, Time emample of data is :Date: 140406 , Time: 0601p I want to convert this to DATE format as follows : 060414 :...	April 18th, 2006 04:55 PM by mn	2	58
date problem by miles hi, i need help the problem is that when i put the "last" on the field like date: there is one 95 and another one is 03 it will pick the 95...	March 8th, 2006 10:58 AM by Rick Brandt	2	82
date problem by miles hi, i need help the problem is that when i put the "last" on the field like date: there is one 95 and another one is 03 it will pick the 95...	March 7th, 2006 07:04 AM by miles	0	68
Date Problem by Scott I want the field in a query to display the date: #8/1/Year(date())# obviously this does not work or I would be using it but you get the idea. Any thoughts?	February 9th, 2006 08:46 PM by John Spencer	3	70
Date Problem by Michelle I have a program that enters the date/time someone enters data into the database. I then need to be able to pull a report based on just the date section. I...	October 21st, 2005 06:48 PM by Mary	4	107
Date problem by ericB I have a query that calculates commisions paid from an install date up to 91 days after the install date. How can I calculate the commision for a particular...	June 11th, 2005 03:46 PM by Rob Schneider	1	96
Date problem by Ivan Debono Hi all, My computer date setting is dd/mm/yyyy. My Access database has SQL Server compatible syntax switched on. IN my VB app, I pass a date to a...	August 2nd, 2004 05:26 AM by Ivan Debono	4	129

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