Running & Setting Up Queries - Page 502

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 in parameter query by lcalaway Hello advisors. I want to create a parameter query with my start date as any date possible and my end date being today. I don't want the user to have to put...	November 10th, 2005 08:46 PM by tina	1	54
date in queries by Faisal Dears While we making a query by using query wizard' there is a option to get sum,min ,max,avg in summary option if the data is in number type. Any body can...	March 19th, 2008 02:29 PM by Klatuu	1	104
date in query by Jean-Paul In my code I have following sql: sql = "SELECT Afspraken.* FROM Afspraken WHERE Afspraken.Aankomst= 800 AND afspraken.datum_bezoek= #" &...	February 5th, 2009 08:31 PM by John Spencer	3	60
Date In Query by SeanE I have a query that shows me all my suppliers, 1 of the fields shows the due date of the item. i would like to run the query showing me all over due orders,...	March 27th, 2006 12:07 AM by Jerry Whittle	2	57
Date in SQL Query by geebee hi, I have the following in my code/VBA: Dim strSQL As String ....rowsource = "SELECT DISTINCT tbl_test.status, count(test.tester) AS countoftester FROM...	April 20th, 2006 09:34 PM by Wayne Morgan	2	50
date in SQL statement by Jean-Paul De Winter There is something wrong with following line in my SQL statement: & " AND DATA.DATUM=DateAdd('yyyy',-1,#" & !! & "#) " _ !! is a date field Can somebody...	December 24th, 2005 07:03 AM by Wayne Morgan	2	74
Date in Table Name by Todd Hi, I'm writing a query to generate a table, i was just wondering how i can put the date the table was made into the table name so it reads enrolments20050118...	January 18th, 2005 06:26 AM by John Vinson	2	93
Date in the query is always short date by Tim I want to capture the LONG date from a query, so I create a parameter for the date (mm ddd yy) . In its properties, it's format is long date, BUT it always...	January 11th, 2010 04:21 PM by Tim	5	176
date intervals by M Anyone help? I have two dates for each record, start date and end date. If the date interval contains the date of April 2005 (nb the date range can be more...	October 27th, 2005 04:53 PM by John Spencer	2	134
Date Intervals from dates by c8tz Hi, I've created a query that lists the dates between a start date and an end date. From the list of dates, i need to find the intervals between the dates...	December 11th, 2007 05:12 AM by c8tz	2	96
Date is by Nic I have a query that I would like to return all items that are overdue (ie the due date is less that today I have tried the following Date() but this does...	May 19th, 2005 03:48 AM by Mark	1	84
Date issue by John I have a sql database that access is using to do some queries on, in the queries there is a date/time field. I've used the datevalue() function to remove...	January 31st, 2008 01:26 AM by Jeff Boyce	9	124
date issue by Stephen I have a table that contains a date field, and some additional numerical value fields. The data in the date field ranges from 01jan04 to present day. I want...	June 11th, 2004 01:12 PM by Jeff Boyce	9	86
Date issue in Access 2003 query by ShadrakUK I have a very simple query looking for a date in a file, I ran it and it worked, I then cut and pasted the SQL into my VBA code (turning it into a string...	April 19th, 2008 08:19 PM by John W. Vinson	1	79
date issue zero fill dates by buckpeace I need to see in an query how to change: 2021987 (feb 21,1987) to be 02021987 (mmddyyy) I woudl appreciate anyones help - im so new at access -- Buck	January 13th, 2007 10:35 PM by John Vinson	2	184
Date Issues by Chris Hello everyone, I'm trying to grab data from the past 6 full months, meaning since we are in January I just want to see Dec 06 - Jun 06. I'm currently using...	January 18th, 2007 03:01 PM by Chris	7	109
Date Issues by jxbeeman I'm relativly new at access and ran into some issues. Question 1: I'm in a make table Query and would like to create a new column with a specific date...	February 12th, 2008 09:08 PM by Dale Fye	2	78
Date issues by mkellen494 I need to be able to query for the current quarter (2/2005) the previous quarter and the last four quarters. I have the info in the table by date...	April 28th, 2005 03:53 AM by MGFoster	1	65
Date Issues - Help! by Samantha I have used one of the methods (via a function) posted on this forum to calculate a date that is 2 days prior to the start date. I called out this function...	January 19th, 2008 04:14 PM by Marshall Barton	3	101
Date join by TFollmuth I am trying to join four queries into one totaling query. Query A lists all of the accounts - Queries B,C and D will be joined to A by the account number. B,...	March 4th, 2005 12:24 AM by Douglas J. Steele	1	80

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