Running & Setting Up Queries - Page 511

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 query without year by Ian I have a series of dates spanning several years and I'd like my where clause to limit the dates between Nov 1 and Apr 30 regardless of year. Is there a way...	January 18th, 2010 06:33 PM by John W. Vinson	3	153
Date Query-show records 1 day old. by naiveprogrammer I have a db that needs to show all records that are over a day old. Yet my query isn't working. It shows records that are over 2 days old. Can someone tell...	October 27th, 2005 09:23 PM by Ofer	1	87
Date query...again by woods1119 SELECT tPtData.ingPtID, tPtData.strLastName, tPtData.strFirstName, tPtData.strFrstSeen, tVisit.dtmVisitDate, tVisit., tVisit., tVisit.ysnLimbLoss FROM tPtData...	December 29th, 2005 03:35 PM by KARL DEWEY	2	66
Date Query: Select all items before 5/Sep/2007 by ali[_4_] I have a table look like this: ID Name Trade_Date Settle_Date 1 AA Company 20070903 20071005 2 BB Company 20070904 ...	September 10th, 2007 02:22 PM by Duane Hookom	6	80
Date Question by scott04 Hello everyone, I have a database that has two fields that are used in order for a record to be complete. The are DateSatRsp (Date of Satisfactory Response)...	September 4th, 2008 04:28 PM by Jeff Boyce	2	90
Date question by Amin How do I query for all dates after a certain date? e.g. WHERE DateField 11/01/2008 This is data mismatch obviously. How should I be writing...	December 2nd, 2008 04:57 PM by John Spencer	2	60
Date Question by Gary F Shelton[_2_] I have pulled some fields out of our mainframe which a Century Year Month Day So in Access I first tried to perform a Cdate of Date:...	March 23rd, 2009 11:12 PM by John Spencer	4	78
Date question by [email protected] I have a date field, I want to lookback 15 days from today for all PO's, in the criteria what would I put in there? I know theres a dateadd is there a...	April 17th, 2008 10:04 PM by [email protected]	3	93
Date Question by Terry Hi, I have a file in which I have an order date column, the date is in the form of MM/DD/YYYY, what i am trying to do is to find all files More then a month...	October 11th, 2007 08:38 PM by John Spencer	2	95
Date question by Crystal McKee I am sure I am making this much worse than it should be, but what I am trying to do is this: I have a form that is a menu for selecting reports. There is an...	June 10th, 2004 04:12 PM by Crystal McKee	2	251
Date question by confusedinc I am trying to figure out how I can produce the following: I need to show accounts that have (0)zero days left before they need to be paid. I have created the...	March 20th, 2006 12:27 AM by Tom Ellison	4	67
Date question by taft71 I have 2 calculated date field which sometimes end on Saturday or Sunday. When that happens I would like them to end on the prior Friday. Any help?	March 16th, 2005 04:09 AM by Spectra	4	113
Date question by Spectra I have 2 dates, date delivered & date due. The date due is the date delivered + 3 days. If the due date ends up on a Saturday, I want to add 2 days to the date...	March 22nd, 2005 12:30 PM by Andreas	5	477
Date question formula by Fly Boy 5 I have a field for date of service and another field for invoice date. A date range is entered for date of service and I need to allow invoice dates between...	February 2nd, 2010 03:56 PM by Daryl S[_2_]	4	147
Date Question, not sure which forum by Walter Steadman Greetings all, I have built a DB that tracks pilot hours and it is working (but very clunky, and bad design). Here is where I am stuck. Pilots hours are...	June 30th, 2005 06:29 AM by Walter Steadman	2	78
Date Question... by 116 I am trying to create a query to give me the results from the first weds of each month back to the following day after weds. Having trouble formatting the...	May 18th, 2010 12:36 PM by 116	5	905
Date Questions in a Query I think by Walter Steadman Hello all, I have posted a question similar to this before, but I did not understand what the responder was conveying so going to post again. I have a...	June 4th, 2005 12:48 PM by Gary Walter	4	97
Date questions in query by Tami I know this has been asked before, but I still can not figure out how to do it. Sorry, I have three tables Job Costing, Employee & Pay History Job... ( 1 2)	September 18th, 2006 05:21 PM by KARL DEWEY	12	134
date quieries by Shirley I have a parameter querie set up to ask for dates between beginning and endding date. "7/1/2008 through 7/31/2008" and when you enter those dates, wyou get...	August 4th, 2008 04:38 PM by raskew via AccessMonster.com	2	77
Date range by AlbertaRose I am having issues with my reports pulling information between dates from my queries. It doesn't seem to be recognizing there are parameters in those fields...	September 23rd, 2008 10:09 PM by Ken Sheridan	3	93

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