Running & Setting Up Queries - Page 213

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
Selecting the same field more than once by Brad Granath[_2_] I have a table of people, and I have a table of cases. Each person has a unique ID, first name, last name, address, etc... Each case has a unique ID, a...	June 23rd, 2009 10:33 PM by Brad Granath[_2_]	2	146
How do a create a query to find non-duplicate values? by SeekerFan I'm trying to transfer missing employee numbers from one table to another and I just want to make sure I'm grabbing the numbers that aren't already in the...	June 23rd, 2009 09:07 PM by Ken Snell [MVP]	3	131
Active Form text box as criteria by Jon M. Greetings all, I have a db with several forms that are nearly identical, I want to use the same query on each form. Part of the criteria is a tex box on the...	June 23rd, 2009 07:33 PM by Jon M.	2	112
using a calculation in a query by Shel I am writing a query from a table. This table pulls from a form that has an age calculation in one field. This result does not store in the table, and I have...	June 23rd, 2009 07:01 PM by KARL DEWEY	9	168
Update Query and Format issues by Simone I have two tables made from queries of summarized data. I am trying to update one table with information from the other using the following sql: UPDATE , ...	June 23rd, 2009 06:18 PM by John W. Vinson	2	111
Consolidating Records by Zee[_3_] I have a query as noted below Job# CustomerID First Name Last Name Address 1234 7 ...	June 23rd, 2009 05:37 PM by Duane Hookom	3	112
Every record is coming out twice on the query by KevinS Below is the code for a query I am running. For some reason every records is coming out twice. I have even gone so far as to eliminate one field at a time...	June 23rd, 2009 03:07 PM by John Spencer MVP	1	81
Query that make table in another database by Boon Hi, I have two databases in directory C:\Projects\ In my make table query, I put the destination as C:\Projects\Database2.mdb How can I make it independent...	June 23rd, 2009 02:19 PM by John Spencer MVP	1	96
iif statement and defining calculated expression once only by Ruth iif (complicated expression0,0,original complicated expression) - when writing iif statements of this format as a field in an access query, can I avoid...	June 23rd, 2009 01:45 PM by vanderghast	2	119
Missing data in report by SwEdIsH_OfFiCe_UsEr I have selected a query for my report, and the query asks for the parameters before presenting data. The query itself works fine and returns all values I...	June 23rd, 2009 12:24 PM by Duane Hookom	5	102
Count in totals query by Tim Iâ€™m having trouble with â€˜countâ€™ in a Totals Query to be used as a basis for a summary report for mountain goat surveys. Three tables are involved with...	June 22nd, 2009 10:31 PM by Tim	2	64
Distinct Issue by Rpettis31 I am trying to query an item and would like to see all the notes associate with an item, but I do not want to list the item on every row. Item A - Note 1 ...	June 22nd, 2009 10:15 PM by John W. Vinson	2	84
SQL Statement to Combine Like Items and Sum Quantities by Brian Imagine I have a table that has records that look like: Part, Job, Quantity ------------------------ 100005, B09016, 25 100005, B09016, 25 100006, B09016,...	June 22nd, 2009 09:42 PM by vanderghast	3	114
Multiple conditions for selecting an entire row by DanL I have a table like...	June 22nd, 2009 09:37 PM by DanL	2	78
Crosstab Query Header Fields (?) by croy Two similar, crosstab queries that act a little differently: The first one, hand-built, repeats "Pcent" for all column header fields, whether or not I enter...	June 22nd, 2009 08:21 PM by croy	3	103
Crosstable filtering by Kim Is there anyway to filter column heading in a crosstable so that they are not added to the total column? my column heading are dates, and I want to filter...	June 22nd, 2009 08:17 PM by vanderghast	2	86
retrieving duplicate records from multiple tables by John B. Smotherman I'm writing a resource scheduler and am currently testing a duplicate finder. I have three tables, Test 1, Test 2, Test3. The fields these three tables...	June 22nd, 2009 06:46 PM by Jerry Whittle	1	122
grouping data - possible crosstab by stuart hi i have a data set where a customer can have product A, B, C, D, E or F with a specific value what i want to produce is a table showing where a customer...	June 22nd, 2009 06:29 PM by Dale_Fye via AccessMonster.com	9	115
Transpose rows to columns by Mansoor I have a table imported from excel with 10 columns and 25 rows and I would like to transform rows in columns: from A1 A2 A3 A4 A5 B1 B2 B3 B4 B5 etc...	June 22nd, 2009 06:08 PM by Mansoor	4	104
Union Queries by AGOKP4 Hi, I sit possible to make union queries from crosstab queries? I have tried a couple of times without luck. The queries I hope to combine are listed...	June 22nd, 2009 05:51 PM by Duane Hookom	1	96

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