Running & Setting Up Queries - Page 508

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
SQL erases after the query is ran by WannaChevy03 Hi, I have built a form, with a "run" button that runs multiple queries... DoCmd.OpenQuery ("Get1 Spec Revs") DoCmd.OpenQuery ("Get2 Plant...	February 28th, 2006 11:45 AM by Paul B	4	155
Mail Merge query results with Office 2002 by Jerry M. Gartner Greetings: When using Office 2003, from access, after executing a query, I can got to Tools Office Links Mail Merge Word Document (SIC) and the query data...	March 3rd, 2006 06:47 AM by Jerry M. Gartner	4	93
parameter query by Mozy I'm an Access novice and need help in setting up a parameter query. I want to search across a table so that I can recover all records that have instances of a...	March 1st, 2006 03:49 PM by Mozy	4	134
HELP with sql (Access) and asp by [email protected] I am trying to compare answers from 3 different firms in a table. All the answers is collected in on table with the firmID, answer (Yes/no) and a comment to...	March 1st, 2006 10:58 PM by Bob Barrows [MVP]	4	49
Using Dates in a query by Dave Hawks I have written a query looking at data from the next month using the following expression - Between Date$() and DateAdd("d",30,Date$()) This worked fine for...	March 1st, 2006 10:14 PM by Dave Hawks	4	78
Append Query run amok - Duane by Compelling Consulting I thought I had this issue cracked from a previous post - but it's run amok on me. I have a Contact form (derived from a Contact Table) and within that I...	March 2nd, 2006 04:17 AM by Compelling Consulting	4	143
Search many fields to find at least one that meets my criteria. by toot I have a list of fields of which I need to searched for one criteria. I only need at least one fields to match the criteria, not all of them. How should i set...	March 2nd, 2006 10:05 PM by toot	4	80
Count how many times a word appears, even not at all by [email protected] Hi Everyone, I have a pretty simple access database with two tables, Agents and Sales. Agent_ID Name Phone email address Agent_ID HomeType ...	March 3rd, 2006 05:05 AM by [email protected]	4	62
How to suppress "#Error" from the query results? by MSA I have a formula that gives me a "#Error" result when the divisor is zero. I wanted to suppress this error message by building an additional query with the...	March 2nd, 2006 05:23 PM by John Spencer	4	95
How do I make a query i Access ? trying to add the title The O.C. by Jamie Trying to find all the programes named The O.C. in my database but it wond finf anything using "The O.C."	March 2nd, 2006 01:02 PM by John Spencer	4	83
Adding up the number of instances. by domdog I Need an expression that will count up the Number of times "10" appears. Right now I'm Using; =IIf( 'field a'=10,1,0)+ IFF('field b'=10,1,0+..... This is a...	March 1st, 2006 10:39 PM by domdog	4	59
unable to delete invalid SQL Server records in Access or SQL Server by Randall Arnold Thanks to a former dba who didn't set up cascading deletes between joined tables, I have inherited a master table with 395 orphaned records. The orphan state...	February 28th, 2006 02:35 PM by Randall Arnold	4	77
Find and replace by Jacques Is it possible to make a query that will remove the dashes from a SSN in a field. I have a DB that was imported from another type of system, and the import...	March 3rd, 2006 02:14 PM by Jacques	4	85
Query to select first record of changes between records by peter kappes Not sure how to explain my question, but perhaps some background on my database will help. I'm putting together a database where employees use a form to enter...	February 28th, 2006 08:11 PM by Amy Blankenship	4	72
In a query, create an average field when another field is a match by Pre_Live_Wire I have a Query that uses one field as the main catagory (Plant Variety). I would like to create a field that when the plant name matches (field 1), then the...	March 1st, 2006 01:47 PM by Pre_Live_Wire	4	90
Prompted for Values while Running a Query. by [email protected] I am writing a query to determine value of baseball players based on past and projected performance. One of the statistical categories that I wish to measure...	March 1st, 2006 03:51 PM by [email protected]	4	102
SELECT query to match on 5 out of 7 fields by Kristen I'm trying to write a query that will Select all records from a table where at least 5 out of 7 fields match certain criteria. In SQL Server I believe it can...	February 28th, 2006 08:43 PM by Kristen	4	90
expressions to omit info by jwrnana I am using Order Entry Database from Access. I want to create a query that OMITS any names that start with Sky. How do I create the expression. Thank you	March 1st, 2006 12:41 AM by jwrnana	4	93
Specific Date Criteria by kalyhan Hi Access Users. I've reviewed many of the questions previously answered here but cannot find a simple answer - some of the questions require multiple factors...	March 1st, 2006 01:36 PM by kalyhan	4	66
Parameter Query by DDrowe I have a query that is supposed to look at a table and give me the results for all the entries containing at least "name". ex. All the entries containing Bob...	March 2nd, 2006 08:07 PM by Dirtbike	4	92

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