Running & Setting Up Queries - Page 2095

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
Adding a new record to a query in access project by Chris I have a query that has a local table and a linked SQL server table that is of course read only. I can update fields in the query but I cannot add a new record...	July 31st, 2004 02:21 AM by Van T. Dinh	3	113
If for rounding numbers by Mike Does anyone know a IIf statement which tells a decimal number to round up to the nearest whole number? For example if a number is 87.54 to simple round to 88... ( 1 2)	July 31st, 2004 02:14 AM by Van T. Dinh	15	225
Repost: Query to records that occured within "X" number of minutes of each other by Dale Access 2000 I am working with a service call database and would like to create a query that looks for repeat trips within a user defined time period in...	July 31st, 2004 01:53 AM by Ken Snell	3	544
Rank by Craig I was wondering if there is a function in Access that will perform the same function as the 'Rank' function in MS Excel. In other words, I am looking to take...	July 31st, 2004 01:40 AM by M.L. Sco Scofield	3	98
Truncating Text Fileds by M B Hi all! I'm trying to find duplicates by matching the address fields in 2 different tables: SELECT .Address, .City, .State, .ZIP FROM INNER JOIN Table...	July 30th, 2004 11:04 PM by John Spencer (MVP)	3	76
Comparison of Signs by Diane In a query, I need to compare to fields (numbers) and compare if the signs are the same (ie, positive or negative) Example: Field1 Field2 Result 100 ...	July 30th, 2004 10:48 PM by John Spencer (MVP)	7	231
Question on Dates by Shanin Quick question. How would you get a query to return an evaluation date when the evaluation date is always their hire date but in that current year? Say they...	July 30th, 2004 10:47 PM by John Spencer (MVP)	4	125
Your advice for Many to many relain.. by Tom I have a database that keeps track for all properties I'm doing a title search with the folowing tables. I have a database that keeps track for all properties...	July 30th, 2004 09:56 PM by Tom	0	120
"UNION" Query with different fields in the two tables by Dkline I have two tables. The tables have different fields and number of fields. They each have one field in common "PolicyNumber". What we want to do is to have a...	July 30th, 2004 09:05 PM by Dkline	5	1,248
DLookup by Shanin I was trying to make a query that used a form and the Dlookup to sort the data but am only getting blank results. I had a form made with a dropdown box where...	July 30th, 2004 08:09 PM by Pat hartman	3	162
Update a field with data from another field by kboy I am trying to update a field with data from another field in the same table. I have a "phone number" field with data like 123-1234 and another field "Area...	July 30th, 2004 07:51 PM by Pat hartman	3	688
Why has Access altered the code by george Hi Very new at this so here goes. Read posting from Tom Ellison to Heather need to query missing numbers in list, Just what i needed at the time so used...	July 30th, 2004 06:15 PM by MGFoster	1	89
Max? DMax? Just give me the higher value by Colby I have two score fields and I am wanting to create a new score field that only shows the greater of the two. I tried to use the Max function but it keeps...	July 30th, 2004 05:56 PM by Allen Browne	2	76
Converting Crosstab Query to a Pass-Through Query by Demian Valle I have created a crosstab query in Access that looks like the following in SQL view: TRANSFORM Count(table1.seqno) AS CountOfseqno SELECT table1.event_hour,...	July 30th, 2004 04:37 PM by G.C.Mandrake	2	261
Repost by kasey I am not sure if I should be doing this in a query or in properties of a form--DUH. -----Original Message----- It is a form. One field is unbound, that is my...	July 30th, 2004 04:15 PM by kasey	0	100
Access Query to request record with date closest to todays date by Pete Sperling I'm using Access 97. What entry do I make in the Criteria section of a query, for a control which only contains dates, so that I only get the record that...	July 30th, 2004 03:51 PM by Pete Sperling	4	585
inventory by Kasey I am working on a DB that has Inventory of spare parts. one field is "Qty on Hand" and one is "Qty Used". How do I get "Qty on Hand" to change when I enter a...	July 30th, 2004 01:05 PM by Kasey	3	93
Multiple Option Group Synchronize issue by bdehning Tryng to place 4 Option Groups in Form_Current so that I can see text vales in bith table and on form. I was able to get one to work but if I try 2 or more I...	July 30th, 2004 10:03 AM by bdehning	1	64
UPDATE query won't update by Richard Hollenbeck I have a temporary table for recording grades for college classes. Once the grades are correct, I want to update any existing grades in the permanent scores...	July 30th, 2004 06:21 AM by Richard Hollenbeck	2	100
Bring together 2 queries by bdehning I have a query 'Combo' with fields ,,,,, and This query is based on table called 'Remarks' I would like to bring above query together with another query...	July 30th, 2004 05:45 AM by bdehning	9	127

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