Running & Setting Up Queries - Page 1500

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
General question Acces Database Queries by halima Goodmorning, I would like to have the most suitable solution for this particular problem I have a tabel A with the following fields Mattercode, mattername,...	January 24th, 2006 01:16 PM by Rick B	2	139
UPDATE table1 SET truefalsefield = -1 where key = 500; Never updates! by [email protected] MS Access 2003 UPDATE table1 SET truefalsefield = -1 where key = 500; The field truefalsefield is never updated. It is a true/false (boolean) field. Whatever...	January 24th, 2006 11:44 AM by [email protected]	2	144
Select the last version of a bill line by susanne in new jersey I have a table that looks like this: BILL_NUM LINE_NUM LINE_VER PAID 0001234 001 001 $100.00 0001234 001 002 ...	January 24th, 2006 07:38 AM by Tom Ellison	3	88
Selection by non-alphanumeric characters by John Hi How can I select records that have non-alphanumeric characters in a field using a select query? Thanks Regards ( 1 2)	January 24th, 2006 07:32 AM by John Nurick	12	225
Calculating Overtime Problem by `Tis Me I have run into a problem calculating overtime. My Timesheet DB has several years worth of records for all employees. However, our overtime is not based on a...	January 24th, 2006 05:43 AM by `Tis Me	2	174
Selecting soft carriage return by John Hi How can I select records which contain soft carriage return in one of the fields? Thanks Regards	January 24th, 2006 04:40 AM by Graham Mandeno	1	89
limit records by 60 days by Bill Ciaburri I wish to write a query to show me only referrals sent more than 60 days ago.I use the short date in my table.I would like to run this query once a month to...	January 24th, 2006 02:03 AM by tina	3	98
Sum in two Columns by squiddy82 Is it possible to sum a third column where the first two columns are linked but in either column eg Col1 Col2 Col3 A B 13 B C ...	January 24th, 2006 01:04 AM by squiddy82	3	94
Using the Count function in a cross-tab query by Abby HI- I have two tables 1. Donor information (with fields: ID, last name, first name) and 2. Donations (with fields: ID, gift date, gift amount). I have set up a...	January 23rd, 2006 11:07 PM by KARL DEWEY	1	87
Problem filtering Dates between Access and Excel by Lanstone I am currently having issues filtering data in a query. I have linked an Excel Spreadsheet and a data table in Access. The Excel table contains Sales Order...	January 23rd, 2006 11:06 PM by KARL DEWEY	1	285
Search in many fields at same time. by Wind54Surfer Hi all, I need to find an invoice number sometimes and decided to create this...	January 23rd, 2006 10:01 PM by Duane Hookom	3	93
First - Last by Sean My query is pulling 2 fields, Item and code. For each item I can have multiple codes, i.e. C1, C2, C3 and so on. When running a query for Item A I get back 4...	January 23rd, 2006 09:29 PM by Michel Walsh	3	149
Access: Need to separate a field. Steph Hanes to FName & LName by AccessSteph	January 23rd, 2006 07:56 PM by Tom Lake	1	124
Adding Calculated Controls in Queries by Keith I have a query that has a seperate form used for entering data. I am having problems adding calculated controls and I will try to explain what I have set up...	January 23rd, 2006 07:50 PM by Keith	1	134
Many-to-Many relationship Query by Glenn Brown I've got a database with a many-to-many relationship between two tables (Employees and Customers). By this I mean I have a table that sits in-between both...	January 23rd, 2006 07:23 PM by Vincent Johns	4	172
Problem w/ Parameter in the Query's criteria by Stu I have a query on a table with the criteria on a date field set up as: !!-7 In other words, I want the criteria to be seven days previous to whatever the...	January 23rd, 2006 06:31 PM by Stu	3	134
multiple criteria in query using three tables by trainbow2 I haven't worked with Access in a decade, so I'm rusty. I have a table of wage increases that reflect a compensation polocy of raises; table titled Raises. An...	January 23rd, 2006 05:32 PM by trainbow2	6	169
Just want the top record by Bonnie Hi there! Using A02 on XP, not a programmer but love learning in here. I need to run a query that will show me all the records from a table called tInfo where...	January 23rd, 2006 05:30 PM by Bonnie	3	122
non-equijoin using a subquery by franky I'm attempting to exclude all records that have a value in a particular field if any part of the text matches values in a query. Here is my attempt but it's...	January 23rd, 2006 05:18 PM by franky	4	125
How do I create a comparison query? by Justin I am trying to create a query that will compare data within 2 tables. The query will specifically look at 3 columns in these 2 tables. If the information in...	January 23rd, 2006 05:08 PM by OfficeDev18 via AccessMonster.com	4	147

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