Running & Setting Up Queries - Page 494

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 difference using current date is no date is entered by BetsyK I need to know how to find out the elapsed days between two dates. For example: Date Ordered: Date Shipped: Days to fulfill order: If the date shipped is null...	April 7th, 2005 04:53 PM by Ken Snell [MVP]	5	343
Date differences by GiBB Hello, Im a little stuck trying to do a datediff query. i have two fields "request date" and "done date", and i need the query to show all records which...	April 11th, 2007 04:59 PM by Allen Browne	1	86
Date Differences by Mark Hi all Wondering if anyone knows how to do a date difference calc from a table that looks like the following: Date PurchaseName 28/01/2005 ...	June 12th, 2005 05:02 AM by Van T. Dinh	1	58
Date differential between a full date and a date that has a year and month. by scottypws Date Differential between full date (month, day, year) and partial date (month and day). Really need you help on this one. I am trying to write a QBE...	November 23rd, 2007 05:47 PM by Ken Snell \(MVP\)	5	181
Date Display by Dez I have a query set up to pull all employee weekly time records charged to a certain category. I want to summarize the total hours charged to that category...	August 31st, 2007 03:14 PM by Dez	2	151
Date Error in linked tables query by Keith in Australia I am using access to link to tables within the database (SQL) of our company software package, when writing a query I am unsuccessful when using a date range...	November 25th, 2005 04:58 PM by Chris2	9	88
DATE ERROR IN QUERY "DATA MISMATCH...ETC. by Silvio Hello, I am using an expression to extract the date from a field which has date and time in it . To extract only the date I am using the following...	June 14th, 2006 09:53 PM by Gary Walter	8	69
Date Evaluation by dave rivera I am trying to evaluate how long it takes to complete tasks. Results can be one of two - either the start date and end date are the same date = 0 or the end...	October 21st, 2008 11:54 AM by dave rivera	0	67
Date Evaluation by dave rivera I am attempting to evaluate the number of days it takes to complete tasks. Results can be same date for both start and end dates or end date greater than...	October 21st, 2008 12:37 PM by Dale Fye	1	73
Date Evaluation - Max days in a given month? by Tim Can someone tell me a method of returning the total # of days for a given month, when that month is not the current month necessarily. I'm trying to filter a...	July 6th, 2005 12:33 AM by Jeff Boyce	4	247
date evaluation on Day and Month Only by Walter Steadman Greetings all, Is there a way to get a query to look at Days and Months of a Date. I have a field called Birthdate and another field called startdate I am...	June 9th, 2005 08:16 PM by John Vinson	1	140
Date expression by Mark[_9_] Greetings all I need to create a query that will add 30 days to another date field every month. I need assistance with the expression. As always, thanks in...	September 29th, 2007 12:27 AM by Jeff Boyce	1	97
DATE EXPRESSION by [email protected] Can someone offer a date expression that will pull records of the current month from a query which lists the dates as follows mmddyy i tried Month=Now() but...	January 21st, 2009 12:41 AM by John W. Vinson	4	91
Date Expression by Loggical via AccessMonster.com I use this expression in the criteria in a Query. How can I modify it to obtain records for a 24 hour time period? At present it produces records for the...	November 25th, 2009 06:13 AM by Loggical via AccessMonster.com	9	312
Date Expression by Candace I need to add criteria to a query field so that the only records shown are those for which 14 days have past from a date in a specific field. The expression I...	April 3rd, 2006 07:50 PM by [MVP] S.Clark	2	74
Date Expression by Chris I have this Expression in a query which creates the following field: ECPONumber: & "/04" The 04 meant the year 2004. Now I need to have a 05 at the end of it,...	January 10th, 2005 03:17 PM by Chris	4	121
Date expression in Query by Steve Stad I am getting 'undefined function' w/this expression in my qry. Expr1: IIf(today(),"cur","exp") How do I insert or use todays date in a Query.	April 14th, 2010 06:35 PM by Steve Stad	4	195
date expression question by Slez via AccessMonster.com What kind of expression in the criteria of a date field would accomplish this? I'd like to return related records of a date field where the value is...	February 6th, 2007 01:30 PM by John Spencer	1	70
date expression to bring up a weeks worth of records by chris i have my new data base built but for the love of god can i get the expression right this. in my query i need, when prompted it asks for a date, and when i...	November 27th, 2006 07:34 PM by fredg	4	183
Date expression to show all records from 01/01/2006 and today by Sarah (OGI) I'm trying to enter a date criteria in my Access 2000 query to return all records that show a date between 01/01/2006 and today. The dates entered in the...	March 14th, 2007 10:15 AM by Sarah (OGI)	2	97

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