Running & Setting Up Queries - Page 995

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
Need to pool out duplicates in a different column or sheet by [email protected] Hi, I already created a macro in excel to pool out duplicates and paste in other columns. I did a test run for 50000 and it does fine job. But the issue is i...	September 28th, 2006 10:00 PM by Phil Smith	1	91
replacing all null values by Maggie Is there a way to replace all null values to zeros? I need to make this change in all fields in several tables, the UPDATE query only allows me to do it one...	September 28th, 2006 10:47 PM by Duane Hookom	1	83
Limiting Records from Query by Ripper I have a table used to sign up students for a class. The maximum per class is 20 in each class and I use a unique class ID for each course. How do I have...	September 29th, 2006 12:07 AM by John Vinson	1	74
ACCESS QUERY: Get Values after Grouping and finding Minimum by Barnaby Burman Hi, I have a simple table in Access with four cols, as an output from my GIS: BUILDING_ID , ROAD_ID , ROUTE_ID , DISTANCE The table shows the distance of...	September 29th, 2006 01:18 AM by Neil Sunderland	3	69
Plotting price changes. by Frank Martin I have a Query which stores the prices charged by suppliers. I need to keep a record of price fluctuations, so this would mean storing any changed prices...	September 29th, 2006 01:47 AM by Frank Martin	7	141
get all the records from LastValidTech even one of the condition dont match by mustish1 via AccessMonster.com Hi: I try to print data from LastValidTech even one of the condition Join/Where dont match. But it shows empty record. SELECT LastValidTech.Account1,...	September 29th, 2006 05:37 AM by Marshall Barton	1	62
permissions problem? by Geoff Cox Hello, I recently had my PC shut down suddenly whilst Access 2003 was open and appeared to loose some queries. They reappeared when I selected "show system...	September 29th, 2006 07:41 AM by Geoff Cox	6	112
overflow error by MM I have a query that runs fine until I put 0 in the criteria. When I do that and try to run the query I get an error "OVERFLOW". The SQL for the query...	September 29th, 2006 10:45 AM by Jamie Collins	5	84
Recordset with non Latin characters? by Lang Du Hi All, I have a recordset working with a translation table, please have a look at my below code: Dim rst As Recordset Dim strSQL As String Dim DB As...	September 29th, 2006 11:34 AM by Lang Du	0	59
Moving data to tabular format from list table by Col Hi all, I'm trying to extract information in an Access table into another table which shows information in a tabular format. For example the table I...	September 29th, 2006 12:14 PM by Jamie Collins	9	120
One to many back to one string by F Jones Hello I had a quick search for this but couldnâ€™t find anything. I have a one to many relationship. Unique ID in table 1 and multiple in table 2. Table 2...	September 29th, 2006 01:08 PM by John Spencer	5	75
Table joins by Warrio Hello!! When I create a query on multiple tables, it becomes sometime impossible to edit the result of the query. I know that it has to deal with the index...	September 29th, 2006 01:49 PM by Warrio	4	110
Comparing a Month & Day Combination by Magnivy Hello Fellow Access User! In my data, I have two fields that contain dates, say Field1 and Field2. I have a query that creates another date field, say...	September 29th, 2006 02:58 PM by Magnivy	2	91
Date Formatting by Dan Wells I have a query that sums daily oil production and groups it by month. This is a make table query. I use DateValue(Format(,"mm/yyyy")) to group the date by...	September 29th, 2006 03:34 PM by Dan Wells	5	75
Date field in query by klr I need to add criteria to pull through all records where visit date is current month and next 2 months (i.e. 01.09.06 to 30.11.06). Can anyone advise what I...	September 29th, 2006 03:58 PM by Jeff Boyce	2	73
Inner Join Question by Adam I have a report that links two tables together, "Contacts" and "Calls". I have created a query (see below) that has an inner join so I can display all of...	September 29th, 2006 04:00 PM by Krutika	3	67
3 queries into one query..Please help by TKM How would I combine 3 seprate queries into one one query? All 3 queries have similar tables in each. Do I do make table, append or? What is the best way to...	September 29th, 2006 04:04 PM by TKM	0	59
Calculating "maturity" with queries by [email protected] Hi! I'm having trouble preparing a query (in order to make a report chart). Here is the situation: I have a table where I have each worker, it's admitance...	September 29th, 2006 04:24 PM by KARL DEWEY	1	73
Send Password in Remote Query by N. Cotton Is there a way to pass a password using a remote Query? If the following "c:\database.mdb" is password protected, running the following results in a "not a...	September 29th, 2006 04:54 PM by N. Cotton	1	56
How to find records that only contains digits? by Morris Hi, Im using the design view to build a query, and what I need to extract is all the fields which value is all digits. I've found the suggestion on this group...	September 29th, 2006 05:53 PM by fredg	4	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