Running & Setting Up Queries - Page 595

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
i have some trouble with queries and combo boxes. by woof i had another post, but only one answer , from John Vinson, and if he reads this post, i hope that the information that i`ll put here will be of any help to...	November 28th, 2005 02:42 PM by [MVP] S.Clark	4	128
LIST BOX HELP REQUIRED by Sureshkumar Fields in table: RatesMaster Publication Color Base_Rate Add-on Values of Publication: TOIH, TOIM, TOID, ETM Color: BW and 4C Base Rate for BW: TOIH = 140,...	November 28th, 2005 02:46 PM by [MVP] S.Clark	1	84
Crosstab Query date problem by NoviceIan Hi, We have to monitor our organisations training needs. Our staff regularly needs to take courses in order to maintain their 'compliance'. I'm trying to...	November 28th, 2005 02:47 PM by Duane Hookom	1	81
IIF Statement by [email protected] Please help me with syntax of this nested IIf Statement. I am trying to track Internal Requisitions Status and report on it at any given time as the...	November 28th, 2005 03:33 PM by Bob Miller	1	79
Creating queries for invoices more and less than 30 days old by Siv Hei This is a bit difficult to explain in english ... In accounting I want to report to my superiors the total sum on invoices that should have been paid 30...	November 28th, 2005 04:10 PM by Michel Walsh	1	143
Sort in UNION query by Brad Thanks for taking the time to read my question. I want to sort the data returned so that "All" and "Blank" show up at the top. I can't get it to do...	November 28th, 2005 05:25 PM by Brad	2	95
Group by-function or Selection-query?? by Johanna The data set looks lite this: A B C 1 c 49 1 b 85 1 c 24 2 d ...	November 28th, 2005 05:50 PM by OfficeDev18 via AccessMonster.com	3	139
AutoIncrement field by Erik Visser Hi all, I like to create a table with SQL with a autoincrement field. But the autoinc value should not be in a range, but a random value. With the table...	November 28th, 2005 05:51 PM by Erik Visser	3	81
Several Queries, Enter date every time by Cortney I have several queries that run off the same date (mmm-yy format). How can I enter the date one time instead of several times? Also, I need to build a query...	November 28th, 2005 06:58 PM by Cortney	3	109
Contains and Like by Rob I have a table with the following values Item No 123 123-AI SFR SFR-AI I want to create a query that will pull up only records that contain AI in the item...	November 28th, 2005 07:19 PM by Michel Walsh	2	69
Changes to query aren't saved Access 2003 by PaB I have recently been upgraded to Access 2003 from 97. Now whenever I make a change to a query in design view and then close the design view of the query I am...	November 28th, 2005 08:11 PM by Ken Snell \(MVP\)	3	96
Help with calculations in a query by RWhittet I have run into a problem in my query. I am trying to run calculations on water meters. I have been able to calculate the information I need on my forms, by... ( 1 2 3)	November 28th, 2005 08:12 PM by Tom Ellison	24	580
Posible update query syntax error by [email protected] Ok this is the situation. I have these tables tblEmployee tblEmpDeductions (Employee Deductions) with field EmployeeID as primary Key, and these tables	November 28th, 2005 08:19 PM by John Vinson	1	81
Dynamic Query Question by Melinda I have 55 tables that I need to append to 1 master table. The 55 tables are created by an outside program that picks random numbers (I can't change this part...	November 28th, 2005 09:13 PM by Marshall Barton	1	83
Grouping Names and Dates based on Maximum Value by tjh Hello, I have set up a table in the format shown below. Date Name Points 11/04/05 Jim ...	November 28th, 2005 09:39 PM by Ken Snell \(MVP\)	3	209
Query Group by "SQL string" by kon Here is my sql string and the message is "No value given for one or more required parameters" "INSERT INTO masterdype ( activeyear, dypeid, hospitalid,...	November 28th, 2005 10:09 PM by Tom Ellison	1	82
Using a combo box to filter a query by Ken D. I am trying to utilize a combo box to allow the user to select an indivudual from a list which will filter the query and provide a mailing list for just that...	November 28th, 2005 11:31 PM by David Lloyd	2	62
not sure where to go ?? by Klutzz I have 2 tables linked to external 3rd party databases. StsDate and FTData. Both are performing the query and returning the records as expected. STS is...	November 28th, 2005 11:45 PM by John Vinson	2	76
Problem to create query by esoso via AccessMonster.com Hi, I've a query and I would like to select all lines if the parameters is equal to 1, over, I would like to list all lines wich the parameters equal to...	November 29th, 2005 01:21 AM by John Spencer	1	81
Select Not Equal query by Samantha I want to create a query that's NOT equal to 9 or 12, but is not working. Here is what I have so far: SELECT , , FROM WHERE (="5401") AND (9 OR...	November 29th, 2005 01:24 AM by John Spencer	2	61

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