Running & Setting Up Queries - Page 2119

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
Left outer join weird behavior by Tarh ik Hi!!!! I have an interesting problem with a query in Access (ODBC Driver version 4.00, which I'm assuming is for Access 2000). The following is the...	July 5th, 2004 03:41 PM by Tarh ik	2	391
Data type mismatch in criteria expression (Excel table; built in f by david "Data type mismatch in criteria expression" I got this error message when using Access's "Built in Functions" to built criteria on a query which is based on an...	July 5th, 2004 03:09 PM by Jamie Collins	4	564
SELECT function in Query by alexparks I am entering this following command in a query and I am getting the following warning: "The syntax of the subquery in this expression in incorrect. Check...	July 5th, 2004 11:31 AM by alexparks	9	1,238
More than one keyword in Parameter Query by Anton Hi, Can you use more than one word when prompted by a PARAMETER query? For example, a prompt for surname comes up, can you use "Smith; Citizen". As far as I...	July 5th, 2004 09:51 AM by Steve Schapel	1	161
Seperate Notes/Memo field into seperate data fields by Joe Williams I have a notes field on our database that has information I need to extract into seperate fields. Thenotes fields are formatted very consistently, so the...	July 4th, 2004 09:55 PM by John Vinson	6	317
Crosstab query oddity by Duane Hookom I expect this is a rounding error. What happens if you try: UNION SELECT ADate, DateAdd("h",1, ), AName, ALoc Have you looked at the Week at a glance type...	July 4th, 2004 07:41 PM by Duane Hookom	2	706
CrossTab by phil I would like to add a memo field as in the area that sums the information. There is no option form this do you ahve any idea. For example I want on the right...	July 4th, 2004 07:39 PM by Duane Hookom	1	77
NPV by Mark I have a query and I want to use NPV function. The Expression Builder I use the following statement: Exp1: NPV(5,!) 5% is the discount rate The field is...	July 4th, 2004 08:22 AM by M.L. Sco Scofield	6	203
Recordset is not updatable - simple inner join query - why not? by Martin Lacoste I've scoured the help, the net, newsgroups... and still can't figure out why a simple query I've set up is not updatable. All permissions are on, locks are...	July 3rd, 2004 09:46 PM by Steve Schapel	1	243
Problems with Query in a Subform by Kris L. I have a very simple Query that displays averages for the columns of my table. The query, when pulled up independtly, works fine. However, I have the query... ( 1 2)	July 3rd, 2004 09:39 PM by Steve Schapel	12	298
Query with parameter for dates by Tina Hello, I have a query where the user is asked to enter date parameters. Is there a way I can use the value that the user entered for the beginning date and...	July 3rd, 2004 03:21 AM by Ken Snell	5	357
Date Syntax by Donna Fuga How can I use the DateAdd and DateDiff functions in MS Access to calculate business days and holidays? If I have a date, and want to determine the deadline...	July 3rd, 2004 03:14 AM by Douglas J. Steele	4	134
Query on Month by CG I want to query my database to find all employees born in a particular month, regardless of year. How do I write this? I would like to be able to type into a...	July 2nd, 2004 10:50 PM by John Spencer (MVP)	7	296
Union Query with 2 MDBs that locked with database password by Mohsen Darrehshiri Hello I Have a problem. I have 2 database that locked with "Database Password". Then I want create one Union query from these MDBs. But I give a message "Not...	July 2nd, 2004 09:37 PM by Gary Walter	1	104
Trim and Delete On Update by Kenny G Hi, In order to scrub some data (example below) I'd like to run an update query. This query would eliminate all F's in the field called Temperature and also...	July 2nd, 2004 07:48 PM by Steve Schapel	5	125
Delete Query based on result of select query by John Finch Hi there, I am going round in circles here and hope that someone can give me some help. I have a select query that finds 18 records (with a primary key made...	July 2nd, 2004 05:47 PM by Ted Allen	1	784
query display by mrs This may be a little long. I have a tbl that holds discrepancy data. The tbl's primary key is linked to another tbl description. This gives several...	July 2nd, 2004 05:21 PM by mrs	1	166
can't append records in append query by Greg Clements Help, i have 2 tables, one is an import from a check run it has a field on it for current paid deductions data for that check, the other table has a field of...	July 2nd, 2004 04:29 PM by Ted Allen	1	811
AND Operator. by Richard Horne I have a query which I want to filter out records according to two boolean values. How do make it so that it only shows the records when both fields are equal...	July 2nd, 2004 04:10 PM by Ted Allen	1	110
Counting query help by Peter Aitken I have a multiuser Access app that keeps track of student dormitory assignments. One screen displays the number of students currently assigned to each floor of...	July 2nd, 2004 04:04 PM by Michel Walsh	1	117

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