Running & Setting Up Queries - Page 1510

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
Append Query by Chey I have three tables Provider info Provider Monthly Info Months I need to take all 12 months and append them to every provider in provider info, but I need the...	January 17th, 2006 06:04 PM by Vincent Johns	4	101
Query trouble by StevieD via AccessMonster.com Hi, Im currently running the following query: ------------------------------------------------------------------------------ -------------- PARAMETERS ...	January 17th, 2006 05:50 PM by Jerry Whittle	2	70
eliminate recordes w/ duplicates in one column by BillyRogers I have a table of records and one column has some duplicates. The entire record is not a duplicate just some of the values in one column. how could i...	January 17th, 2006 05:42 PM by RealGomer	5	78
Error in generating DDL query by Jack Hi, I am creating a table and populating with data via two DDL queries. The first DDL query I created is as follows: CREATE TABLE TEST1 (ID COUNTER, NAME...	January 17th, 2006 05:37 PM by Jack	2	91
Sorting Problem by Jerry M. Gartner Greetings: I have a table with fields a, b, and c. If field c in record 7 = field a in record 1 or field c in record 7 is like field a in record 1, I...	January 17th, 2006 05:23 PM by Jerry M. Gartner	2	86
Union queries by [email protected] I have searched this news group but I have not found an answer to my issue so I'm hoping some can provide a solution for me. I have 3 tables that I need to...	January 17th, 2006 05:03 PM by Michel Walsh	3	132
how do I increase a query field size to more than 255 characters? by Alan Synnott I have a query based on a table. the table contains a field which holds a large amount of text data, so I have set its data type to Memo. No problem. But the...	January 17th, 2006 04:53 PM by nanne	2	95
pass Where to query from form by homer Hi, I want to find a way to pass a Where clause to an pre-built query either from form or from code module in Access 97. Because the select statement is pretty...	January 17th, 2006 04:40 PM by homer	2	82
Help Parameter Query . by HelloWorld I am trying to make a parameter query that allows a user to specify a recruitment date (mm-yyyy). I suspect that my data types are wrong in the two tables I am...	January 17th, 2006 04:36 PM by HelloWorld	5	175
sequence number by group from query by [email protected] Hi, Is it possible to generate a sequence number that resets by group from a query? Heres some data from the table: Week Date Boxes 2 ...	January 17th, 2006 04:11 PM by [email protected]	2	88
Comparing the Results from two queries by Mel Morris (Global Egg Corporation) I've not had much luck getting help with this, so am trying again. I need to compare the results from two queries, and produce a list of records from query 1... ( 1 2)	January 17th, 2006 03:51 PM by Mel Morris (Global Egg Corporation)	10	145
Need a quote in my expression by [email protected] I'm fairly new to Access but I have my results I need except for one thing. I created my Table and queries. I know when I want words in my results I put...	January 17th, 2006 03:30 PM by [email protected]	3	105
Using an IIf statement to populate a combo box by almb Here is the SQL of my query: SELECT ProjDetail., ProjDetail.NeedPartNum FROM ProjDetail WHERE (((ProjDetail.NeedPartNum) Like IIf(!!="" Or !! Is...	January 17th, 2006 03:22 PM by almb	3	140
Transferring Data by J I have a small dilemma. I have a "JOB" and "STATUS" table. There are 3 fields in the status table that I need to bring over and drop into the corresponding...	January 17th, 2006 02:54 PM by Rick B	3	104
How do I add Msysobjects table to the Access 2000 query builder? by Just Jez I used it so long ago I've forgotten how I did it and I hope someone can help. I used Msysobjects table to list the names of reprots, queries and tables in a...	January 17th, 2006 02:09 PM by [MVP] S.Clark	1	98
Append blank rows and first row to 11 by [email protected] I am using Access 2003 for this problem What I am trying to do is Create a mail merge with Access as my data source. I figured out how to include multiple...	January 17th, 2006 01:59 PM by [MVP] S.Clark	1	346
Update and Select Query results don't agree by tkosel I have an update query the SQL appears below. UPDATE Employees SET Employees.Opportunities = 9 WHERE (((Employees.Employment_Length)12) AND...	January 17th, 2006 01:55 PM by [MVP] S.Clark	6	132
List Criteria by Nick hfrupn I am trying to set up a query where the selection criterion comes from a list. The list has records that contain wild cards...	January 17th, 2006 01:45 PM by Michel Walsh	1	92
Updating Data from a 'GROUP BY' query by Santiago Hi, I need to solve this problem: I have a huge database that lists all products, by Order - Item, and has shipping information ('Vessel', 'Destination',...	January 17th, 2006 12:52 PM by Santiago	2	73
Change text that displays when running query by Chris I have a button which runs a macro when pressed. This macro in turn runs a query I have called "Query1" The query is there to move data from one table to...	January 17th, 2006 11:32 AM by Van T. Dinh	1	85

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