Running & Setting Up Queries - Page 994

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
For Klatuu by Gerard You sent me this code: Public Function GetLetters(strBookCode As String) As String Dim lngCtr As Long Const conAlphabet As String =...	September 28th, 2006 03:22 PM by Neil Sunderland	9	139
Data From Multiple Records by Novice2000 Hi, We receive an excel workbook of information from an outside source. Within this table the customer may have several record lines assigned to their...	September 28th, 2006 03:33 PM by Novice2000	0	62
How to SELECT fields values from a table as cocatenated string by Shalash Kindly advise me how to SELECT fields values from a table as cocatenated string?	September 28th, 2006 04:11 PM by Warrio	1	77
Wildcards by Kerry Purdy Hi I have created a query from form, I am able to use the * wildcard if I wish so all is well so far. What I would like to do is have the * as the default...	September 28th, 2006 04:14 PM by Gary Walter	5	87
Query Criteria by Tara I'm hoping someone can help me with this. I have a table that holds basic contact information as well as what part of our organization the person is a part...	September 28th, 2006 04:31 PM by Tara	0	55
Part query, null query by Dreamstar_1961 been trying to work out how to do this I've worked out the part query, but trying to work out the null section, this query is running from a form, with a...	September 28th, 2006 05:06 PM by Dreamstar_1961	1	65
Query corrupts itself... by centre21 Perhaps someone has seen this - I have a client who uses MS Access to keep track of vendors and booths for trade shows. What happens is that the data in the...	September 28th, 2006 05:15 PM by centre21	5	82
Access 2003 Transform Queries?? by news.microsoft.com Hi all, I'm trying to create a transform query with VB6, ADO 2.8 and Access 2003. I'm basically doing the following: 'Create catalog connection Set...	September 28th, 2006 05:34 PM by Ivan Debono	9	104
Queries after migration by Krutika I'm trying to migrate the following queries to T-SQL for SQL Server 2005, but getting errors. SELECT tblCurrent.AutoNumber, tblCurrent.TaxYear,...	September 28th, 2006 05:37 PM by Krutika	0	51
Retreive Only the Y results in a query by TKM My results without the Y look like this..Notice there is no N in that column and it is either Y or nothing in the BYPASS Column it only has the Y. In the...	September 28th, 2006 05:41 PM by John Vinson	3	63
Null to Zero in Crosstab Query by Alan Can anyone explain how to convert Null values to Zero in the Value field in a Crosstab Query? I know how to use the Nz function but I don't know where to use...	September 28th, 2006 06:21 PM by John Spencer	1	74
Singular by Tracy McClarnon Hello, Is this possible in Access 97? DELETE * FROM Offers AS A WHERE Not Singular (Select 1 From As B Where ((B. = A.) AND ...	September 28th, 2006 07:12 PM by Tracy McClarnon	1	60
Using radio button option group to set criteria for query by JoeA2006 I would like to create an option group of radio buttons to allow the user to drill down to a group of records in a sub form. I have three choices and want to...	September 28th, 2006 07:35 PM by Steve Schapel	1	100
Violence due to primary key problem in Append Query by vicky I created an append query to append the data to Update table. However, in the Update table I put the primary key on purpose in order to prevent duplicated...	September 28th, 2006 07:44 PM by Steve Schapel	2	83
Relating data in 2 fields by I''ve a feeling I''m not in Unix Anymore In my query I am trying to relate a PRStaff field containing an alpha list of names and a DayNum field containing the numeric value of the days of a selected...	September 28th, 2006 07:49 PM by I''ve a feeling I''m not in Unix Anymore	4	94
Criteria in multi table update query by jenngreff via AccessMonster.com I am trying to created an update query that will update all nulls for 2 fields in 1 table when the project # in both tables is equal. So far the sql view of...	September 28th, 2006 07:55 PM by John Vinson	1	58
To find overage order amount for last year USE DATEDIFF or DATEPART or DATEADD by Ashley I need to find out the avg amount of Ordertotal for last 1 year and this year if location is USA or Canada This query gives me error for present year and...	September 28th, 2006 08:32 PM by John Spencer	1	57
Union Query WHERE clause by ALEX I'm trying to create a union query with the following SQL. I keep getting a parameter prompt for all the fields in the WHERE clause except for Model, which...	September 28th, 2006 08:50 PM by ALEX	4	62
Count Expression by Alexandra504 I have several fields in a querry. These fiels have either 'Yes' or 'No' values. I need an expression that counts all the 'yes' in the previous fields.	September 28th, 2006 09:12 PM by John Vinson	3	62
Query ability by Tami Does a query ONLY pull from tables & other querys? Is it possible for the query to request a beginning date from the user & use that information to list the...	September 28th, 2006 09:19 PM by John Vinson	2	92

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