Running & Setting Up Queries - Page 106

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
use Access SQL in Excel query by Herrie	November 14th, 2007 05:24 PM by Herrie	0	74
use Access SQL in Excel query by Herrie Hello, I use an external database (access 2000) with quite a number of tables, in which the marks of my students are placed. I want to put these values in...	November 14th, 2007 06:04 PM by Dorothy[_2_]	1	82
Use a Table to drive Query field selections by Joelle921 I have 5 tables which were set up across rather than down - ie fields are Jan04,Feb04...Sept04,Oct04...Jan05,Feb05...Aug05,Sept05 I currently have a...	November 2nd, 2005 07:21 AM by Chris2	5	92
use a result of a query as input criteria for another query by Vincent I have a drug list database with fields as prodid, generic name, strength (dose), form (oral, injection...). I want to design a search screen where people...	September 27th, 2007 01:59 PM by Jamie Collins	1	80
Use a query to find incomplete fulfillment orders by chris Dear all, I would like to create a query on a table which records details on whether we have recieved goods delivered or not. I have a field called Quantity...	January 30th, 2007 05:09 PM by John Spencer	1	98
USe a Parameter query by George I have a simple query that I wish to use to search for titles of Music CD's. I wish to establish a parameter query that will allow the user to enter a word...	July 9th, 2007 11:50 AM by Naveed Pathan	1	70
Use a parameter prompt with a crosstab query by NoviceIan Hi, I have a crosstab query which displays all training dates for all our teams. I would like to copy this query and have a prompt to enter a team name so...	November 8th, 2005 06:00 PM by '69 Camaro	4	108
Use a number from last quarter by Melinda Hi, I have a query where I have to find a value from the previous quarter. I have a way to do this, but it all falls apart in the first quarter of the year... ( 1 2)	October 19th, 2004 06:27 PM by Melinda	11	282
Use a make-table query to combine two existing tables by Matt I have two tables that have some fields alike and some fields different. I would like to combine these tables based on a field called Term ID. There will be...	June 16th, 2004 01:53 AM by Bill Murphy	1	753
Use a form to pass parameters to a query by RealGomer I created a form with two bound list boxes using the method found on Woody's Access Watch by Susan Sales Harkins. I added the following criteria to the query...	January 8th, 2007 11:02 PM by Smartin	1	97
Use a Combo Box in the Criteria field of a Query. by Matt I am trying to perform a query that allows a combo box to be used. I've went to the MS Office website, and tried what they suggested. It didn't work. I have...	December 18th, 2004 01:15 AM by Rick Brandt	7	172
Use All to return all records in a query by hcampbell1966 I have a query that takes criteria from several combo boxes in a form. I used a UNION clause in the Row Source to add "All" to the combo boxes. The intent...	April 28th, 2006 12:25 AM by Tom Ellison	4	73
Usage Statistics by aescleahs Hi, i need to create a query that calculates the percentage usage of certain feilds Im creating a booking management system. i need to work out the percentage...	May 9th, 2006 01:40 AM by ChrisJ	1	102
Urgently need help with a database file!!!!!! by Shane Good day. I really need some help! Someone here at our offices deleted a Access database file. I retrieved the file, but now it doesn't want to open!!!!!! It...	May 25th, 2004 03:30 AM by Gary B	2	488
URGENT: Query field mistake by Amateur Dear Sirs, My program is ready thanks and due to all of your help. During testing now I realized that I have a field in a query which is called:openp & l but...	December 4th, 2007 02:54 AM by Dale Fye	3	108
Urgent: Please help! by AccessHelp I have an employee table and a T&E table. I use an update query to update the employee rates from the employee table to the T&E table. Rates change every...	January 4th, 2006 04:30 PM by AccessHelp	7	94
URGENT: Interview questions - MS ACCESS by [email protected] Hi all, I have a job interview very soon for an analyst job within a financial company (ENTRY LEVEL). they need strong MS access skills ("assessing the core...	January 30th, 2009 05:12 AM by Gina Whipp	3	176
URGENT.... -Finding specific records - by Carlee Hi, I am struggling. I have two tables that are related without referential integrity: tblDevices Fields: Serial Number, Device Type(network or...	October 15th, 2005 08:39 AM by Allen Browne	1	64
URGENT-delete few characters in a field by Crystal Hi Everyone, In my table I have a field named Short_Description and in this field contains various part numbers...example...6312-2RS(D),...	March 14th, 2006 06:00 AM by Vincent Johns	4	75
URGENT!~***First Match**~URGENT! by Lost* I have two tables inwhich I am grouping by the First Match, hence I need all values from #1 table matched to the corresponding #2 table if there is a match ,...	March 26th, 2009 08:19 PM by Lost	3	64

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