Running & Setting Up Queries - Page 459

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
Calculated field????????? Simple probably by VSNT I have a table with number values in some columns ala Column: Sales and its value would be lets say 1 Column: Other and its value would be 3 Column: Totals...	August 25th, 2008 06:48 PM by KARL DEWEY	4	95
Find records not linked by Mark[_45_] Hi, I would like to create a query which only shows records that are not are linked. In this example I have a host table, a student table and a table to link...	August 25th, 2008 06:18 PM by Mark[_45_]	2	97
Update Query - Operation must use an updateable query by Mark[_45_] Hi, I am having problems with a simple query I am trying to put together. I have one table (called tblHost) and a query called qryCountStudentsHosted. Within...	August 25th, 2008 05:40 PM by Mark[_45_]	3	115
Date Parameter problems between the Query and Form by eschloss Access 2003, Win XP I am trying to automate the display and printing of my reports through a Form. The reports contain charts which have a Query row source....	August 25th, 2008 05:22 PM by eschloss	1	191
where...and... where... by mark_jm via AccessMonster.com I am tyring to write a row source in a combo to select crtaim data from a table where 2 conditions are met. I'm having problems with the syntax. Currently...	August 25th, 2008 05:20 PM by mark_jm via AccessMonster.com	3	160
I don't understand why this Delete Query fails? by efandango I am trying to delete some records from one table with matching in another table, but when I try and run the delete query, i get an error: 'Could not... ( 1 2)	August 25th, 2008 03:54 PM by efandango	11	371
Next Receipt# When PurchaseOrder# Changes by meangene Want to populate a table with fields Receipt_No, PO_No, Item, Qty_Rcvd, Rcv_Date Where the Receipt_No will change to the next +1 value if the PO_No changes....	August 25th, 2008 12:46 PM by meangene	1	103
Ucase, Lcase, First Letter Upper Case? by mcl[_2_] We're using office 2007 at work now (downgrade as far as I'm concerned). But I have a question about UCase & LCase. Seems I remember seeing a command to...	August 25th, 2008 07:01 AM by John W. Vinson	3	130
anish add by anish www.hollywoodphotos4u.blogspot.com	August 25th, 2008 06:30 AM by anish	0	123
Representing null returns as zeros in calculation by Sue Compelling Hi My query purpose is to establish the % of leads (dead ones in this case) PER campaign PER month against the total leads for each campaign. In the...	August 25th, 2008 06:14 AM by Sue Compelling	1	124
query question by j.j. Hi, everyone I have two tables One is a invoice table including date, invoiceno, amount and then other is payment table including...	August 25th, 2008 03:52 AM by Allen Browne	5	168
Using Lookup field in a table to help calculate a Total by CPOconllo OK fairly new at access so please bare with me. I have a table that I am trying to add a querry to that gives me a total, however that total needs to be...	August 24th, 2008 10:40 PM by tina	1	89
Calculate a field based on combo box column by whitjl143 I have a form that is based on a query. On the form I have a combo box 'Material' that has 3 columns. I have another field on the form, 'OurPrice' that...	August 24th, 2008 07:06 PM by Ken Sheridan	2	83
Count Occurances between dates by Ripper I have a frontend linked to a SQL 2000 database. I have a table (tblIssIn) that contains student assignments to ISS, IssInID(Auto#), LocID, StartDate,...	August 24th, 2008 06:32 PM by Ken Sheridan	2	116
Query within a Query - SQL in VBA by Steve S I have 2 Queries that are used to update a table. Query 14 selects 3 records from the table Fees that are then used to update 9 other records in table Fees....	August 24th, 2008 12:28 PM by Bob Barrows [MVP]	7	148
Exclude fields after SELECT * by Steve S I need to replicate a number of records from one table back into the same table so the user is spared the task of re-entering redundant data. this table has...	August 24th, 2008 03:26 AM by Steve S	7	184
Trim a word from a field by Liz C I have a field and I have it in a query, but if the word "compressor" is in that field, I want it to remove it. Can someone please tell me how to trim that...	August 23rd, 2008 09:26 PM by fredg	3	103
Text to short time by quinto via AccessMonster.com I did some research but what I found I could not use. Table linked to an external xls sheet all numbers and time are text formatted. The time looks like it is...	August 23rd, 2008 04:09 PM by quinto via AccessMonster.com	2	104
Data Type Mismatch by Love Buzz Hi all. I am just trying to group a query by certain criteria. When I set the queue as 11, I get the data type mismatch message. This is a relatively...	August 23rd, 2008 12:47 AM by Jeff Boyce	2	85
Query returns wrong records by Meredith Bliss Using Access 2007, I've recently encountered a problem where a query returns the expected number of results, but the wrong records. If I edit the SQL query...	August 23rd, 2008 12:03 AM by Meredith Bliss[_2_]	4	111

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