PC Review


Reply
Thread Tools Rate Thread

Add 1 Critera to Report!

 
 
Bob Vance
Guest
Posts: n/a
 
      18th Apr 2009
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]


--
Thanks in advance for any help with this......Bob
MS Access 2007 accdb
Windows XP Home Edition Ver 5.1 Service Pack 3


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Report containing multiple critera/filters Mac Microsoft Access Reports 6 25th Nov 2009 02:35 PM
Report Critera Abdul Shakeel Microsoft Access 3 23rd Nov 2007 12:14 PM
Report critera - Date Range Rockn Microsoft Access Reports 8 26th Jul 2007 09:00 PM
Print report, pass multiple critera Yogi_Bear_79 Microsoft Access VBA Modules 2 11th May 2006 02:54 AM
Print report, pass multiple critera Yogi_Bear_79 Microsoft Access VBA Modules 1 10th May 2006 07:32 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 11:21 PM.