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 MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
MS Access Between Query Statement Question
Sorry, I meant that I want it to return accounts 100001 and 100002 as part of the recordset, with the new ReportSequence field being 1.- twwayne
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
MS Access Between Query Statement Question
I have two tables that I want to use to use a between query statement for. The first table and example data: Sequence =1 beginaccount = 100001 endaccount = 110160 The second table and sample data: Account = 100001, 100002 I want to write a statement that says if the account is between the...- twwayne
- Thread
- Replies: 2
- Forum: Microsoft: Access Queries and JET SQL
