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!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

QueryDefs?

Status
Not open for further replies.
Rjc8513

Rjc8513

Technical User
Feb 12, 2001
140
US
Main table: [DataTable]
Table of files: [FileTable]

I want to use Left([FileTable].[FileName],6) as the criteria in a query of [DataTable].[IDNo] and print the report [rpt FILE NAME] for the desired [IDNo].

Can this be done using code, i.e., QueryDefs?

Thanks.
 
Status
Not open for further replies.

Similar threads

VickyC
  • Locked
  • Question
best practice in locating QueryDefs 1
Replies
6
Views
56
VickyC
VickyC
Steve101
  • Locked
  • Question
Passthrough Queries and Parameters; Changing Querydefs and Multi-usability
Replies
3
Views
65
Steve101
Steve101
Trevahaha
  • Locked
  • Question
to use QueryDefs or not? Combine to one query 1
Replies
2
Views
24
Trevahaha
Trevahaha

Part and Inventory Search

Sponsor

Back
Top