Running & Setting Up Queries - Page 2150

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
Adding three tables to one by TYE! Hi, I want to add three table to one main table, BUT The problem is that each table has, got agents name with they results in. So I want the query to do is,...	June 5th, 2004 07:59 PM by Steve Schapel	1	111
Resetting Yes/No fields by John Lawrence Hello, I have a database that keeps track of attendance to 8 meetings. At the end of the year, I have to reset the entire attendance record for incoming...	June 5th, 2004 07:56 PM by Steve Schapel	1	113
Get unique addresses by Sandy Hello - I have a table with Fname, Lname, HouseNum, AddressDir, AddressStreet, AddressCity and I need to get a list of Unique Addresses (in other words, just...	June 5th, 2004 07:21 PM by Sandy	5	130
creating % query by Matthew Hello, I am very new to Access and database in general. I have a database that has 3 columns that are each peoples' names and every time someone submits a vot...	June 5th, 2004 06:26 PM by Duane Hookom	3	127
Queery speed 2003 vs XP? by Jan Thinking up upgrading from Access XP to Access 2003. Is a change for the better or worse expected when it comes to query speed? Does file format matter, I'm...	June 5th, 2004 05:02 PM by Rick Brandt	1	110
Date Query by PPerry I have a query (thanks to this group) which works like a charm. This query finds the last date for an event. I now want to produce a report which displays this...	June 5th, 2004 03:01 PM by PPerry	2	297
query works but error message in report by Tony Hi, I am building queries for duplicate payments reports. I have the query working but when I go to run it in the report I get an error message (error 3079) in...	June 5th, 2004 12:43 PM by Tony	2	484
String Expression looking for "(" by Garry Hi all I have a field that sometime has for example Ray Morris or Bill Hughes (FR) I am trying to get returned the names Ray Morris and Bill Hughes in other...	June 5th, 2004 09:42 AM by JulieD	3	127
How do I search for a comma from the right so I can separate last name first name? by Dave I want to write a query that will separate a whole name into last name first. Ex: Smith,John = Smith John How can I do this? Thanks	June 5th, 2004 03:55 AM by John Spencer (MVP)	3	420
Listbox on a form as input for a query by Malli Hello All, I have an unbound multi-select listbox on a form. I am getting values from a column into the listbox. I want the values selected to be input for a...	June 5th, 2004 03:30 AM by Van T. Dinh	1	215
Crosstab queries and Recordsets in VBA by Tony Hi all, I have an interesting issues trying to create a Recordset from a Crosstab query. I am making a report with some graphs and I want to populate the...	June 5th, 2004 03:24 AM by Van T. Dinh	1	305
Date query in Dialog box question by joe Hello, I want to have a parameter query to search by date----"from date" and "to date".Is there some default expression that i can use as a criteria instead of...	June 5th, 2004 12:52 AM by John Vinson	1	553
How extract substrings of a column ? by David I need to create a query for a report. There is a column called Keywords which contains strings of keywords separated by semicolons I need to produce a report...	June 5th, 2004 12:49 AM by John Vinson	1	137
Delete Query by Lamar Hello All, I run a query and get a set of records. Those records from query, I want to use for criteria to delete records from a particular table. Any help.	June 4th, 2004 10:47 PM by [MVP] S.Clark	1	121
Difficult SQL problem by David I am sorry to have to unleash this to you on a Friday but ....... From this table: ID SA KW Parent Where ID is autonum primary key, SA is a name existing...	June 4th, 2004 10:46 PM by [MVP] S.Clark	1	264
Query reporting problem by Andy Hi, i have a company table like : Company Product Sales Resp. category etc..... cmp1 prd1 SP1 ctg1 cmp1 prd2 SP1 ...	June 4th, 2004 10:44 PM by [MVP] S.Clark	1	166
Queries and Passwords by al I have created a few forms, and I would like to query and set a password to the forms. So that in turn, for example, when someone goes to the forms and puts...	June 4th, 2004 10:42 PM by [MVP] S.Clark	1	130
Newbie: How to use "or" on a query? by Peter Jay Salzman I'm new to Access. I have a bunch of tables: 1. Enrollments for Fall 2003 2a. Graduations for Spring 2004 2b. Graduations for Summer 2004 2c. Graduations for...	June 4th, 2004 09:54 PM by Ted Allen	4	132
Empty password causes an error by June I'm new to ACCESS 2002 and I have a question on a string. I have a password box that requests the user to enter a password. If they enter a password the...	June 4th, 2004 09:26 PM by June	2	611
How to group in a query by drowning I need to group the data within field1 and then retrieve (for each group) the record(s) where field2 is either largest and/or null. Please help!	June 4th, 2004 09:21 PM by Drowning	2	89

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