Running & Setting Up Queries - Page 34

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.

		Home » OfficeFrustration forum » Microsoft Access
Running & Setting Up Queries

Home

Page 34 of 2165

Threads in Forum : Running & Setting Up Queries

Forum Tools

Search this Forum

Thread / Thread Starter	Last Post	Replies	Views
A Simple Query problem? by Ian Chappel I've wrestled with this one, but can't quite manage it! I have a tblStatement containing fields StatementID, Date, Description, and Value. For all records...	April 18th, 2007 07:08 PM by Ian Chappel[_2_]	4	87
a simple query with date by Gonsior Andreas Hi Newsgroup! I've got a litte problem with an sql statement, I'm sending to an access mdb by an C++-Application, to get "a newer value than the last...	September 27th, 2004 05:28 AM by Gonsior Andreas	2	120
a simple query, maybe by JohnL I have a table of part numbers. I want to query the table to return a list of those part numbers whose last character is the letter D.	April 8th, 2005 06:09 PM by JohnL	3	89
A simpler way to do a pseudo-autonumber in a query by Conan Kelly Hello all, Isn't there a simpler way of doing a pseudo-autonumber in a query? I saw in one post someone mentioned doing a subquery (IncNum: (SELECT Count(*)...	October 5th, 2007 02:43 PM by Duane Hookom	4	76
A single date in query by MimiSD In the database i am creating I have a table that contains the date a task was done along with start and end times. I would like to create a query which i...	June 13th, 2006 07:15 PM by MimiSD	8	107
A SOLUTION FOR THAT QUERY by Frank Dulk It follows the following query below: Select rel_30.cpf, rel_30.cliente, rel_30.enderecoentrega from rel_30 where (((rel_30.enderecoentrega)In (Select FROM ...	April 6th, 2005 01:51 PM by John Bell	2	258
A spin on a common question. DateAdd by Flopbot This is a spin on a common question. I have a query with a field labeled: Day: Format(,"ddd, mm/dd/yy"). I need it to display the day along with the date...	April 23rd, 2010 11:33 PM by Flopbot	2	208
A subquery? Not sure if this is doable? by kohai Hi, Any help out there that the masters can shed some light on would be greatly appreciated. I have tables where data is stored based on different...	February 8th, 2006 06:40 PM by Michel Walsh	5	44
A table to preserve manual updates by [email protected] Good afternoon, I have an Access database used for reporting monthly data. I basically import data from a third-party software, run reports to find errors,...	September 29th, 2008 01:57 PM by [email protected]	4	108
A table with two fields pointing to the same field in another table by [email protected] Hi, I have a table called Test. This table includes two fields called "Start_Date_Name" and "Finish_Date_Name". These fields hold the primary Id of a row in...	June 5th, 2007 10:25 AM by [email protected]	1	48
A Team Required for an update query by Rivers Ok peeps my head hurts and its seriously taxing my time and patience i think its time for the A Team lol (A=Access) ok heres my issue. im creating a...	November 24th, 2009 03:17 PM by vanderghast	1	169
a top n query where the n is field in another table? by Howard a problem to do with bidding on a limited number of items. (simplified form) table1 contains housetype and NumAvailable e.g. type numAvail A 7 B 2 C 5 table2...	April 24th, 2008 12:59 PM by John Spencer	3	92
A tough problem by Tim Hi folks, I need a urgent help on my query. I have Sales and tblField tables Sales table have the following field: Invoice Code Amount	July 14th, 2004 02:53 AM by MGFoster	1	91
A tricky select Query for me by swark Running MS Access 2000 ver 9.0.3821 SR-1 I have a table thus: (ID)(project name)(level) 1 xxx 1 2 xxx 2 3 xxx 1 4 xxx 1 5 xxx 1 6 xxx 2 7 xxx 2	July 23rd, 2008 01:52 AM by Bob Barrows [MVP]	5	95
a tricky selection query by Howard I need to select the latest of several duplicate entries. An output from an education database has left me with a table of grades for different subjects,...	January 24th, 2008 12:44 PM by John Spencer	4	89
A union B works, A union B union C fails by Phil Smith Each individual query is fairly simple. One table has fields for three possible sales reps, I need to treat them as as one set of fields. Each query is...	November 29th, 2006 05:50 PM by Phil Smith	2	71
A very Challenging Question? by Eskimo Hi All, Satellite Collars (Named PTT on the table) on Caribou acquire a position "fix" everyday at a certain time. It records the Postion with a... ( 1 2)	May 26th, 2006 07:46 PM by Eskimo	15	113
a very slow SQL query by dshemesh Hello, I have an access project with a Table containing about 3000 records, and growing. The table contains an Id field. The Id is a number which always starts...	April 8th, 2005 03:01 PM by Jeff Boyce	4	78
A vs B query? by jlillge I'm not even sure if a query is the right way to go about finding my answer, so I could use some direction. I have one table with about 10 columns and around...	June 14th, 2007 07:26 PM by John Spencer	5	60
A way to find "no match" when two columns needed for linking? by Laurel I have a table, tblScores, containing Student_id and score_date and another table, tblAttendance, containing student_id and att_date. Is there a way I can...	July 2nd, 2007 03:10 AM by Dale Fye	6	67

Page 34 of 2165

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

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is Off HTML code is Off

Forum Jump

All times are GMT +1. The time now is 02:25 AM.