Running & Setting Up Queries - Page 1110

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
A select query that compares 2 tables by Craig Hi, Any insight appreciated. I have 2 tables, both containing a "task to do" field. The first table is a listing of all "tasks to do" defining what tasks...	November 18th, 2006 07:23 PM by Craig	2	66
Microsoft Access Queries to an Oracle DB run 4 times slower in XP than Win98 by Sly Created a Microsoft Access query in MA 2002 SP2 which connects to various tables in a very large Oracle database (5,000 tables). Access is used for ad hoc...	November 18th, 2006 02:35 PM by John Spencer	2	64
Multiple columns sort by muskie I have a table with 6 columns: ID, Name, Date1, Date2, Date3, Date4 Each of the date fields is a different date, and they are not in chronological order...that...	November 18th, 2006 01:58 PM by Douglas J. Steele	4	65
Create Index autonumber by AN Thanh Nguyen I have a table Name CodeQuestion Mark ..... ........... ..... I want insert 1 column index autonumber by query please help...	November 18th, 2006 10:33 AM by Allen Browne	1	64
Prompt a Date Range by Suliman I am using Access 2000. When I run a query, I would like it to prompt me for a date range and pull only those records.	November 17th, 2006 10:36 PM by KARL DEWEY	1	80
Nested IIF help by Incolor Hi All, I have the following statement in a query. 8HRTWA: CDbl(Nz(*/IIf(=15,15,IIf( In ("TLV","PEL") And 15,480,IIf(="REL" And 15,600,IIf(="CEILING"...	November 17th, 2006 10:32 PM by Duane Hookom	3	85
How to sort months in combo box? by KK I have a table which has a field called "Time Period". In these fields, there are a bunch of months ie. January, February etc. How can I sort it so that when...	November 17th, 2006 10:00 PM by KARL DEWEY	7	195
formatting text field to show numbers only by Russ via AccessMonster.com I am importing information in from another database that has a text field with the following (815)555-1212, how can I remove everything via a query but the...	November 17th, 2006 08:49 PM by Russ via AccessMonster.com	3	88
Parementer Queries by Tim I'm trying to build a search query ....lets say in my table, under Vendor Name, I have 5 records the read...ABB, ABB House, ABB Record, ABB Car, ABB Form. ... ( 1 2)	November 17th, 2006 08:32 PM by Tim	10	151
Funtion to count characters in strings by Boyd Is there a function whereby I can count how many times a character or word appears in a string or memo field? e.g. functionname("For Forfeiting Friday"),"F")...	November 17th, 2006 08:11 PM by Duane Hookom	9	127
Need help sorting months by KK I have a table which has a field called "Time Period". In these fields, there are a bunch of months ie. January, February etc. How can I sort it so that when...	November 17th, 2006 08:10 PM by Duane Hookom	1	63
Multiple date math by [email protected] Hello, I have a table that lists job numbers (JCN) and dates for when each job went into a particular status as it moved through our laboratory. AWM is the...	November 17th, 2006 07:10 PM by mukade	3	59
multiple criteria statements by accessdesigner how do i create multiple criteria statements using the same fields for different criterias and attach to a single form to produce filtered data based on... ( 1 2)	November 17th, 2006 06:59 PM by accessdesigner	11	182
update based on column name dynamic by Brian is there a way that I can update a column where the column equals a value retrived by a recordset.. for example I have a table COLUMNS DBH 1 4 7 then the...	November 17th, 2006 06:41 PM by KARL DEWEY	1	77
Conditional Sum Problem... by killjoy966 I'm a little new to Access but I'm trying to slug my way through with little in the way of guidance. I'm trying to sum a column of dollar amounts based on a...	November 17th, 2006 06:36 PM by KARL DEWEY	3	49
A select query that compares two table by Craig_B Hi, Any insight greatly appreciated. I have 2 tables, both containing a "task to do" field. The first table is a listing of all "tasks to do" defining...	November 17th, 2006 06:35 PM by kingston via AccessMonster.com	1	58
Calculation in Query by HeatherD25 I have a query where I need to bring data in from 3 different tables. EmployeeData (EmployeeID, FName, LName, Status, Rate) EmployeeProjectData (EmployeeID,...	November 17th, 2006 06:23 PM by iliace	5	100
Why is my subquery running multiple times? by Billy Smith I have two SQL queries: qryIdentifyLast: SELECT ContactID, LastPurchaseDate FROM . AS WHERE LastPurchaseDate UserInput_GivenDate; qryRealQuery:	November 17th, 2006 04:56 PM by Billy Smith	0	63
Combining 2 tables by Rod I have an equipment database and a vehicle database. I have a unique field "types" taht exists in both tables. I'm trying to sumarize "query" them into one...	November 17th, 2006 04:10 PM by kingston via AccessMonster.com	4	73
Need help sorting months by KK I searched the group and this is close to what I need help...	November 17th, 2006 03:58 PM by Duane Hookom	1	70

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