Running & Setting Up Queries - Page 66

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.

		Home » OfficeFrustration forum » Microsoft Access
Running & Setting Up Queries

Home

Page 66 of 2165

Threads in Forum : Running & Setting Up Queries

Forum Tools

Search this Forum

Thread / Thread Starter	Last Post	Replies	Views
Finding route number by Nick I have two table, Table1 has the primary key (route) and table2 (history)is the child where a log is created on certain data entries on the route. I want to...	July 27th, 2004 05:12 AM by John Vinson	4	233
Results Based upon a Date by Teri I am constructing a database that reflects shipment dates. The manager wants to print a report showing SHIPMENTS BEFORE SHIPPING DATE Customer: -1 Day Before...	July 27th, 2004 05:38 AM by Duane Hookom	1	226
need help by ferio hi, i just started to learn access to do my project.i have few questions need to clarify: 1.do we get same return if we set parameter in criteria instead of...	July 27th, 2004 11:40 AM by Michel Walsh	1	65
Setting a Password on Delete Queries? by Steve C Is there a way to set a password on a delete query? I have an application were many users enter data via forms. I have written a couple Delete queries to clean...	July 27th, 2004 04:23 PM by sps	2	158
Query Using Multiple Categories by Craig I have a database of names that each name can belong to one or more categories. I have 3 tables - Names, Category, Type. Names - Client ID, Name,...	July 27th, 2004 05:23 PM by Craig	4	87
Compare value for each row in reference table and append in new co by AlanInBradford You will need to change the table SL_Ratings interval values as some even numbers in your Stats SL table could map to more than one SL_Rating Rating. I.E. I...	July 27th, 2004 05:24 PM by AlanInBradford	1	109
Access vs. Excel query w/blank field by dutty Here is the SQL for the two queries: Access: SELECT DISTINCTROW Delivery.Promised_Date, Customer.Name, Job.Part_Number, Delivery.Promised_Quantity,...	July 27th, 2004 05:46 PM by dutty	1	325
one table, 2 fields sort, for label list by Br. Dismas SFO I have a table of names and addresses and other info. One filed to designate how they receive the News Letter, is "Type" as in 'S' for single, 'M' for...	July 27th, 2004 06:04 PM by Ken Snell	3	170
Error 2465 Audit Tracking by Pete I currently have Office XP SP3 installed. When I run the following code to cancel a record I get the error that follows. DoCmd.Hourglass...	July 27th, 2004 06:22 PM by Pete	0	158
Write the first digit, only by an Hello! I have records with numeric IdNum and others fields. When is assumed, in query, the fix digit=1, for exemple: Like 1 & "*" very well but, in this time,...	July 27th, 2004 07:04 PM by an	2	66
Pulling result only if it doesn't exist .... by GEORGIA Hi. My table has: Serial #, Receipt Amount, and Aging Bucket (consist of "0-30", "31-60", "61-90", "91-120", "121-180" and "181 over"). I need to pull only the...	July 27th, 2004 07:25 PM by GEORGIA	2	63
Using a Query to total results by Chris M I have two fields Last Name and Amount. I want to create a query that lists all the last names and amount contributed. I also want to show the total Amount...	July 27th, 2004 07:39 PM by Kerri Orthner	2	167
Report on 2 tables with no common field by JGreco I cannot figure out how to write a report using two tables or queries that have NO FIELDS in common - every time I try it says they have to be joined by a...	July 27th, 2004 08:28 PM by JGreco	2	81
outer join help by Shanin I cannot get three tables to join and cooperate how I would like. Here is what I have Table: Fields in table Employee (Employee ID, Name, SS#, Address,...	July 27th, 2004 08:40 PM by Shanin	6	706
Complicated Update query by PS My setup: tblComposition PartName Chemical ChemAmtRatio (has a composite primary key formed by PartName, and Chemical) sample data: PKR1234 Al 40 PKR1234 Si 60	July 27th, 2004 09:43 PM by PS	0	73
Pilot Time tracking database: Picking the third-from-last date? by Richard Perry OK, this one's a little beyond me, folks. Can you help? I'm trying to create a pilot logbook application for my company (aviation, obviously.) I've got all...	July 27th, 2004 09:57 PM by Richard Perry	3	298
expression is too complex to be evaluated by Paul James I built a query that was working fine at first, but then it started giving the error message ". . . expression is too complex to be evaluated . . ....	July 27th, 2004 09:58 PM by Paul James	0	464
Data Tranformation thru Query??? by Debbie Hatten Hello all! I need some help with transforming some data and I'm thinking I will have to do it through a query. I've tried several different ways including a...	July 27th, 2004 09:58 PM by Duane Hookom	1	99
Calculating time online by James Ok, I have a access database(from ISA Server) It has a username and a time in HH:MM:SS format. It logs the time when the user goes on the internet, and when...	July 27th, 2004 10:05 PM by James	1	417
Counting records within a group of a table and updating the table by Di I want to increment a field, within a sorted table, resetting the counter to 1 when another field within the same table changes. (I do not want to know that I...	July 27th, 2004 10:08 PM by Tom Ellison	5	326

Page 66 of 2165

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

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is Off HTML code is Off

Forum Jump

All times are GMT +1. The time now is 05:33 PM.