Running & Setting Up Queries - Page 501

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
Result of Expression Isn't Showing Up in Query by XcentricRecluse I've entered the following expression in a query: TotalPay: (*)++ The query doesn't return the resulting calculation. What am I doing wrong? -- Chris	March 29th, 2008 05:16 PM by XcentricRecluse	7	144
Why do my queries using "date()" no longer work? by Fiona I have some queries on an Access database which use Date() as a criterion. Up until this afternoon they worked fine, but now when I try to run them I get a...	January 14th, 2009 04:51 PM by fredg	1	144
I need to display info from two different table into one query by hard2findparts I have an access database for our parts inventory. My "inv" table holds information such as part number, mfg, qty, cost, list, etc. Another table "alt"... ( 1 2)	February 13th, 2009 10:40 PM by Jeff Boyce	12	144
Availability between dates by Eddie Holder Hi Guys - I hope someone can help. I have a database that hires out products, and need help to try and find which products are available for hire between...	July 23rd, 2009 10:49 AM by Eddie Holder	4	144
Building a Reoccuring Date set of records by Kirk I'm builiding a crew scheduling database. I need to be able to build a reoccuring event like the reoccuring appointment function of Outlook. How can I do...	June 4th, 2009 05:58 AM by MGFoster	1	144
help with dates by beginner hello, ive created an access database and i want to retrieve records between a start and 90days.	June 7th, 2009 06:47 PM by beginner	4	144
Strange characters by Mary I have a table with a memo field. I have used it in queries previously and it was returned just fine. Occasionally, though, it returns characters that I...	June 10th, 2009 03:49 AM by John W. Vinson	3	144
Calculating and Updating Number of Days Between Fulltime Employmen by Jeff H I have table of client activities that contains employment data (fulltime and part-time). I need to be able to calculate the number of days between a...	June 25th, 2009 08:48 PM by Jeff H	6	144
identify missing numbers in sequence of records by Tom Whyte Please can someone tell me how to identify gaps in supposedly sequential data and calculate the value of teh difference. Thanks.	July 9th, 2009 09:18 PM by MGFoster	4	144
detecting unwanted characters by AccessMan I need a query criterion that returns records in which a text field (255 max characters) contains any character(s) other than alpha (upper and lower case),...	October 27th, 2008 09:18 PM by AccessMan	8	144
Apparent glitch with DSum in Query - begins with October, 2005 by Gene Monroe Hi all! I think I may be experiencing a glitch. I've successfully created a cumulative total function using DSum in a query, which is fed by a table from a...	September 12th, 2008 05:23 AM by david	7	144
MASTER - DETAIL {the last row entered ordered by Date then PrimaryKey} by Gary B[_2_] MASTER Table: ClaimsPrimaryKey DETAIL Table: AutoNumberPrimaryKey Date ClaimsPrimaryKey ClaimsStatus This represents, of course, a one-to-many...	April 6th, 2008 10:37 AM by Allen Browne	6	144
Word â€œDistinct â€œ using problem. by Dawn Table Account, Field customerid, AccountNo (PK), AccountType(for example: Saving account; Current account, Qdii, etc ) Rule: One customerid may open several...	June 6th, 2008 12:48 PM by Bob Barrows [MVP]	3	144
QUERY - AND/OR for search panel by BlueWolverine Hello, I am having some problems with my search panel in Access 03 on XP Pro. I have five fields to allow the user to search for any number (up to )...	June 20th, 2008 02:56 PM by BlueWolverine	2	144
UPDATE TOP value by [email protected] I am having some issues with selecting the TOP value in an UPDATE query. I am not an expert and I am looking for advice on the best way to proceed. Here is a...	June 25th, 2008 05:43 PM by [email protected]	6	144
Inner Join SQL Help by Ray Todd Jr I'm trying to join two tables via SQL and am getting errors. Any help is appreciated. The tables: taDEFENDANTS DefendantsID PK PropertyID...	July 15th, 2008 08:53 PM by Ray Todd Jr	2	144
Help with Query for new user by Meredith9053 Only been working on access for a few months. so bare with me. Basic Background: Working a Database to produce invoice for a small jewellery company. ...	July 21st, 2008 02:58 AM by Meredith9053	4	144
Index Name(s) by [email protected] I am using Access 2003 Is there a way to use SQL to get the Index Names on a table? I can get the data if I go to Tools-Analyze-Documenter, select...	July 21st, 2008 06:10 AM by Allen Browne	1	144
Check the duplicate records by Dimitris Hello. There are a lot of duplicate records in a table. I used the duplicate wizard to find them. I also have a checkbox named "dupli". What I need is to...	September 1st, 2008 01:29 AM by [email protected]	1	144
Wildcard parameter query not working by Ann Scharpf I'm running Access 2003. I've looked at the posts here and thought I had done the wildcard correctly but I am getting no results for data that I know does...	July 22nd, 2009 06:12 PM by Clifford Bass[_2_]	5	144

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