Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: Clipper4000
- Order by date
-
Question on the IN sub-clause of the Having clause
Thank you for the pointer !- Clipper4000
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
Question on the IN sub-clause of the Having clause
I have a query which utilized the having clause like this: Select ... From ... Group BY Account, ... Having Account IN (1000, 2000, 3000) This query worked. What I want to be able to do is to use a function to return the values in the IN sub-clause. Could this be done in Access SQL? I am...- Clipper4000
- Thread
- Replies: 2
- Forum: Microsoft: Access Queries and JET SQL
-
How to use referencial intergrity with compound primary key
Hi, To create a compound primary key: 1). Go to table design. 2). Select the Index icon. 3). Define a list of field names (in the field name column) to be included in the compound primary key in the order you like. This list of field names will then act as one primary key name. 4). Now you...- Clipper4000
- Post #4
- Forum: Microsoft: Access Tables and Relationships
-
How to use referencial intergrity with compound primary key
Hi, I found the solution, thanks.- Clipper4000
- Post #2
- Forum: Microsoft: Access Tables and Relationships
-
How to use referencial intergrity with compound primary key
Hi, This question has came up once on July 2004, but no conclusive answers were given. How would I set referencial intergrity in the relationship window if my tables use 2 fields combined as a compound primary key. (ie, PurchaseNumber & ItemNumber). I know how to set the relationship, but I...- Clipper4000
- Thread
- Replies: 3
- Forum: Microsoft: Access Tables and Relationships
