Running & Setting Up Queries - Page 143

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
Help with query by ironwood9 via AccessMonster.com I need help re-designing a query to get the desired results that is source by a query that uses temp/alias fields, from two tables tblCust ...	October 6th, 2009 02:49 AM by smartin	5	126
Not part of Aggregate/Can't have aggragate by Phil Smith I ran into something like this before with this same dataset, got help here from John Spencer, but can't seem to translate that solution to this problem. I...	October 6th, 2009 12:28 AM by Phil Smith	2	112
Building Expression in Query by Alberta Rose Good day. In my query I am looking to write an expression that performs mathematical calculations between 3 tables/queries which are listed in this...	October 5th, 2009 10:50 PM by Alberta Rose	2	108
Passing Criteria From a Form by Kevin D. I have a Query named qryZipCode based on tblZipCodes which looks up the City and State for a certain Zip Code. The criteria for the "ZipCode" field is...	October 5th, 2009 10:39 PM by Jeff Boyce	1	122
How can I show the number of rows pasted by a macro? by Tiff I have created a macro that autopastes the rows but need to know how many rows I am autopasting. thank you tiff	October 5th, 2009 10:08 PM by John W. Vinson	3	120
Append Query to a Linked Table by Erika I have a linked table and I am trying to create an append query to update it and it is not working. The table is actually a paradox table, I am working with...	October 5th, 2009 09:08 PM by Erika	2	145
Checking for any null fields by Jennifer I want to run a query that will display ALL records with ANY null fields. For example, on addresses, if a state or zip is missing in one record, and the...	October 5th, 2009 09:06 PM by John Spencer	8	132
Concatenating the same field from multiple records by DawnTreader Hello All another wierd query question. i have a union query where i get some duplicated part numbers. there is a field that i would like to show the actual... ( 1 2)	October 5th, 2009 09:02 PM by DawnTreader	16	286
Project FTE changes by pib311 via AccessMonster.com Hi everyone, I used to have a companion/equal to bounce some of these ideas off, but no longer. I am looking for someone to assist in creating this dataset...	October 5th, 2009 08:59 PM by pib311 via AccessMonster.com	2	124
Access 2003 Query by Michelle Whitfield Hi, I hope you can help me. I am trying to write a query where I can search two fields and bring back the results ( by last name). The fields names are Owner...	October 5th, 2009 08:31 PM by KARL DEWEY	1	98
Field Name aliases - A2007 by Lynn Trapp[_3_] I just noticed something that I have never observed before. When writing an SQL query in A2007, if the field name of the table has the Caption property set...	October 5th, 2009 07:27 PM by johnlute	3	148
date format by LG If I am bringing in a txt file that is , and " delimited, how do I change the format of the dates? Example the dates come in as 20080229, normally in excel...	October 5th, 2009 06:59 PM by LG	6	112
Transpose 2 rows to 2 columns by James Hi, I have a query setup that outputs data to an excel file but in row format. Id like to take every entry and transpose it to 2 columns. Id like to make it...	October 5th, 2009 06:40 PM by KARL DEWEY	1	117
How to Reduce Decimal Places? by lbohen In Access 2003, how do I reduce the decimal places in a text field? For example: 10.406666295 to 10.46.	October 5th, 2009 06:40 PM by Jerry Whittle	2	113
Multiplication Expression for Access 2003 Update Query by lbohen I have a which has several thousand records with numbers in each record's field. I want to multiply each number by .9333333 and update the number in . How...	October 5th, 2009 06:26 PM by John W. Vinson	3	165
Count if Populated by Antonette The district wants me to use the query part of MS Access. I know how to do it in VBA but they want me to do this in a simple query. Our district is going to... ( 1 2)	October 5th, 2009 06:23 PM by John W. Vinson	14	208
Counting up Yes/No fields in queries 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 05:47 PM by KARL DEWEY	3	155
combo box complexity by Louie I have a combo box on a form to look up a list of operators now keep in mind we have 3 plants and I need to be able to look up ALL the operators, a specific...	October 5th, 2009 05:41 PM by KARL DEWEY	5	162
update query ODBC--call failed by Lez[_6_] Hi Guys, I am trying to do an update query to an SQL table in a local db, and each time I run the query I get this error message: ODBC--call failed invalid...	October 5th, 2009 05:35 PM by Bob Barrows	3	180
Total based on status in crosstab by hoachen TRANSFORM Count(.) AS SELECT ., .ProvName, Count(.) AS FROM ( INNER JOIN ON .DateEntered = .) INNER JOIN ON . = . GROUP BY ., .ProvName PIVOT Format(,"mmm...	October 5th, 2009 05:34 PM by KARL DEWEY	7	122

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