Running & Setting Up Queries - Page 161

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
Add OR IIF to my statement by Jon Dibble[_2_] Hi Can anyone please help me add to my statement? Currently it returns text based on data in a string field on our database. What I need to add is that if...	September 10th, 2009 12:49 PM by Jon Dibble[_2_]	0	149
query with conditions by subs ozip dzip shipdate 101 202 1/12/2009 121 202 1/12/2009 131 12 1/14/2009 11 12 1/14/2009 5 7 1/20/2009 8 ...	September 10th, 2009 06:18 AM by KARL DEWEY	2	131
query by subs SELECT X.* FROM PPG AS X INNER JOIN PPG AS Y ON (X.BLY.BL) AND (X.Ship_Date=Y.Ship_Date) AND (X.Consignee=Y.Consignee) AND (X.Ozip=Y.Ozip) AND...	September 10th, 2009 05:59 AM by KARL DEWEY	2	119
query with conditions by subs ozip dzip shipdate 101 202 1/12/2009 121 202 1/12/2009 131 12 1/14/2009 11 12 1/14/2009 5 7 1/20/2009 8 ...	September 10th, 2009 05:56 AM by subs	0	93
query by subs SELECT X.* FROM PPG AS X INNER JOIN PPG AS Y ON (X.BLY.BL) AND (X.Ship_Date=Y.Ship_Date) AND (X.Consignee=Y.Consignee) AND (X.Ozip=Y.Ozip) AND...	September 10th, 2009 03:41 AM by subs	0	96
Pls correct this query by subs SELECT X.* FROM PPG AS X INNER JOIN PPG AS Y ON (X.BLY.BL) AND (X.Ship_Date=Y.Ship_Date) AND (X.Consignee=Y.Consignee) AND (X.Ozip=Y.Ozip) AND...	September 10th, 2009 03:27 AM by subs	0	111
Can't type double quote in query. by JimTunes Can someone tell me what sequence of keystrokes I've inadvertently entered that now prevents me from typing double quotes in (zoomed) query entry fields?...	September 10th, 2009 02:15 AM by JimTunes	5	151
SQL Driver or SQL Native Client for ODBC connections by MM[_2_] Is there a difference between the default SQL Drive and SQL Native Client when linking to SQL 2005 DB?	September 10th, 2009 01:57 AM by Bob Barrows	2	201
SQL Driver or SQL Native Client for ODBC connections by MM[_2_] Is there a difference between the default SQL Drive and SQL Native Client when linking to SQL 2005 DB?	September 10th, 2009 01:34 AM by MM[_2_]	0	102
auto export (scheduled) table to text by MM[_2_] I have a macro set to automate the export of a table to text on a schedule (using Total Visual Agent) I would like to autoname it CSIDATETIME and I have very...	September 10th, 2009 01:32 AM by MM[_2_]	0	97
auto export (scheduled) table to text by MM[_2_] I have a macro set to automate the export of a table to text on a schedule (using Total Visual Agent) I would like to autoname it CSIDATETIME and I have very...	September 10th, 2009 01:32 AM by MM[_2_]	0	87
UDF in query of linked table Causes #Error by David Taylor[_2_] The following query returns #Error when tblDocuments is a table in a linked Access database. SELECT PCase(tblDocuments.DocumentFilePathNew) FROM...	September 10th, 2009 01:12 AM by MGFoster	8	160
Shifting column headings - not data... by Monish Hi I receive a file monthly from an automated feed, which we have just realized has mislabeled some fields: essentially, the label for column number 20...	September 10th, 2009 12:54 AM by MGFoster	8	112
Linking multiple tables by Sripalkumar Hi, I am trying to create a query which links around 13 tables. Each of the tables have a unique ID which is similar for all tables. It is a patient... ( 1 2)	September 10th, 2009 12:21 AM by Sripalkumar	10	187
Linking multiple tables by Sripalkumar Hi, I am trying to create a query which links around 13 tables. Each of the tables have a unique ID which is similar for all tables. It is a patient...	September 9th, 2009 11:09 PM by Sripalkumar	0	105
Creating a field based on another column using Switch or IIF? by lsetla1 I tried the following: Expr1: Switch(='Davis High School' Or ='West Valley High School',â€˜Yakimaâ€™,='Tonasket High School',â€™Tonasketâ€™,True, ) ....but...	September 9th, 2009 10:46 PM by lsetla1	0	108
IIF "and" statement by slotmgr70 I'm trying to create a simple IIF state ment that looks at two seperate fields and returns a code. For example: IIF =500 AND ="Inner Market", "BD_500IN",...	September 9th, 2009 10:39 PM by KARL DEWEY	4	148
IIF "and" statement by slotmgr70 I'm trying to create a simple IIF state ment that looks at two seperate fields and returns a code. For example: IIF =500 AND ="Inner Market", "BD_500IN",...	September 9th, 2009 10:20 PM by slotmgr70	0	101
Access question regarding number formats by Styrmir Hi there I am having a minor issue with my access. I am linked into our database through Access. All monetary columns have a 15.2 format which means access...	September 9th, 2009 09:27 PM by MGFoster	1	103
Showing only one record from many-to-one relationship by JohnM77 via AccessMonster.com Consider the following scenario: Two tables: tParent tParent.ID (Autonumber) tChild tChild.ID (Autonumber) tParent.ID (Many-to-One relationship...	September 9th, 2009 08:31 PM by JohnM77 via AccessMonster.com	4	231

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