Running & Setting Up Queries - Page 1019

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
Sample database Access Solutions? by Mike Green Hi all Now that I am showing my age, there used to be a sample database available that demonstrated how to do queries and tricks with forms etc I beleive for...	February 5th, 2007 10:56 PM by Gary Walter	2	107
Using two criteria to find records that relate to a third field wi by efandango Iâ€™m not sure if I have got the title right; I wanted to say "Using two criteria to find records that relate to a third field with values in either field",... ( 1 2)	February 5th, 2007 10:33 PM by efandango	10	173
Transposing rows into columns by [email protected] I have data generated from a query in the format below: Hours \| Month_# ------------------------ 534 \| 0 723 \| 1 341 \| 2 625 \| 3 .... 876 \| 72 ( 1 2)	February 5th, 2007 10:23 PM by [email protected]	13	251
Soring in a Query by Tom I am querying a table with 380K records and 40 fields. I am wanting to use two of those fields (Example: Style and Color) for grouping, so that those like...	February 5th, 2007 09:34 PM by KARL DEWEY	1	59
Join by J I'm not sure if what I need can be done using a join, but here it goes. I have a table that has job code functions in it. Here is the basic table...	February 5th, 2007 09:31 PM by J	2	79
Do I need to export to Excel? by BruceM First, the general explanation. I have a crosstab query that counts the number of parts processed per month. Any one of several named processes may be...	February 5th, 2007 09:22 PM by BruceM	0	91
DateTime Calculation from previous record by SherriK I need a query that will filter records with more than 8 hours elapsed between entries. The DateTime field is stamped on each record using Now(). I would...	February 5th, 2007 09:04 PM by John W. Vinson	4	94
Delete query by mary Hello, My select query works fine, but when I change it to a delete query, I get "Could not delete from specified tables." I have selected records from...	February 5th, 2007 08:42 PM by Jason Lepack	2	69
Hyperlinks in a query (Access 2003) by texasradio I have a field in a table named "Data" called "Reference" that is the end of a hyperlink (so if the field value is ABC the hyperlink is...	February 5th, 2007 08:22 PM by John Nurick	1	142
Adding to Query Results by Sung I was wondering if this was possible. I have a query which pulls names from a table. However, I want "All" to be added to the result set even thought "All"...	February 5th, 2007 08:09 PM by Jerry Whittle	1	70
Access over my network by cage4000 I receive an error if I try to open an Access 2002 Database over my office network. It states: â€œMicrosoft Access cannot open this file. The file is...	February 5th, 2007 06:49 PM by cage4000	0	82
Using three text boxes by [email protected] I have created a form containing three text boxes that i want the user to enter information into. The user will then press a button and it will perform a...	February 5th, 2007 06:38 PM by Tyler	5	90
finding the max of a subquery by [email protected] Here is my dilemma, I have a table (Stockdata) with stock data in the following format. Symbol - High - Low - Close - TradeDate And have another table called...	February 5th, 2007 06:06 PM by Dale Fye	1	60
Course Q by northstar I have the following tables: student, course, registration into course. To receive a certificate the student must take three required courses (say 1, 2, and...	February 5th, 2007 06:01 PM by Marshall Barton	2	69
Hunting down duplicates by Matt Hohmeister Hello-- I have a query that creates report card records for a high school. The query creates one record per student/period combo, with these fields: SID...	February 5th, 2007 05:35 PM by Dale Fye	1	70
format currency for export by jjacob I am running a query to export data for file upload. I can't seem to get the currency in the format I want. I am using this Contribution:...	February 5th, 2007 04:25 PM by Duane Hookom	1	93
All records by Tony Carroll I am trying to produce a stock report from a 1) Product table (ProductID) 2) Inventory table (productID & Prorec) 3) Order detail table (productID &...	February 5th, 2007 04:16 PM by Iowa Joe	3	105
Unique Values v Unique Records by Mary Ann I have a table with a list of sites in it, some of which are repeated. I want to produce a list with no repeats. I have created a query and used the...	February 5th, 2007 03:51 PM by Mary Ann	4	85
Sort DatePart in crosstab query by BruceM A column heading in a crosstab query is a DatePart rendering of the month: MonthRange: DatePart("m",) This works as it should, but I wonder if instead of...	February 5th, 2007 03:17 PM by BruceM	2	67
String Extraction by Jackson Hi, I'm importing a provided file (repeatedly) and one of the fields will have Price information in the following format: or for examples....	February 5th, 2007 01:30 PM by jackwoodhead via AccessMonster.com	2	68

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