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 Wanet Telecoms Ltd 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
- Content: Threads
- Order by date
-
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, 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
