Running & Setting Up Queries - Page 1007

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
Most efficient way to check date ranges? by mscertified Is it best to use: WHERE DATECOL = #01/01/05# AND DATECOL = #03/01/05# Or, WHERE DATECOL BETWEEN #01/01/05# AND #03/01/05# Or does it make no difference?	March 21st, 2005 05:56 PM by Michel Walsh	1	73
Most Current Rev Only by WannaChevy03 Hi, I need to build a query that collects information about the most current revision only. For example... Base Revision Date A A ...	January 19th, 2006 06:21 PM by Jerry Whittle	3	81
Most current JET provider string by XP I am using Office 2003 on Windows XP. I am using ADO combined with JET. Is this the most current provider to use? Microsoft.Jet.OLEDB.4.0 Could someone...	September 7th, 2005 01:31 AM by Douglas J. Steele	1	77
Most current date query by skigal I have a table with dates as the records and prices as the fields. I want to do a query where a person can input a date and will get either that date's...	March 13th, 2007 02:02 PM by Allen Browne	1	94
most current date by Josh Henry Hi, My old query that used to look for anything #12/31/03# used to be sufficient and each year i would change the year because there would be only one record...	December 29th, 2004 03:35 PM by John Spencer (MVP)	2	87
most current by MikeLostinWoods I should've been able too figure this out on my own, but I can't seem to get any of the criteria I've seen here to work right. Anyways this should be a...	November 9th, 2006 06:20 PM by MikeLostinWoods	8	88
Most Common Price based on Max Value by Bruce Hi, Can somebody help me work out the Most Common Price based on the Value at that price. Lets say I have a table called tbl_COS and it has the fields,...	June 5th, 2008 01:30 PM by John Spencer	4	106
most close return by inungh I would like have a query or method to get most close value like following: Code Value A+ 95 A 90 A- 85 ( 1 2)	July 4th, 2008 09:39 PM by [email protected]	15	463
Most 3 recent dates in separate columns by Gwen Please assist. I need a count of patient visits in the most 3 recent dates for each clinic with the dates in separate columns. I attempted to use a crosstab...	April 10th, 2007 05:34 PM by Gwen	2	140
mortgage calculation by jlambert I really need help with a formula to calculate the loan amount based on the mortgage payment, interest rate and term. How would you calculate this in Access...	September 6th, 2004 04:15 PM by Ken Snell [MVP]	1	332
More understanding on linking table and make a grid query by Frank Situmorang[_2_] Hello, I learnt from this forum that relationship of the query does not have to be the same as relation of the table. Can anyone explain to me more, whether...	January 15th, 2008 05:48 PM by John W. Vinson	1	82
More understanding of the Join type by Frank Situmorang[_2_] Hello, To my understanding the relationship type (one to many, one to one, many to many) should always be the same between the table and the query. My...	January 22nd, 2008 12:09 PM by Jamie Collins	4	123
More Time Calculations by Joe I have read the web pages that some have referred me to regarding time calculations, but I still can't get it to work. What I have is: STATUSDATE, a number...	June 13th, 2004 01:34 PM by John Spencer (MVP)	4	327
MORE THEN ONE QUERIES-- HELP-- by TYE want to group more than one campaign results together. I have 3 queries for each campaign to get the results then the 4th queries format some of the...	September 17th, 2005 02:06 PM by Duane Hookom	1	80
More then 5 result rows with SELECT TOP 5 * by Versteijn Hello all, I have the following test table in Access 2003: Id test dat 1 € 5,00 1-4-2004 2 € 0,00 1-5-2004 3 € 0,00 1-6-2004 4 € 0,00 1-7-2004 5 €...	November 23rd, 2004 05:29 PM by Versteijn	2	149
More than one value needed by Gail I need to pull more than one answer from a field in a query. I have tried: , : ; and & For an example- tax types: 1040, 1065, 1120, 1041 I want to...	September 26th, 2008 10:02 PM by fredg	5	83
More than one value for a foreign key by Dan Hi all, I have two tables which look something like this: tblProd prodID - Key prodName prodColorID - Foreign Key tblColor colorID - Key	July 8th, 2005 09:34 PM by Dan	4	89
More than one Query's by TYE I need help on the following I have 2 different campaign at the moment what I want to do is combine, For each campaign there are three different tables...	October 12th, 2005 01:37 PM by Jeff Boyce	1	74
More than one parameter by Johan S.A. I have a form with only combo boxes on it that populate from their own tables. I want to run only one query with 8 parameters to build my reports from. So, I...	January 10th, 2005 12:19 PM by Johan S.A.	3	92
More than one parameter by ampickel I set up a database to keep track of athletes enrolled in a soccer camp. The table is structured with first and last names, address, basically all...	July 12th, 2008 08:55 PM by Pete D.[_3_]	6	109

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