Running & Setting Up Queries - Page 1992

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 a monthly average by UGA Ag Dawg I have weekly data for several years and would like to calculate the average by month by year. Can this be done in Access?	November 19th, 2004 08:15 PM by Michel Walsh	1	107
Update Query to add data to new table columns by Ernie Sersen Table's A and B have the same PK. I added two new fields to table A that I want to populate with data from Table B. Is this done using an Update Query?	November 19th, 2004 08:05 PM by Ernie Sersen	1	137
How to always round up? by Darrell Childress I am doing a calcuation in a query where I need to always round up the result to the next highest whole number. In other words, if the result is 9.125, I need...	November 19th, 2004 07:47 PM by Darrell Childress	4	144
select every nth record by kimdd Is there a way to select every nth record in a query? For instance, say I am trying to pull every 5th record of a table.	November 19th, 2004 05:58 PM by Lynn Trapp	1	188
If query returns no results... by Damon Heron How do I put a zero in the textbox on the report? I have a query that gives me an on hand beginning balance for a monthly report. It works fine, except when...	November 19th, 2004 04:14 PM by Michel Walsh	3	135
Query with interpolation of dates/rates? by Red I have 2 tables: -table 1 with some client operations, with the following information: start_date; maturity_date; rate; amount;Client_number. -table 2:... ( 1 2)	November 19th, 2004 04:03 PM by Red	12	695
I have Microsoft Office 97 & Microsoft Office 98 - How do I remove by Silver Unicorn Spirit Please help. I do not have the disc for 97 and I urgently need to remove this from my system due to when I download documentation it keeps on going...	November 19th, 2004 03:45 PM by Brendan Reynolds	1	371
Select and Append Qry not working. Creating Dup records. by Turnerbk I have two tables. Table one - tblContent Table two - tblConentImport I have built a select query that will identify all records that from...	November 19th, 2004 03:41 PM by Ted Allen	2	381
How do I access files that were e-mailed to me in spread-sheet fo. by [email protected] I NEED HELP WITH THIS.	November 19th, 2004 11:14 AM by Michel Walsh	1	115
Access Query by ROXANN How do I set-up a query in Access to review two excel spreadsheets for matching information?	November 19th, 2004 10:54 AM by Jamie Collins	2	111
Working Week by burg Hello, Is there a way to make a datediff calculation that ignores the non working days when calculating a total. The non working days I want to ignore in...	November 19th, 2004 10:02 AM by Allen Browne	1	119
Could Not Delete from Specified Tables by Bertrand Hi I'm using Access 97 with visual basic SP6. I have a simple query : "DELETE FROM WCha" I got the message "Could Not Delete from Specified Tables" on 1...	November 19th, 2004 09:37 AM by Bertrand	2	167
Column prefix dbo.x does not match with a table... Error by atip We have an Access 97 mdb. It has several linked tables to real tables in a MS SQL Server 7. It worked fine up until a month ago. Now after we refresh its...	November 19th, 2004 08:57 AM by Michael Cheng [MSFT]	6	258
finding overlaps by Jeff Klein I have a query that shows all employee schedules: EmployeeID, MeetingDate, CustomerID. I need to have a query that shows if I have multiple EmployeeID's...	November 19th, 2004 06:08 AM by Allen Browne	3	109
query for items more than 90 days from current date by Guy Story I am striking out on this one. I need to be able to run a query that looks for items that exceed 90 days from the current date. I thought Day()-90 would do...	November 19th, 2004 04:15 AM by Edward G	2	151
Can an "Update" Query insert quotation marks around text? by Rodney Dangerfield Hi. My table contains a single text field. That's all! For instance, one of the records might be: california state university Another record might be:...	November 19th, 2004 01:37 AM by Rodney Dangerfield	6	166
Sort by Summed Date by neenmarie My query sums all shipments by month. So the date field is formated as: ShipDate By Month: Format$(,'mmmm yyyy') I need to sort so the dates are in order,...	November 19th, 2004 01:33 AM by neenmarie	3	101
What is wrong w/ this query? by Tom Ellison Dear R: I suggest you go over the logic in your WHERE statement. Remove all the parentheses, most of which were probably added by Access anyway. Then put in...	November 19th, 2004 12:30 AM by rgrantz	3	790
Find non-matches by jfletcher I am matching a transaction file to a master file. I have 261 records in the transaction file and I get 258 matches. I need to know which records are...	November 19th, 2004 12:18 AM by John Spencer (MVP)	1	125
Complex query - TOP 3 by Kamyk Hello all! I have the following problem. I would like to create a query, which will sum up 3 orders of highest quantity for each department. Here is the...	November 19th, 2004 12:15 AM by John Spencer (MVP)	2	103

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