Running & Setting Up Queries - Page 1156

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 Records with a certain value by The Bard Hi, I want to be able to generate a report that counts the number of instances that the number 2 appears in a field called BookingStatusID in a table called...	October 11th, 2006 10:30 PM by kingston via AccessMonster.com	1	64
Using SUBSTRING in query by walter via AccessMonster.com This is a query-of-query in ColdFusion and MSAccess This works ok cfquery name="session.getAlpha" dbtype="query" select distinct signerName ...	October 11th, 2006 09:37 PM by John Vinson	2	93
Missing duplicate records in query by Tony I am running a query to select all payment and payment reversal records for a corporation based on company name. When I do this I lose seven records because...	October 11th, 2006 09:33 PM by John Vinson	1	66
RIGHT function question by Phil Hello, I have a table (Main_Data) containing a string field (PID) that has 9 characters, with a sample value being 450895624. I have created a new field...	October 11th, 2006 09:19 PM by John Vinson	3	67
Querying Tables with Yes/No data types by Not_a_notes_fan Hi I am trying to query a table with Yes/No data types in it and keep getting either -1 or 0. Is there a way to change these values back to Yes or No, so...	October 11th, 2006 09:13 PM by Duane Hookom	1	59
Group By Problem - show row even when count = 0 by Andibevan I am using the following query:- SELECT tblApprovedDefects.RequiredFor, tblApprovedDefects., Sum(IIf((LookupResource())="Business",1,0)) AS...	October 11th, 2006 09:09 PM by Duane Hookom	3	82
Extract data from a field using a delimiter character by bdmsfan I have a column with the following values SCL (LP Steam Condensate) WF (Fire Water) P (Process Piping) etc... I need to extract only the characters inside...	October 11th, 2006 08:23 PM by kingston via AccessMonster.com	1	107
Parameter Query prompt - How to let user select all by Astello I want to set multiple parameter queries, and allow the user to enter a parameter for each of them or to select all if they don't want to limit that field. ... ( 1 2)	October 11th, 2006 08:20 PM by Astello	15	316
Missing duplicate records in query by Tony I am running a query to select all payment and payment reversal records for a corporation based on company name. When I do this I lose seven records because...	October 11th, 2006 07:39 PM by mscertified	1	77
Query based on 3 tables with parameters from form by SMA007 I have a main employee table that used to contain about 50 extra fields pertaining to employees skills and experience. In an effort to normalize data. I have...	October 11th, 2006 07:24 PM by SMA007	4	101
Missing duplicate records in query by Tony I am running a query to select all payment and payment reversal records for a corporation based on company name. When I do this I lose seven records because...	October 11th, 2006 06:40 PM by Tony	0	67
Can I do a query within a query? by Lythandra This is a question for Access 2000. I need to search a large table to find specific records (the criteria will be a date) then once these records are...	October 11th, 2006 05:27 PM by mscertified	1	88
export text file by Pat Coleman have a True/False field in a query that we want to export to a text file but when we do the true/false comes out as 1/0 Is there any way I can get the report...	October 11th, 2006 05:24 PM by Pat Coleman	2	87
Negative numbers by Matt Dawson I have built a query, that sums a field which is based on a combo box. As it only sums the combo boxes that are checked it gives a -1 for every input. For...	October 11th, 2006 05:24 PM by Matt Dawson	4	92
Top 100 by Jez Hi, Please help... I have a query buit with products ordered and How many. I am wanting to try create a Top 100 products ordered by the volume ordered, by...	October 11th, 2006 04:39 PM by Jez	0	58
Two tables, losing records by Matt Dawson I currently have a query which has sums based on whether a quote has been sent, in action, or rejected. I have built totals of these with percentages based...	October 11th, 2006 04:28 PM by Matt Dawson	2	83
Question about the two types of Join Property boxes in queries, please help! by Kelvin Beaton I've notice that in some queries I have different options when I look at the properties. One join type give me three options. Both values the same, All of...	October 11th, 2006 04:13 PM by Ken Sheridan	3	72
Comparing Two Tables by Xavier Hello, I was wondering if you guys would know the best way to pursue the following problem. I have two tables, one with the unique items and another with all...	October 11th, 2006 03:49 PM by Xavier	3	61
Date calculation as criteria in Queries by Super Wife Mom HELP!!! I have a query with a date field, TransDate. I want to pull up all records where the month section of TransDate is one calendar month before today's...	October 11th, 2006 02:50 PM by Super Wife Mom	2	68
counting three columns then sum those counts per employee by hollis via AccessMonster.com I am counting fields to track and reward employee productivity. These are date type fields. The associate enters a date for up to three different tasks they...	October 11th, 2006 02:36 PM by Duane Hookom	1	118

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