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
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
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
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
Converting Text Date to Real Date to # by sross81 Hello, In the database that I use which is an out of the box system the date of birth is stored as text. I want to be able to have a field that calculates a...	August 24th, 2009 07:14 PM by John Spencer	8	144
Most recent date by David[_55_] what criteria can I use in MS Access in design view to only show the most recent date when multiple dates are resulted? for example if a query results in a...	September 15th, 2009 01:39 PM by Dale Fye	2	144
joins pls help by subs Original table ocity year price frankfort 2008 1200 frankfort 2009 500 hopkinsville2008 200 hopkinsville2009 120 indiana 2009 12 pa 2008 8	September 18th, 2009 04:20 AM by Gina Whipp	1	144
query return only one row with averages by William McNeill I have a query with multiple columns of numbers and several hundred records. I would like for the query to return one row, containing averages of each of...	September 30th, 2009 03:45 PM by William McNeill	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
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
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
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
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
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
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
MS Access Expression typed incorrectly or too complex by Ken Lewis The MS Access query below requires a date input. It runs perfectly with the dates 9/30/2009 or 12/31/2009, but fails with the subject error on dates of...	October 6th, 2009 04:15 PM by Ken Lewis	2	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