Running & Setting Up Queries - Page 144

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
counting yes/no fields by Joachim[_4_] I have an access table where i need to make a query to count the meals they eat in school in a week for a group of people. In the query i want to show the...	October 5th, 2009 04:36 PM by John Spencer	3	126
Query only numbers out of a list with letters and numbers by Aaron Good morning. I have a list of model numbers in which some start with letters and some start with numbers. For example, I...	October 5th, 2009 03:23 PM by KARL DEWEY	3	188
calculate results show funny figures by KarenY Hi, I have to run a qry to get the different value of 2 fields from 2 tables. Yet some rows come back with funny values for all those minus figures. (e.g....	October 5th, 2009 03:04 PM by KarenY	3	131
Help - how could I query a memo field and get one or more 4-character data ? Tough as hell for us to figure this out ... TIA by TIA TIA TIA - Jim The field was *******ized ... It is a memo field that was designed to capture certain narrative, instead it has been used (and by necessity) and continues to...	October 5th, 2009 01:29 PM by Dale Fye	3	165
Charactor in a string by alecgreen Hi I am looking for a certain charactor (P) at the end of a string, but the string length may vary, for example 1P, 123P or 12345P Any ideas...	October 5th, 2009 11:00 AM by Ken Snell	1	169
Update by subs customer dzip New Customer proctoandg 10024 procto procto 10024 procto procto 10024 ...	October 5th, 2009 01:21 AM by Jeff Boyce	3	141
Update query with multiple spellings by subs customer id customer New customer 10021 pg pg 10021 pgr ...	October 4th, 2009 10:02 PM by John Spencer	3	110
Error - CANNOT HAVE AGGREGATE FUNCTION IN EXPRESSION by Ann Scharpf I have a query where I am calculating labor costs. It was working until I tried to add a calculation to add the cost of living allowance (COLA) if the pay...	October 4th, 2009 08:25 PM by Ann Scharpf	4	189
Too Few Parameters....again by BriefTales I know this have been visited. I've read all of the posts but to no avail. Here's my...	October 4th, 2009 07:53 PM by Duane Hookom	3	117
Limit Query to Current User Name by Mark I'm trying to build a query that will report production stats for system users, but I'd like to limit the results to the current user. The username is a...	October 4th, 2009 02:01 PM by Mark	5	192
Find Records in Identical Tables by jlo Monthly I bring in a txt file in Access. What I want to do is create a query that will take the previous months data and compare to the new months data. ...	October 4th, 2009 01:31 AM by John W. Vinson	2	123
Join not Supported by vinodh ramadurai The below query is not working. i am getting error like 'join not supported' SELECT Tbl_ProductGroupMaster.ProdName, Tbl_ProductGroupMaster.UnitNam,...	October 3rd, 2009 08:42 PM by Lynn Trapp[_3_]	1	98
In clause from form by QB Is there a way to setup a cbo ctrl to be used as an In clause within an SQL statement? I set one up In (!.) Where my cbo returns value like 'Open' and...	October 3rd, 2009 06:19 PM by John Spencer	4	127
How do i get a query to display approved or not approved by trader151 when i run the query it is displaying the field as a -1 or 0 i need it to display as approved or not approved http://i34.tinypic.com/ioixeb.jpg	October 3rd, 2009 06:10 PM by John Spencer	2	111
blank fields on a report by DKnight via AccessMonster.com Hi, I am trying to run a report and I have four address lines. On the report, if the first address line is blank, I would like to print the second address in...	October 3rd, 2009 06:06 PM by John Spencer	7	122
Using query to make a table by Jael I have a table that's linked to a xxx.cvs file. I use a query to make a new table with modified data in it. The first time I use the query, it works fine. ...	October 3rd, 2009 05:11 PM by Jael	5	127
Access 2002 SQL Problem by johnb Hi all I have the following SQL code snippet and it produces the incorrect number of records when its run by Docmd.RunSQL strSQL, but the correct number...	October 3rd, 2009 11:34 AM by Stefan Hoffmann	1	124
Count not right by QB I have a table that I am using to generate a pie chart from by counting the number of instance of in a column. However, to always display all the choices,...	October 3rd, 2009 04:26 AM by Marshall Barton	1	98
Creating a month field by mccallen60 Hello, I receive a monthly report of total prescriptions processed from a independent vendor. This report utilizes a rolling 24 months. TRx Month24 TRx...	October 2nd, 2009 11:46 PM by KARL DEWEY	3	99
What's wrong with this query? by vvenk I am new to SQL and your help is very much appreciated. The Table VISIT_TYPE has a o-M relationship with PATIENT_VISIT. I am trying to update the fields,...	October 2nd, 2009 10:15 PM by John Spencer	6	152

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