Running & Setting Up Queries - Page 201

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 Between times by anna_717717 Hi all, hope somebody can help I've got two tables. Table 1 has the data against a batch of product, data about the batch test setup and has the test date...	July 10th, 2009 01:58 PM by John Spencer	1	169
Ranking by Bill I have the following SQL statement that will rank my data. I am trying to perform that ranking within age groups. I cannot get it to work. Can anyone...	July 10th, 2009 01:54 PM by Bill	6	109
Update query help by jenksonu via AccessMonster.com I'm trying to update all records in one table GCI.EmployeeName to House after I add a check to y/n field in table2 EmployeeInfo UPDATE GCI.EmployeeName to...	July 10th, 2009 10:41 AM by MGFoster	1	144
update query by fresher Dear Team, I have created 2 queries which contain 2 difference result set, in fact this 2 queries from same table and this table linked from SQL database....	July 10th, 2009 05:03 AM by fresher via AccessMonster.com	2	149
Sorting data with query by frogstyle First let me start by apologizing... If this question has already been answered, I don't know where to look for it. I went through several pages of posts...	July 10th, 2009 02:52 AM by John W. Vinson	4	132
UNION, WHERE or Something else? by Thomas I have a mailing list where there are multiple yes/no fields. A record can have multiple Yes or just one. One of the fields is a Text for emails. Not all...	July 10th, 2009 02:10 AM by John W. Vinson	3	129
If Like "#" gives me everything that starts with a number, what do I use to get only alpha? by Kelvin[_3_]* This gives me everything that starts with a number, Like "#" How do I get everything that starts with an alpha character? I guess Not Like "#" would be an...	July 10th, 2009 01:02 AM by John Spencer	4	164
Query (Recordset) is Not Updateable by LA Lawyer I have a query that has a single table linked one-to-one to two other tables. I want to update a field that exists only in one of the tables. This field is...	July 10th, 2009 12:59 AM by John Spencer	1	115
In String - Urgent Request by Sean Is there a way to use the in string function to pull out text if you do not know the position of the text you are looking for? For example, if my string...	July 10th, 2009 12:57 AM by John Spencer	5	110
Query the ealiest date within several columns in table by Alison Hi, I have a database of projects with four different date columns (DOB, First LWS, First SLDWS, and First SA). Some of these fields are blank. I want to run...	July 9th, 2009 11:21 PM by KARL DEWEY	1	130
Counting posts by Twisty I need to count lines/posts in i a report. The report shows dates or "no dates" (empty fields). I need a "Total-line" in the bottom of the report, which...	July 9th, 2009 09:33 PM by Twisty	8	143
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	138
sql string as field data; ado? by robert.waters How might one escape an SQL string for insertion into a table? I have a multi-user Access db, with users that create their own queries that need to be synced...	July 9th, 2009 09:01 PM by MGFoster	1	89
"microsoft office access" unknown error by jcandamo I'm getting a "Microsoft office access" unknown (error with exclamation mark) when opening a table in a MS Access 2003 database. The error happens in one...	July 9th, 2009 09:01 PM by jcandamo	1	150
table by Tammy I have a table that i want to pull queries from. I want to see all the homes with an address on Andalusia. So I want my query to pull all the homes on...	July 9th, 2009 08:45 PM by Tammy	2	103
template for timesheet - calculation wrong by SS I AM USING THE TEMPLATE FOR TIMESHEET WITH BREAKS BUT CAN NOT UNDERSTAND HOW MY TOTAL CAN BE 53.77 HOURS AND NOT 54.17? I'M CONFUSED WITH THE CONVERTION TO...	July 9th, 2009 08:06 PM by MGFoster	1	122
query for non matching fields by kevin[_8_] Hello, I have two spreadsheets with first and last names and other info. I want to query the two so the result is the names that are NOT duplicated in the two....	July 9th, 2009 07:22 PM by kevin[_8_]	2	116
three query union. by Thomas Trying to make a three querry, but every time I try I get an error message that MS Accesss DB can't find object ". I have 4 querries They all work & they... ( 1 2)	July 9th, 2009 06:31 PM by Thomas	13	249
how to select a random item from a field by JohnL I am building a simple database to randomly select items from a table, but can't seem to build a query that will randomly select one record from the...	July 9th, 2009 06:09 PM by KARL DEWEY	1	127
Calculating days from last meeting held by Tina Hudson Good afternoon, I need to set up a query for a report that shows a list of all active cases by unit and the date of the last TDM Meeting for each case. TDM...	July 9th, 2009 05:26 PM by Jeff Boyce	4	141

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