Running & Setting Up Queries - Page 2117

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
Query too Complex by Jim On one pc I receive a message "Query Too Complex" On a 2nd with a duplicate copy of the same database, no problem. Is there a setting I need to adjust on the...	July 7th, 2004 05:11 PM by Tony	2	405
Query in datasheet view yields different results than opening it as a recordset by Jason Seaver Really peculiar problem - I've got a module that outputs a web page based upon the results of a query, but the recordset I'm using is returning some bad...	July 7th, 2004 05:00 PM by fuzzyocelot	3	719
append query by lynn. atkinson I am trying to upload data from a spreadsheet in to my database. I have imported the data in to a table which I want to append to the relevant table. When I...	July 7th, 2004 04:55 PM by lynn atkinson	1	302
check box sort by Peter Is it possible to use the check box format to sort through a query? For example can I use all records with the box checked as a criteria entry?	July 7th, 2004 04:48 PM by Rick B	1	106
Append query by p wilson hello i have a database in which i have a linked spreadsheet. the spreadsheet gets updated using excel on a regular basis (data gets added on to the end of a...	July 7th, 2004 04:12 PM by Rob	1	382
Query Data from Table and Load data in different controls by cgarcia I have a table call , with two columns one is and the other is What i want to do is in a form have this two fields on it but have be a dropdown menu of...	July 7th, 2004 03:43 PM by Newbie	1	86
SQL question: FROM and AS by Peter Jay Salzman I'm learning SQL, and have two questions. The book I'm using has the following SQL command: SELECT tblClients.Organization, Trim( & " " & ) AS Contact,...	July 7th, 2004 03:33 PM by Newbie	4	185
Mail recipient by Hi, I have Access 2002 on XP and when I try to send part of a database via Mail recipient it only attaches the first two lines of the database whether I...	July 7th, 2004 02:53 PM by Mark Hyland	1	181
Append Query Question by Chaplain Doug Is there a way to do an append query and set a particual field to a value in all records appended? I am currently using for exmaple: INSERT INTO SELECT *...	July 7th, 2004 02:30 PM by Chaplain Doug	2	487
help by Shanin I have a couple of question. 1. Does it matter if you have the same primary key in different tables, or is it better to have an autonumber as the primary key...	July 7th, 2004 02:17 PM by Shanin	4	508
Nz value by prudy On a balance due report, I get the Nz value of 0 to appear on all lines. The 0 replaces actual payments. What is the wording to show that if a payment is...	July 7th, 2004 01:13 PM by Newbie	1	117
Help with ADO Query by Newbie My understanding is if the query is grouped by EmployeeSSNumber then the number will only appear once. In order for the EmployeeSSNumber to appear more than...	July 7th, 2004 01:00 PM by Microsoft Newsgroups	1	86
ADO DBGrid Query Problem by manf442 I have a database with an employee table. There are duplicate ss#'s in this table I want to create a recorset that shows the duplicate records. In Access...	July 7th, 2004 11:44 AM by Dale Fye	2	115
In a multi-user database, how to restrict access to records by Bikerman Problem In a multi-use database, how do I restrict a user from having access to certain records and allow it for others. The scenario is as follows: The...	July 7th, 2004 07:46 AM by Allen Browne	1	459
date format by Shashi Kiran how do I ensure the date be stored in one format without any dependance of the regional settings of the client	July 7th, 2004 07:45 AM by Allen Browne	2	93
Can't figger this'un out. by Jerry Hi, I have a problem with a form I'm using for entering customer orders. The main form () contains customer info and 3 subforms; 1. subform contains a list...	July 7th, 2004 06:12 AM by Jerry	7	500
IF Staments by iyuri Hello, I have a query that is designed to pull login ids by comparing last name, first name. If the first name is a nick name the field returns blank. Can I...	July 7th, 2004 05:42 AM by John Vinson	2	115
Identifying Duplicate entries with criteria. by vw How do I write the query to identify where exact duplicate entries have been entered for two fields, but a third field differs. Example of results...	July 7th, 2004 05:41 AM by John Vinson	1	198
query based on query with user selected dates by g hoffman I have a crosstab query that is pulling from a query that uses date between and . works fine with the first query, but when I try to run the crosstab, it says...	July 7th, 2004 05:33 AM by John Vinson	2	305
Format advice does not work by Allison I have an unmatched query using two different types: Table # 1 has a text data type and the serial number appears ex. 139. Table # 2 has a text data type...	July 7th, 2004 02:30 AM by Eric Butts [MSFT]	1	191

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