Add 1 Critera to Report!

B

Bob Vance

I want to add 1 Critera to this report Code " tblInvoice.ClientInvoice =
True"
Is this possible...........Thanks Bob
ElseIf CurrentProject.AllForms("frmInvoiceClient").IsLoaded = True Then

Report.RecordSource = "SELECT tblInvoice.InvoiceID AS InvoiceID ," _
& " qryOwnerInfoAll.* FROM tblInvoice," _
& " qryOwnerInfoAll where qryOwnerInfoAll.OwnerID=tblInvoice.OwnerID And
" _
& " tblInvoice.OwnerID=" & Forms!frmInvoiceClient![cbOwnerName]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need to add 1 Field to query! 5
Add 1 field to query 1
Union Query Help 5
Error when trying to create my Report 2
Format a text box! 2
Form Load problem 2
Enter Date on Emailing 6
Emailing Question from my DB 2

Top