Running & Setting Up Queries - Page 516

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 ranking by Brett S. I have a table that has fields SSN, DATE1, DATE2, DATE3, DATE4. Every record has at least one of the dates populated. However, the dates are scattered...	February 8th, 2005 08:54 PM by Lynn Trapp	7	122
date recognition problem in Access 2007 by Norm Sund I have a database made in ms 2003, i installed ms2007 and now the querry does not recognize dates in the year 2010.... anyone have similar problem and find a...	November 16th, 2009 01:58 PM by John Spencer	1	116
Date record by Jeff Hi I've been reading up on creating reports in Access, and it seems that many recommend having a date record with the dates for the beginning and end of the...	November 22nd, 2006 10:29 PM by Duane Hookom	3	84
Date Records by Doug Wilson I am trying to build a query to use in creating a report. The records in my table (tblLiftStation) contain daily entries in two fields ( and ) of hour meters...	March 17th, 2005 07:40 PM by [MVP] S.Clark	1	128
Date Recurrence by Doug Assuming that I have a table with all the dates for a year how do I write a query to return every date 7 days from a specified date? Thanks in advance for...	August 23rd, 2006 05:07 PM by rpurosky	1	79
Date Recurrence 2 by Doug How do I write a query to return the 7th date, 14th date, 21st date, 28th date, 35th date, etc. or the 2nd date, 4th date, 6th date, 8th date, etc. from a...	August 24th, 2006 03:45 PM by Allen Browne	1	141
Date reference as criteria in query by Tim Brown Hi, I'm trying to restrict a query through a date range. The query, which has against a date field the criteria "Between #date# and #date#", works fine when...	June 21st, 2004 01:01 AM by Van T. Dinh	1	641
Date restricter for current quarter by Haji Hi, Can someone tell me if there is a date restrictor for the current quarter. For instance, this would be 10/1 through 12/31 but would change after the...	November 1st, 2004 08:20 PM by MGFoster	1	107
Date Restrictions - End of the Year by Leviathan I'm trying to create a report that restricts results to the current year. I'm using the following critieria: =FormatDateTime("1/1/" & Year(Date())) And...	July 23rd, 2007 10:56 AM by Jamie Collins	4	75
Date Restrictor for last business day by Chuck Hi, I want to run a query and build a report for an application that will get sales from the last business day. Our company is not open on Saturday or Sunday....	June 15th, 2004 10:07 PM by ChuckW	3	150
Date Restrictor for Last Month by ChuckW Hi, I want to create a date restrictor for last month's sales that will roll each month. So if I run it today it will give me April sales and if I run it on...	May 20th, 2005 07:29 PM by Martin J	5	125
Date Restrictor for last week's sales by ChuckW Hi, I have been using a date restrictor in Access and it has worked fine for years. It isolates transactions for last week and is done on a rolling basis. ...	September 22nd, 2007 11:12 PM by Wolfgang Kais	1	88
Date restrictor for the current year. by ChuckW Hi, I want to do a date restrictor for this year (i.e. the current year). But I dont want to do between 1/1/05 and 12/31/05. I want to have it so that...	May 11th, 2005 06:26 AM by Van T. Dinh	2	104
Date Restrictor for this month by Haji Hi, How do I do a date restrictor that gives me month to date numbers (June 1 to June 16th) . Also, How do I get a date restrictor for last june month to...	June 16th, 2004 03:54 PM by Van T. Dinh	1	328
Date restrictor for this week by ChuckW Hi, I want to write a query that will get all records for this week. I have a similar query for another company which is listed...	May 10th, 2006 03:21 PM by Michel Walsh	1	100
Date Restrictor for this week by ChuckW Hi, Can someone tell me how to do a date restrictor which will alway capture records for this week on a rolling basis? I have the following but it looks like...	May 10th, 2006 01:55 PM by Klatuu	7	94
Date restrictor for this week by ChuckW Hi, I want to create a report that will always give sales for the current week starting with monday and going to friday. We are closed on Saturday and Sunday...	September 20th, 2005 06:39 PM by John Vinson	1	85
Date Rounding by aMack I am trying to perform a simple calc on 2 dates. - The result sometimes gives me a number which is 1 more than I expect. Is this because of the time built...	January 25th, 2007 12:24 AM by Marshall Barton	2	86
Date Search by jk I have a date such as JAN 1-15 in the middle of a text field and i would lie to know how to set up the query that would bring out the results based on this...	April 28th, 2007 08:54 PM by jk	4	79
Date Search by Shawn I have a query and I would like to look up the record with the most current date. Is there a way to do this? Thanks in Advance Shawn	May 28th, 2004 04:13 PM by Brian Camire	1	407

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