Running & Setting Up Queries - Page 1494

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 Does not return all matching results by John I have problem with a query not returning all matching records. ** Design of Db**** I have three tables and three forms (Audits, Findings and Notes). ...	January 26th, 2006 11:31 PM by Douglas J. Steele	3	148
Creating a query from multiple identical tables by bluemoir I am trying to create a query from multiple tables with the same number of columns and same headings to pull all records from each table with a matching value...	January 26th, 2006 10:16 PM by bluemoir	3	112
Compress query display by Michel Walsh Hi, SELECT ID, year, MAX(field1), MAX(field2), MAX(field3) FROM mytable GROUP BY ID, year The MAX() aggregation exclude NULL, so, if there is a not null...	January 26th, 2006 09:51 PM by Vincdc	1	88
Problem with LIKE operator by John Nurick Hi James, There's nothing obviously wrong with the query; I've just tested the same syntax in a test database: SELECT * FROM FAQ WHERE fSubject LIKE & '*'...	January 26th, 2006 09:27 PM by John Nurick	0	73
Frustrating Error: "Data type mismatch" with Subquery by dantebus The following query returns the error "Data type mismatch in criteria expression" and I honestly have NO CLUE why this doesn't work: SELECT * FROM (SELECT *...	January 26th, 2006 09:06 PM by dantebus	3	134
Problem with LIKE operator by Michel Walsh Hi, Should work unless the parameter is really a blank space, and not null or a zero length string. Try TRIM( ) around each parameter: LIKE TRIM() & "*" &...	January 26th, 2006 08:59 PM by Michel Walsh	0	68
Query always pulls ALL fields from tables by Michel Walsh Hi, The * is added if the query's property "Output All Fields" is set to yes. Hoping it may help, Vanderghast, Access MVP	January 26th, 2006 08:55 PM by Michel Walsh	0	74
Problem with LIKE operator by John Spencer Try SELECT Trans.Number, Trans.Ticket, Trans.Date, Trans.Card FROM Trans WHERE Trim(Trans.Card) Like & "*" & I'm guessing that you have trailing spaces in...	January 26th, 2006 08:45 PM by John Spencer	0	76
Yes/No Data type by NP Perfect, it works. Thanks!! "Jerry Whittle" wrote: "Completed" does not mean -1. In a YesNo field Yes, True, or On is equal to -1. No, False, or Off is...	January 26th, 2006 08:41 PM by NP	0	75
Problem with LIKE operator by Jerry Whittle SELECT Trans.Number, Trans.Ticket, Trans.Date, Trans.Card FROM Trans WHERE Trans.Card LIKE & "" AND Trans.Card LIKE "" & ; -- Jerry Whittle Light. Strong....	January 26th, 2006 08:28 PM by Jerry Whittle	0	84
SELECT TOP N - Can N be variable? by Tim I'm trying to provide some flexibility to a SELECT TOP query. I'd like the user to be able to pull the TOP 3, TOP 5, TOP 20, or whatever. I tried...	January 26th, 2006 08:26 PM by Michel Walsh	1	126
datediff by Brent Is there a way to use the datediff function to return in results in a minute:seconds format? Example 03:30 for 3 minutes and 30 seconds. Brent	January 26th, 2006 08:22 PM by Brent	6	98
before append test for existance. by [email protected] We run Multiple series of letters in a defined timeline. We run an append query to set up the Letter tracking table on the first letter and thereafter an...	January 26th, 2006 06:23 PM by [email protected]	0	140
Consolidating field values by StevieD via AccessMonster.com Hi. Just a quick one (i hope). I have 3 column in my database. (Mach1, Mach2, and Mach3) Each column looksup values using a combo box. There is a 4 column...	January 26th, 2006 05:47 PM by John Spencer	3	82
nested If by mn My function is: Amt:=IIF(( =99999 And = -1,/1.07,)) The result I need in this function is " If contract # is 99999 and GSTYN = -1 (yes) then Amount is...	January 26th, 2006 05:39 PM by fredg	4	124
name field by jb ellis I have a name field that is text in a personal type address book database. Some relatives keep their own names when they marrry and I would like to build a...	January 26th, 2006 05:35 PM by John Spencer	5	205
Date Field problem by Lucien I have a table that I am trying to pull data from in where the table has many fields. In one field my criteria is: In... ( 1 2)	January 26th, 2006 05:33 PM by John Spencer	10	143
Multi Multi Select List boxes by Simon Glencross Help or ideas needed please.... I have a multi select listbox where the user selects different catalogue types and they click a command button which send the... ( 1 2)	January 26th, 2006 05:19 PM by Douglas J Steele	10	211
running total issue by Sam Hello there, I am using the follwing SQL code to have my running total: SELECT A.Date, A.ID, A.Amounts, A.Type, A., A.Description, A.Balance, A.Currency,...	January 26th, 2006 04:51 PM by Sam	2	86
Append query autorun problem by Jerry Whittle Try putting that particular query in its own macro and running it at a time when the other queries are already complete. -- Jerry Whittle Light. Strong. Cheap....	January 26th, 2006 04:20 PM by Jerry Whittle	0	99

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