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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Access 97 question.

Status
Not open for further replies.
pyooi

pyooi

Programmer
Jan 15, 2003
12
0
0
MY
Hai...

i have a problem, how can i pass the sql condition from my form to a report, so that the report will display base on my condition.

Your help & support, is very usefull for me.
Thank you
Eric
 
Sort by date Sort by votes
Code: 
DoCmd.OpenReport "YourReport", acViewPreview, , "[NumericFieldName] = " & NumericValueOrVariable & _
" And [TextField] = '" & TextVariable & "'" & _
" And [DateField] = #" & Format([YourDate],"dd-mmm-yyyy") & "#"

HTH





[pipe]
Daniel Vlas
Systems Consultant

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Xavierparkash
  • Locked
  • Question
MS Access Slow Search in Linked Database
Replies
0
Views
86
Xavierparkash
Xavierparkash
BJZeak
  • Locked
  • Question
Struggling with finding an answer to a simple question
Replies
5
Views
132
BJZeak
BJZeak
TinaS
  • Locked
  • Question
Quick one I think - question about Properties window in Form Design view
Replies
1
Views
63
dhookom
dhookom
JanaLNelson
  • Locked
  • Question
Filter as you type combo box in Access 2
2 3
Replies
54
Views
461
JanaLNelson
JanaLNelson
TheresAlwaysAWay
  • Locked
  • Question
"There isn't enough memory to perform this operation..." error after upgrading from Access
Replies
2
Views
87
Axworthy
Axworthy

Part and Inventory Search

Sponsor

Back
Top