Running & Setting Up Queries - Page 999

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
a business opportunity by [email protected] Are you interested to join our business? The details are available at our site www.myvideosystem.com/90547 & our blog www.mvtwealth.blogspot.com Pl. confirm as...	October 3rd, 2006 01:34 PM by [email protected]	0	54
Access 2003 Query - what does this mean? by B. Levien In a pre-existing query, under the criteria, I see "word processor" What does mean, exactly? I have looked through all the materials I have, and...	October 3rd, 2006 03:00 PM by B. Levien	4	101
I need help creating a query comparing two tables. by AG How would I compare two tables, they each have a unique field. I would like to compare the unique fields and find which records are not duplicates. And...	October 3rd, 2006 03:04 PM by TedMi	1	62
Date and Time to text by aMack I am running a query to select specific data for export to a customer. They require comma delimited format. How do I change a date to a text?...	October 3rd, 2006 04:00 PM by KARL DEWEY	2	69
Question Regarding Advanced Query Left([membershipid],InStr([membe by chas I have a database that has "membershipid" numbers like such: 0001-000 --- Would be member number 1 0002-000 --- Would be member number 2 I know that by...	October 3rd, 2006 06:17 PM by chas	2	84
Establishing a Count of Unique Records utilizing Parameters by Del I'm trying to create a table which counts off groupings of unique values. Example: Subj Course# SeqNo. MAT 101 1 MAT 101 ...	October 3rd, 2006 06:17 PM by Del	3	147
how to sort on calculated field? by Jesse I'm querying from a sql 2k database...from a single take. I'm ok selecting the data I want. I need to group the value of a calculated field....and I don't...	October 3rd, 2006 06:24 PM by Jesse	4	93
filter some records and permit all other related records by JohnLute I have a complex query that I use in relation with a form in order to filter out certain data. It works fine however it filters too well! Basically, the...	October 3rd, 2006 07:02 PM by JohnLute	0	63
DateDiff calculation with criteria returns a negative number by Windsorcat via AccessMonster.com My query calculates a date between a program completion and the date of a new offense. Since some offenders have entered the program more than once,...	October 3rd, 2006 07:17 PM by John Vinson	1	91
Does a Select query copy memo fields correctly? by p I created a select query to get different fields from different tables. Two of the fields are Memo fields. Both of the fields are truncated at 255...	October 3rd, 2006 07:18 PM by John Vinson	1	69
query on multiple fields of same type? by Jebuz Hi, I have 2 tables, "monitor_configurations" & "Sensors" Monitor_configurations has fields :VelocityA, VelocityB, VelocityC all text type storing the...	October 3rd, 2006 07:36 PM by Jebuz	4	88
get list of what info is missing in a query by [email protected] I am querying 2 tables from different sources and the link is customer account number I want to know how to query what account numbers are missing from one...	October 3rd, 2006 07:41 PM by Jeff Boyce	1	95
Field Selection Criteria by Rob Is there a way to use a combo box or some sort of coding to select specific fields from a query? I have a query that combines data from 2 tables. Each field...	October 3rd, 2006 08:00 PM by Klatuu	1	72
query save problem by Maggie I'm running an UPDATE query, however, when the filed name has a space in front of a bracket, access deletes the space when the query is saved. For example,...	October 3rd, 2006 08:05 PM by Jeff L	1	66
Editting in a single-tale query by Harry V I have set up an mdb for a user - when he uses a single-table query to locate and edit column values in a record, the edits appear to be saved, but, if he...	October 3rd, 2006 08:09 PM by Harry V	2	64
"Invisible" Columns in ACCESS table by Harry V I have a table that I've imported to Access 2002 SP3 from SQL Server 2000, and I cannot get two of the columns to display. I've looked in the design window...	October 3rd, 2006 08:11 PM by Harry V	2	98
query question by [email protected] Hi, I have a table with fields artefact (text), not_damage (text) but i need to write a query so it can shows me which artefact and also count the number of...	October 3rd, 2006 08:31 PM by John Spencer	1	75
TO FIND TOTAL ORDERS SHIPPED AND NOT SHIPPED AND TOTAL OF AMOUNT WHICH WERE SHIPPED AND WHICH WERE NOT SHIPPED by Ashley THIS IS THE SAMPLE DATE I want to see supplierID, sum of amount shipped and sum of amount not shipped, and group them by suppier, total no of orders accpted...	October 3rd, 2006 09:18 PM by Phil Smith	2	101
Subject: transferring address postcodes to another table by efandango I have two tables. The first is a masterlist of 25,000 city street names, with correct postcodes. The second table has 1,340 streetnames, but no postcodes. I...	October 3rd, 2006 09:34 PM by efandango	2	87
Selection lists in queries by Rob I am trying to setup a query or queries to pull data from a drop down list. Here is the problem: I have 2 tables that store the data. One table contains...	October 3rd, 2006 09:42 PM by John Vinson	3	83

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