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 Shaun E 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: IllinoisREI
- Content: Threads
- Order by date
-
Combine Multiple Queries
My list of queries is growing out of control. I frequently find myself creating multiple select queries to be used to create other select queries because of the need for unique joins at each stage. I've combined queries with union queries using straight sql but is there a similar approach where...- IllinoisREI
- Thread
- Replies: 1
- Forum: Microsoft: Access Queries and JET SQL
-
Need criteria for use with DFirst function
This has me completely stumped. Using this table as an example, ID Date Field1 Field2 Field3 1 1/1/09 600 0 1/4/09 2 1/4/09 600 600 1/4/09 3 2/1/09 1200 600 2/15/09 4 2/15/09 1200 1200 2/15/09 5 3/1/09 1800 1200 4/1/09 6 3/8/09 1800 1200 4/1/09 7 4/1/09 2400 1900 null 8 4/6/09...- IllinoisREI
- Thread
- Replies: 8
- Forum: Microsoft: Access Queries and JET SQL
