Running & Setting Up Queries - Page 1501

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
Adding data in Queries by Quinto via AccessMonster.com I am at loss. I created a query from 2 tables. Tables have some common field names. I joined the date field and a BlockT field. I have entered some criteria...	January 13th, 2008 12:07 AM by John W. Vinson	2	106
Query an External Mdb by [email protected] Anyone know the syntax for a select query of a table outside of the current db I am operating from. For instance, let's say I am working out of...	January 13th, 2008 01:41 AM by [email protected]	2	115
change text to date by redFred I have read Allen Bowne's method (and others reponses here) to modify a table to change a field from text to date type. Create new field - update old into...	January 13th, 2008 02:02 AM by redFred	6	101
syntax for WHERE NOT IN?? to locate orphaned records by [email protected] Hi I have an A2003 database of contact activites which are allocated participants (stakeholders), however when a contact is deleted the code only seems to be...	January 13th, 2008 09:38 AM by [email protected]	3	140
Boolean in Query by Khartoum I have a query counting the number (sum) of ticks in a column i.e. yes/no data type. For each column, it is returning the numbers with a minus in front of it...	January 13th, 2008 12:38 PM by Khartoum	3	119
Query with alphabet by Arunoday I want to extract the data of persons whose names are started with the Alphabet i entered in the Parameter field. and what will be the coding for create a...	January 13th, 2008 01:54 PM by Douglas J. Steele	1	147
Show all fields from table in select query ? by Domino Hi all. I have 3 tables - INVENTORY, IN and OUT I made a select query to calculate the quantity of inventory on stock, but I only see the inventory items...	January 13th, 2008 02:02 PM by Allen Browne	1	120
Percentage Calculations in Pivot Tables by Rose Is there away to have a percentage calculation in a pivot table? -- Rose	January 13th, 2008 02:35 PM by Rose	0	96
Stopping the ability to save a query. by Rose I want users to be able to manipulate a pivot table to gather the information they need but not be able to save their changes. Any suggestions? -- Rose	January 13th, 2008 02:36 PM by Rose	0	83
Can I exclude the criteria Value from the query results? by efandango I am using the to match a list of records from a duplicates table against an ID form field, but want to exclude the actual value that the query uses as the...	January 13th, 2008 07:25 PM by Ken Snell \(MVP\)	1	156
JOINING TOGETHER MULTIPLE QUERIES by dje	January 13th, 2008 08:47 PM by dje	0	64
Limiting Query Results (to only certain days of the week) by FedBrad Hi All, I have a table that contains a record for each date, through several years into the future. On a form, I want to use a combo box to select a date to...	January 13th, 2008 10:13 PM by John Spencer	1	82
query from combo by KKruz I have a query in which I have criteria entered from several controls on a form combo list text field date field If one of the criteria is missing I get no...	January 14th, 2008 03:53 AM by Jeanette Cunningham	1	55
CrossTab Query that shows original data (text) by greene2j I am a scheduler and would like to build a pivot table in Excel or a Cross Tab Query in Access that shows the data in its original form (text) instead of...	January 14th, 2008 06:26 AM by Duane Hookom	1	82
Rows to columns - concatenation by George Dear friends, Happy New Year to all of you. Here is my big problem: I have developed a relational database using access 2003 with the following... ( 1 2)	January 14th, 2008 06:42 AM by George	12	204
duplicate records by patti I am getting duplicates in this query: SELECT .Date, ., ., ., .Demand, ., .Cat, .div, ., .Season, .class, .Style, .Status, ., ., ., .Demand, ., ., .Date, ....	January 14th, 2008 08:41 AM by Biz Enhancer[_2_]	2	71
query by date by Arunoday How can i extract the data with in a range of dates. suppose i want to retrive the data from 01/01/2007 to 01/12/2007. so what will the coding. bcoz here the...	January 14th, 2008 12:42 PM by Dale Fye	3	87
How to selectively insert data in fields by Wind54Surfer Hi all, I have a table "tblBills" with fields "orderID", "supplier", "suppliername" and another table "tblInstSales" with fields "orderID", "installername",...	January 14th, 2008 02:01 PM by Wind54Surfer	2	79
Query - Exclude Time by Sean I pull data out of my transaction table to determine the number of transactions a person does per hour. The time stamp within the database I pull the data...	January 14th, 2008 02:44 PM by Sean	0	75
Duplicates in some fields, but not others by AndyB Access 2003: I have a large table (several mm records) that has records with duplicate values in some or all fields. I am trying to get separate counts for...	January 14th, 2008 03:51 PM by AndyB	0	75

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