Running & Setting Up Queries - Page 1002

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
Group By - Data Type Mismatch in expression Problem by Andibevan When I use the following query I get an "Data Type Mismatch in Expression" error. When I do it without the Group By clause it works fine (see...	October 5th, 2006 03:33 PM by Andibevan	1	73
Expression based of Query by TKM I have a query which looks like this.. Process Date Amount: .*. I am trying to get results from the above field and use them in another query multipling by...	October 5th, 2006 04:14 PM by TKM	0	50
Help with a query by Ashley THIS IS THE SAMPLE DATE I want to see supplierID, sum of amount shipped and sum of amount not shipped, and group them by suppier, total no of orders accpted...	October 5th, 2006 04:39 PM by Ashley	0	54
Delete any record with an alpha in a field by Andy I have a table with a field that was imported as text and need to delete out any record where this field contains an alpha digit in any one of the 7...	October 5th, 2006 04:44 PM by John Spencer	4	115
Criteria in Expression by briank My totals query includes a calculated field set up as an expression. So far all works fine until I try to add a criteria to this calc field. The popup menu...	October 5th, 2006 04:51 PM by John Spencer	3	104
IIF Syntax by Paul LeBlanc I'm having a problem with the following statement SOURCE: IIf(Mid$(!,1,2)=!,!) When I added it to the SQL statement SELECT TblPROP.CODE, VARIETY.NAME,...	October 5th, 2006 05:15 PM by Paul LeBlanc	2	92
Multilevel elapsed times by Pret I'm trying to develop a timeliner application, wherein the user enters times and events and can report them out in sequence, along with elapsed times from the...	October 5th, 2006 05:23 PM by Pret	0	70
using a parameter query populate a subform by ritu hi i m new user for the ms access i have table employee i wan to create a form with a sub form , on the form i wan toc all the information of themanagers...	October 5th, 2006 06:15 PM by ritu	0	73
One-to-Many Query by Karen I'm not sure I want to be using a query to do this but I'll put it here anyway... I have two tables that I need to reference to print a Certificate. The...	October 5th, 2006 06:16 PM by Karen	3	106
Results based on ("Left") ("Right") criteria. Please help by TKM I need Transaction Description for a given TR_NO displayed. My results displayed need to come from the following criteria.. If the first number in my TR_NO...	October 5th, 2006 07:01 PM by TKM	8	114
need to extract specific characters from field by MES via AccessMonster.com I have a field in a table that lists a person's name as . So the way a name appears in the field is Doe,John. I would like to build two expressions that...	October 5th, 2006 07:18 PM by Jeff Boyce	4	92
Query for Double Quotes / Quotation Marks by Dawg House Inc I am trying to query in Access for a value in a field that contains a quotation mark (or double quote). Example: Field1 value = "Mr. John Smith I want...	October 5th, 2006 07:49 PM by Dale Fye	3	79
List Box by Dan @BCBS My query runs based on Data Data entered on a form: WHERE (((tblQualityData.IssueCloseDate) Between !. And !.) When I add: WHERE...	October 5th, 2006 07:53 PM by KARL DEWEY	4	62
pull individual data out of one field without pulling all data by VZDatageek I'm trying to pull delimited data that is contained within one field in my database. Is there a way that I can isolate and pull one portion of the delimited...	October 5th, 2006 08:08 PM by John Spencer	2	69
Summing the Top Five problem by Mandy I have an Access 2000 database with a table that contains the results for several athletics events. The competitors receive 100 points for winning an event...	October 5th, 2006 08:13 PM by Liz Fry	4	141
Duplicate query question by Mikey B I have a table with Package#, Reference#, PartLocation, and PartDescrip. I am trying to find distinct records of Package# and inlcude all the other...	October 5th, 2006 08:28 PM by Mikey B	2	71
Results are false null by mdavison I have a schedule table with anAutocount, a date and a class code. Dual primary is AutoCountID and the Date, so that I can schedule more than one class per...	October 5th, 2006 08:40 PM by mdavison	2	58
SQL INSERT question by mscertified I need to insert 3 columns into a table, the first column comes from a SELECT from another table, the second and third columns are fixed values. Does anyone...	October 5th, 2006 08:44 PM by Duane Hookom	1	65
Append Query does not Work but same query as a select does by ReginaGINY I have an append query that I am trying to run. When I run it the records are repeated. But if I change the query to a select query the records only appear...	October 5th, 2006 09:01 PM by ReginaGINY	4	76
Query does not count all records by chris I know I am new at this but seriously, I have a table that has 105,592 records in it. I build a query that works fine until I add the total row in. Once the...	October 5th, 2006 09:10 PM by chris	3	66

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