Running & Setting Up Queries - Page 1021

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
Research Study Mailing/Participation Summary Table - Multiple Fields Multiple Dates by Kay I need to produce a summary report of participants in a research study. We first send out an initial/introduction letter telling the person about the study...	February 4th, 2007 07:34 AM by John Nurick	3	89
Adding/modifying records via a Query with a One to Many Relationsh by Zburnsie I have two tables set up - one is Header info and the other is detail - this is used in a form /subform relation - what I want to be able to do is if there...	February 4th, 2007 02:24 AM by Smartin	1	85
work's fine but not from the text box isn't what i was hopeing for by ShaunP work's fine but not from the text box isn't what i was hopeing for , I would like it work from the textBox "txtFind" But how ? .The Parameter box popped up,...	February 4th, 2007 02:16 AM by tina	1	109
Compare Query by Novabulldawg I have on table that I'm trying to compare two addresses. I would use the dup query. However, the addresses are set up different (i.e 220 Anywhere Road or...	February 4th, 2007 02:07 AM by Smartin	1	87
Specifying a criteria when the field can be null by John F I need to include a criterion in a query that is TRUE if a date field is between two dates. But the date field can be NULL in which case the criterion...	February 4th, 2007 12:53 AM by John F	3	90
Query builder enclosing fieldnames in quotes by CompleteNewb Hi All. I'm trying to use the Trim function in the Query builder, where I started with one SQL statement: UPDATE tblName SET FieldName = Trim(FieldName) I...	February 3rd, 2007 11:52 PM by CompleteNewb	3	80
how to use count in a query by Trevi I cant figure out how to get Count working. I want to know how many orders somebody made between a range of dates. I used count in one query: select...	February 3rd, 2007 08:35 PM by Trevi	2	86
Research Study Mailing/Participation Summary Table - Multiple Fields Multiple Dates by Kay I need to produce a summary report of participants in a research study. Here are the steps: 1. We first send out an initial/introduction letter telling...	February 3rd, 2007 08:23 PM by Kay	0	83
Put a total at the bottom a column by edward keith I have a column for travel time in a table. I would like the column to have a total for travel time at the bottom of the query results. I Thought using the...	February 3rd, 2007 07:16 PM by TNbuttman	2	98
Date ane Time Comparison by Bill Hi All, I have imported data into Access in which dates and times were entered into separate fields. I need to do calculations on the 'working hours' between...	February 3rd, 2007 05:52 PM by John Vinson	5	78
Query of donors by number of donations made by KG A charitable organization that I am helping with has a list of Donors (containing personal details) and a separate table of Donations made, the two tables...	February 3rd, 2007 05:38 PM by KG	5	121
insert into produces error in autonumber field by muyBN I've read a lot of articles and posts that say if you have an auto-incrementing field, just leave that field out when you're inserting a new record into a...	February 3rd, 2007 03:21 PM by Jason Lepack	1	75
Advice and guidance please by Mike Green Hi All I am looking for some guidance if someone would be so kind as to indulge with me for a moment. I am trying to create a Db to record Job cards, Work...	February 3rd, 2007 11:53 AM by Mike Green	4	72
query to filter records by Ian I created a query where the user can type in the firs couple of letters of the name (or phone or clientID) and the underlying subform/query will be filtered...	February 3rd, 2007 07:15 AM by John Vinson	2	89
Missing Records due to Date by Confused Slug I am using a simple select query to refine a list of records. One of the parameters i am using to refine the list of records is a date. On one PC when i run...	February 3rd, 2007 07:11 AM by John Vinson	2	91
Searching a word in a string by radiaz via AccessMonster.com Hello, I have this DB that has over 100,000 rows. I need to search a column "subject" for this word "I-40". I've tried the following " like I-40 " and...	February 3rd, 2007 04:30 AM by John Spencer	1	86
Adding two tables together by dwaynesworld I have two tables which list employees who have completed mandatory testing for each subject. What I would like to do is combine the data into 1 table...	February 3rd, 2007 04:29 AM by John Vinson	2	78
how do i get my query to do this by Nih Alot of times I have to work with large groups and need to whittle that group down to just the ones that do not match. For example I have two tables that...	February 3rd, 2007 04:25 AM by Marshall Barton	1	68
attn: abby - highly good nntp groups - eyfe - (1/1) by wright Really need to share this with everyone… They give you access to some of the best groups others may not carry. Take a look at all the great features below and...	February 3rd, 2007 04:11 AM by wright	0	82
Search By Month by Haggr via AccessMonster.com Criteria: how to search data by every month for every year? -- Message posted via...	February 3rd, 2007 02:14 AM by Haggr via AccessMonster.com	2	110

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