Running & Setting Up Queries - Page 1207

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
Null values messing up the end result by FrankM My main query pulls some student ID fields from a table and uses a few fields from three queries. The problem is if the student does not have information in...	August 30th, 2006 05:05 PM by FrankM	2	56
Percent Utilization Based on a Date Range by J Rhymes I have tried every formula and method I can think of and decide to turn it over to the experts. Iâ€™m trying to get a percent utilization based on a date...	August 30th, 2006 04:51 PM by J Rhymes	6	68
date query by naulerich I have a table with the following data: 2/12/2006 235556 5/18/2006 I need to trend the tickets opened weekly for a...	August 30th, 2006 03:51 PM by naulerich	8	91
Convert Number to Time format by Krish In a Mutivalue database, time is stored as a number like "27108" representing the number of seconds since midnight.I would like to convert the number into...	August 30th, 2006 02:33 PM by Allen Browne	1	59
concatenate distinct data by fsuds Hello, I was wondering if there is a way to select distinct when you concatenate. Basically I have a query that pulls EVENTID from tblEvent and then...	August 30th, 2006 02:04 PM by fsuds	6	67
Help with getting newest record by jln Im trying to creat a query that has only grabs the highest trans_code and the highest Next pay date. Right now when i run the query im getting records...	August 30th, 2006 01:56 PM by Ken Snell \(MVP\)	1	47
Help with Crosstab Query to transpose data by Mark I have a huge database of stock market data. It is a list of daily prices. Hypothetical eg Code Date Price ABC 01-Jan-1980 $2.10 ABC 02-Jan-1980 $2.11 ABC...	August 30th, 2006 11:36 AM by strive4peace	8	68
Query and Pivot Table calculated items by Sandro Santos I have 2 problems in getting a pivot table from query of a table that has the following type of data: Table1 Month Category...	August 30th, 2006 10:22 AM by Sandro Santos	0	56
Formulas by Nero hi... i need help with the following. i have the below table Date AHTTarget AHT Budget ProdBudget QualityBudget 2006-06-01 140 90 90 ...	August 30th, 2006 08:56 AM by Nero	3	89
passing range values into query criteria problems... by james okay, so why won't this work? i put the message box in to tell me what the code was writing, and it is EXACTLY the same as if i hard coded it into the query...	August 30th, 2006 03:19 AM by John Vinson	1	58
Duplicate queries by FinallyInSeattle I've been tasked with converting an Access 2003 solution to .Net & SQL Server. The Access solution has an MDB file that contains the database and some query...	August 30th, 2006 03:16 AM by John Vinson	2	61
get a combo box to show specific list depending on data eneterd by Haitham Jaradat im designing a database that a user has to enter his personal information in it, including his country of birth and city of birth i want the user to select a...	August 30th, 2006 03:14 AM by Steve Schapel	1	68
Querying an unrelated table by Markpud Hi all, I am trying to build a query that must draw on a table that is separate from all the other relations in my db.. For a customer accounts database,...	August 30th, 2006 02:01 AM by Markpud	0	61
Appointment system help by mortisha_i_am Hi, i'm looking for some help with an appointment system for a local animal sanctuary and I keep thinking it can be done with a query but I can't seem...	August 29th, 2006 11:47 PM by [email protected]	2	65
Calculate between two expressions by JK I have created an expression #1 *1.03- to obtain the average on the deposits.Now i want to create expression #2 which will use the results of expression #1... ( 1 2)	August 29th, 2006 11:16 PM by Duane Hookom	13	144
Auto-populate one table from another by Don Rowley I have a database with two tables: tblBookInfo - has a unique number for each book, number of pages per book and begining and ending page numbers tblPageNum...	August 29th, 2006 11:07 PM by Jeff Boyce	3	64
Sum working hours by thomas Hi ! I need to make a chart for statistics of machines. Table: MachineID: 43 Starttime: dd.mm.yy hh:nn Endtime: dd.mm.yy hh:nn What I need is a query which...	August 29th, 2006 10:47 PM by Michel Walsh	1	72
Cut record from a table instead of appending by CAM Hello, I have two tables call "monthAudits" and another "Upload" I get select policy numbers from the monthAudits and append the policy number into the...	August 29th, 2006 09:42 PM by John Vinson	1	64
Subtracting Dates in a Query by joshroberts I have a table that has due dates in the following format, 20060829 for today. I want to subtract today's date from the due date but I'm having problems...	August 29th, 2006 09:15 PM by John Spencer	1	73
need append query SQL help by Slez via AccessMonster.com I have posted a few times regarding this topic and received terrific help! I am making progress, but am stuck on something once again. I am creating an...	August 29th, 2006 09:13 PM by Slez via AccessMonster.com	6	75

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