Running & Setting Up Queries - Page 2004

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
Is there a way to check for duplicates between tables in a databa. by K.W. I have a large mailing database with 10 or 12 separate categories (tables). I know how to check for duplicates within a table, but is there a way to check for...	November 3rd, 2004 10:20 PM by Rick B	1	252
Hourly Data Count?? by Rog I have a table with thousands of call log records each with a date and time received. I would to calculate the number of call logs received for each hourly...	November 3rd, 2004 08:45 PM by Rog	4	157
Using Min & Max in combined SQL statements by Llyllyll Afternoon all, Please could someone help. I have two queries (as set out below) and would like to use these to create one dynamic SQL statement. I've been...	November 3rd, 2004 07:59 PM by GreySky	4	121
Merging Records from one table to another on different databases by Mike Smith Hey ppl, hope u guys can help me out in my situation. Scenario : I have 2 password protected databases (Access 2002), the situation is a local copy and a live...	November 3rd, 2004 07:02 PM by Özden Irmak	3	498
Track time by Jessie Hi, I have a field that tracks the time of call in the format HHMMSS. I also have a field that contains the length of the call in seconds . Assuming that...	November 3rd, 2004 06:59 PM by Duane Hookom	1	180
Want to update only one filed values from one table to another ta. by Bijoy George In two tables 5 fileds have same values. Want to update from one table to anotehr table. Please help.	November 3rd, 2004 06:32 PM by	1	100
update/append one field to another table by Bijoy George I have a table with following table...	November 3rd, 2004 06:31 PM by	1	127
update/append one field to another table by Bijoy George I have a table with following table...	November 3rd, 2004 06:31 PM by	1	110
Misc Time - Continued by dlemarr I have the following summary query for a production database: Date Processor Sum Of MiscTime The SQL window shows this- SELECT , Processor, Sum(MiscTime) As...	November 3rd, 2004 05:18 PM by dlemarr	3	148
Why has date() function quit working in msaccess 2000? by Gary1956 I recently updated MS Office 2000 on the Microsoft Office web site and now I cannot use the Date() function in a query. Error says "Function is not available...	November 3rd, 2004 02:52 PM by Ken Snell [MVP]	1	251
Need help speeding up 25 minute query by Afzal There are approximately 200,000 records in a line-item table of an invoice database (access 2000). My query is tring to sum up total amount for each invoice by...	November 3rd, 2004 02:48 PM by GreySky	3	139
Top x for each person/customer by Brian K. Sheperd Is it possible to show the top 5 orders per customer. If I use the "top" option, I just get the top 5 records. Say Cust#1 had 20 orders, Cust#2 had 10...	November 3rd, 2004 02:14 PM by Allen Browne	1	96
A bit more than a nice simple date query.. by Chris Mortimore I'm looking for a query that will compare a range of dates, but a little bit more than that as well... Using and in the query... if and are both given, I...	November 3rd, 2004 12:44 PM by Chris Mortimore	2	225
Query Helper Add-In? by Mark Jerde MS Access 2003 SP1. I just opened a multi-query query for the first time in a long time. As I was trying to figure out whether to modify this query or simply...	November 3rd, 2004 06:36 AM by Michael Cheng [MSFT]	1	118
Between date for a Query from two dates in a Table by KAnoe I would like the user to set the start date and End date on a form. I would put a Start Date and End Date date in the form so the user could just put...	November 3rd, 2004 02:54 AM by Allen Browne	1	129
Query between a date range by Jenn Connors I am trying to do a query between August 3 - October 31. Is there a formula that I have to put in to get the results between these date? Please help.	November 3rd, 2004 02:13 AM by Douglas J. Steele	6	126
select all records on one table but limit records from 2nd table by joan here are the table i am working with tbl_mstr: accession number (primary) name accession date tbl_journal1: record number (primary) accession number	November 3rd, 2004 01:38 AM by joan	8	202
Parameters and their dialog boxes by CCS I'm hoping someone can help me. In a query I've created, I've succeeded in prompting the user to put start and end dates, however when I run the query there...	November 3rd, 2004 12:49 AM by MGFoster	1	187
Using unbound textboxes as criteria by Marshall Barton rgrantz wrote: I have a form w/ a subform. One the form, I have several unbound controls that the user inputs data into. These serve as the criteria...	November 3rd, 2004 12:04 AM by rgrantz	4	367
How to select between a range of dates? by John Spencer (MVP) Interesting problem. Because of the year wrap, the January Reviews would be based on WHERE Format(HireDate,"mmdd") BETWEEN "1116" and "1231"...	November 2nd, 2004 11:14 PM by John Spencer (MVP)	5	197

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