Running & Setting Up Queries - Page 410

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
Calculating hell!! by david orm via AccessMonster.com Hope someone can help with this I have a table that contains various information: Name School Job Hours smith	June 15th, 2005 12:42 AM by John Vinson	2	108
Running Query classes inside transactions by Jonathan Scott via AccessMonster.com Is it not possible in Access97? I've tried the following ways to execute queries: docmd.openquery thisquery dbengine(0)(0).execute...	June 15th, 2005 01:27 AM by Jonathan Scott via AccessMonster.com	2	74
Sort query results by closest number? by Alan Ibbotson 5 records have a number field: recordA = 10000 recordB = 500 recordC = 25000 recordD = 16757.8 recordE = 20000 My sort critera will be different everytime...	June 15th, 2005 01:54 AM by Marshall Barton	2	77
How do i set a value based on a data range by matth I want to perform a query on a database table with a 1:1 relationship. Given the returned value of the query I want to create a new calculated field...	June 15th, 2005 02:33 AM by Dale Fye	1	67
Date function problem by Alan Ibbotson I am trying to return the current date. Using VBA, in an event procedure I have: MsgBox (Date), I have tried entering Date() but it reverts back to...	June 15th, 2005 04:25 AM by Alan Ibbotson	3	117
Combo box as a parameter by Doug I have a table with a numeric ID and a text field. I want to write a query where I can select a range of numeric ID's, but I'd like the user to see just the...	June 15th, 2005 06:16 AM by Doug	0	76
Help with Average by Benton I got a very funny situation here.I've calculated SUM for the following fields: (++++) each of these date fields have got numeric values.I then summed each...	June 15th, 2005 07:23 AM by benton msimango via AccessMonster.com	8	126
Updating Excel link table - Allow Unique Records didnot work by Yudy Yunardy via AccessMonster.com I have linked the Excel file into MS Access and build an append query with Allow Unique records property set to Yes but everytime I ran the query even though...	June 15th, 2005 07:27 AM by Yudy Yunardy via AccessMonster.com	0	270
equivalent of a countif function (from excel) on access? by Chris If I have a table with some "yes" "no" data and I want a query to count the number of yesses and noes, can you please tell me step by step how i could create...	June 15th, 2005 08:18 AM by Duane Hookom	1	84
Multiple IIF in a query by Bmistry Hi, I'm looking for the text for inserting multiple IIF statements into a query I have. I currently have: IIf(="4",(0.08),IIf(="7",0.08,"0")) I don't get...	June 15th, 2005 08:21 AM by Duane Hookom	3	125
differentiating the date/time by shifts? by Mark Hello all, Background: I have a table that has a date and time stamp (one field) along with other fields; each record is considered a task. It holds 10 days...	June 15th, 2005 09:16 AM by Mark	0	87
Pop up window for users by mvaldes Hi, I have a query where i'm asking the users to enter dates (BETWEEN ##/##/### AND ##/##/####) and they get associated/related records to appear. I'm...	June 15th, 2005 09:47 AM by Mark	2	78
How do I insert a character in between a string in Access? by Pawan I have Access databse with 250 records. In one of the columns I want to insert a single character in between a string in all 250 records. e.g. I have "A1400"...	June 15th, 2005 12:41 PM by Rick Brandt	1	159
Another database field by Tom What do I have to enter in the "Another Database" field, besides the actual db name, to get Access to accept it? It keeps telling me that "C:\Documents And...	June 15th, 2005 01:12 PM by Tom	4	143
Criteria does not return expected results by Scott B Greetings, I put this critereia - Between And - in a calculated query field. Here is the ield - DepartDate: (+). StayStart is a date field and...	June 15th, 2005 02:06 PM by Scott B	2	138
Skipping lines in multiple line address query by Rhysickle I'm currently using the following expression: Address: & (Chr(13)+Chr(10)) & & (Chr(13)+Chr(10)) & & etc... to combine various address fields into the...	June 15th, 2005 02:15 PM by Van T. Dinh	3	97
query is duplicating information by Nydia I created a database that keeps track of clients that come to our substance abuse program. some client come for a month then leave and come back. So i have a...	June 15th, 2005 03:41 PM by Nydia	6	255
access.query.overflow by clara39 I am trying to run a select query that sums a formula like a/b*c. i get an overflow message. How do i avoid this message. "rounding" did not help.	June 15th, 2005 04:16 PM by clara39	2	76
compare fields by alavaz17 I need help!! I have a query to create lawsuits and need to choose between two dates for my claim date. Either or . I need the later of the two dates to put...	June 15th, 2005 05:21 PM by Ofer	4	131
Multiple join query with several calculations by J I need help with a complicated (for me) query. My setup is as...	June 15th, 2005 05:51 PM by J	0	65

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