Running & Setting Up Queries - Page 549

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
Prompting users and looking up data multiple times by Cita I took an intensive Access 2003 course and have accidentally become the expert at work. I've built several queries in which I'll have to prompt the user to...	May 15th, 2008 04:02 PM by John Spencer	3	130
Can I use drop down boxes for a prompt in a query? by Stephanie I have a query where I want people to be able to select the criteria from a list (there are some criteria that have difficult spelling and if entered wrong...	May 15th, 2008 04:00 PM by Tom	5	191
Selecting the first from multiple records combining two tables by Jelle LS, I have to tables, say A and B. For all records in A I would like to find a corresponding record in B. Unfortunately I can not do this using a unique...	May 15th, 2008 03:32 PM by Jelle	3	143
Duplicate records by manju Hi, i have gone through all the posts in this discussion group. I need help with lables, i have records in a table like below Orderno box qty 23456 5 23412...	May 15th, 2008 02:09 PM by Michel Walsh	1	100
query help urgent needed by subs ocity dcity client paiddate mode wgt cost A B gpi 1/2/08 L 10 20000 C D ppg 2/2/08 T ...	May 15th, 2008 01:53 PM by Michel Walsh	1	83
Make Table with autonumber ID field for ranking by fishy I have the following query: SELECT tbl_times., tbl_times.Date, tbl_times.Productivity INTO tbl_Leaguestage1 FROM tbl_times WHERE...	May 15th, 2008 12:45 PM by Dale Fye	1	126
Use Prompted variable more than once by CR[_2_] Hi, I have a query which prompts the user for a date. I want to then use the entered date twice without calling for the variable to be entered again. Query...	May 15th, 2008 12:17 PM by CR[_2_]	5	141
Help Please? by Lisa I am posting my sql for a query I am working on. I have changed the dates to the week number it is in the year. Now I wan to have the week numbe into the...	May 15th, 2008 09:57 AM by scubadiver	1	68
First day of week in pivot chart view by Jelle LS, is there a way to customize the first day of the week when using the pivot chart view of a query. I have series of date fields that I can easily group...	May 15th, 2008 07:51 AM by Jelle	0	120
Delete Query - could not delete from specified tables by Margaret Bartley[_3_] I'm getting the error message "Could not delete from specified tables." Here's the SQL: DELETE wkReport.* FROM wkReport INNER JOIN QryA ON wkReport.SSN =...	May 15th, 2008 03:06 AM by Margaret Bartley[_3_]	3	107
Export to Excel with newer sheet in front by Song Su[_2_] I have following procedure to export roster to Excel and open it. The first run is fine but later run, the sheet is at back. People always see the old first...	May 15th, 2008 02:02 AM by Song Su[_2_]	0	108
How would I... by Question Boy[_2_] How would I build a query that would sum up the total per itemid for 2 table and then return the substraction value. Let me explain I have table1 with 2...	May 15th, 2008 12:12 AM by KARL DEWEY	2	60
Should I Use a Union Query? by [email protected] BACKGROUND I conducted a project that awarded shipments to truckload carriers. I need to track and compare these three things (monthly): - the awarded...	May 15th, 2008 12:03 AM by Jeff Boyce	1	103
Public Function by Marcie I am trying to create a public function in a query I have a table that lists all of the city and zips within district (cityzip) EX: La Crosse 54601 In...	May 14th, 2008 09:46 PM by Dale Fye	1	102
Cross Tab Query with two values by Brennan I have a table with to key fields: Hours Worked and Revenue. I would like to build a cross tab query that uses each as that value with month as the column...	May 14th, 2008 09:06 PM by Duane Hookom	1	85
Incorrect years being returned on action query by Tim Castro Access 2000 (Yes, I know. Old.) I am designing a database to help me manage a research study. Subjects will be baselined, that date will be entered into...	May 14th, 2008 09:03 PM by Duane Hookom	3	102
Randomization Field in a Query Question by [email protected] Hi - I'm trying to create a query that generates some random fields. Such as: Select recordid, name, rnd(0) as field1, rnd(0) as field2, + as sumof; BUT...	May 14th, 2008 08:59 PM by KARL DEWEY	3	95
Returning multiply entries on Query by Nancy I have a table, a query of the table, a main purchase order form and subform with a record source of the query and a report utilizing another query as the...	May 14th, 2008 08:34 PM by Nancy	7	87
Multiple Records being returned in Query by BillA Having problems with multiple records being returned as I attempt to build this query. Here are my 3 tables with key fields: (leading underscores added for...	May 14th, 2008 08:25 PM by BillA	2	119
Corrupt mdb?? by Tyler When I try to compact a our application database I get an error message as follows: "Record(s) can't be read; no read permission...	May 14th, 2008 08:18 PM by Tony Toews [MVP]	3	77

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