Running & Setting Up Queries - Page 206

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
Multi table query by hkraft Here's my problem... I need to sort information by physician name. The name is pulled from in the DICTMD table and is derived from in the Master table. ...	July 2nd, 2009 09:16 PM by hkraft	1	91
Add Table Name as Field in an Append Query by Ripper Is there a way to include a table name in a query? Scenario: Outlook Calendar exported to Excel Database contains 16 linked tables that are named for each...	July 2nd, 2009 08:51 PM by Jeff Boyce	1	111
DatePart function by Day of week I need to find the day (Sun,Mon,Tues....) from a date field (6/9/2009). I tried DatePart, However, all I get is a number. Can anyone help? Thanks, Jose	July 2nd, 2009 08:22 PM by John W. Vinson	2	95
if else with insert update by Andrew Hi all, I'm new with access queries, I've mostly delt with stored procedures. Is is possible to write a query that has an if/else statement e.g. if KeyID...	July 2nd, 2009 07:49 PM by KARL DEWEY	8	128
Checkbox controlled criteria by Kevin C Niven I wonder if someone can help. Either I don't seem to be thinking very logically this morning or I'm using incorrect syntax. I currently have a query with two...	July 2nd, 2009 07:40 PM by John Spencer MVP	2	127
Another case sensitive query by Taz I'm attempting to link a field in one table to a field in another table and it is only matching where the case of the letters match. All the fields in one...	July 2nd, 2009 07:37 PM by John Spencer MVP	2	95
Top N Records on multiple fields by CodeCrazy Hello - I have a table in access that I need to pull the Top 20 records for each different concatenation field. Here is an example table: Concatenation ... ( 1 2)	July 2nd, 2009 06:50 PM by vanderghast	14	249
Conditional Count Column in Query by pcbins I have a table that shows: REGION COND_A COND_B COND_C COND_D NORTH N Y Y N SOUTH N N N N EAST Y Y N N WEST N N N Y CENTRAL N Y N N I would like to run a...	July 2nd, 2009 04:34 PM by Duane Hookom	1	83
Query with INNER Join by Dale_Fye via AccessMonster.com Can you explain a little more about your table structure and maybe give some examples of the data? This may not be the most efficient way to do this. My...	July 2nd, 2009 12:29 PM by Dale_Fye via AccessMonster.com	1	91
Moving records by Neal Ostrander I have a database where we input orders on a daily basis. I need to archive these orders for possible future use. There are two tables that are used for the...	July 2nd, 2009 08:13 AM by Petr Danes[_2_]	3	228
Truncated Text by Ronald W. Roberts We use Access as a way for users to run queries against a large Oracle database. The MS access DB's uses a standard OBDC Link to attach the tables. So all...	July 2nd, 2009 04:12 AM by Ronald W. Roberts	0	140
My append Query does not work by Frank Situmorang[_3_] Hello, I do not understand my append qury does not work with message " Key violation, I do not now what is wrong with this: INSERT INTO bukuangkby (...	July 2nd, 2009 01:07 AM by John W. Vinson	2	146
query by alxw3 via AccessMonster.com can't get this right. IN THIS SELF TUTORIAL I TRY TO REACH OUTPUT FROM TABLE1. TABLE1: DB G0 G1 G2 G3 J0 J1 J2 J3 N0 N1 N2 N3 A0 A1 A2 A3 B1...	July 2nd, 2009 01:03 AM by John W. Vinson	6	123
Query with INNER Join by NeoFax I am having problems getting the below SQL to work: SELECT tblResults.Team, Count(tblResults.Loser) AS WinsAgainst, tblResults.Team1 FROM tblResults INNER...	July 2nd, 2009 12:11 AM by NeoFax	1	87
function that returns the field name by AccessMan I have a need for a calculated field in a query based on an expression that includes a function that returns a string containing a field name from an...	July 2nd, 2009 12:04 AM by Jeff Boyce	3	99
How to queryvery many conditions in VBA by Jim[_58_] I'm looking for a suggestion. As part of an ap, I have to find a set of records with a very large number of conditions and am wondering if there is a "best"... ( 1 2)	July 1st, 2009 10:51 PM by David W. Fenton	13	211
Inner join with some null values by Jim[_58_] Hi all, Here's a mystery I need to find a work-around for. Maybe someone has a simple solution. As part of a de-duping process, I'm finding duplicates...	July 1st, 2009 10:49 PM by David W. Fenton	9	224
YES /NO Query by Rpettis31 I have a query that I want to list of all records that do not have a yes it is the yes/no data type and I am not familiar how you query from this data type?	July 1st, 2009 10:44 PM by Clifford Bass[_2_]	1	121
Subtracting timestamps by Surayo Hi, I have two fields both timestamped, in long format (i.e. 6/14/2009 10:39:58 AM) and I need to find out the time difference between them. I used an...	July 1st, 2009 10:11 PM by Surayo	2	110
update query on a JOIN Table with a query Not Work by Boon Hi, I have a table A. Query B which is a select query from Table C. I am trying to update a field in table A by joining table A with Query B. Access doesn't...	July 1st, 2009 08:59 PM by Duane Hookom	1	107

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