query report

[jerry28ph]

Hello,

I'm doing a report using between dates and using a Combo box to get a certain data for a particular customer. I created a form with two text fields (start date and end date) and a combo box for my customer field. I want to get the data for a particular customer within a specified dates. I created the following SQL code but after I run the form, it gives me blank report. Please help me if something is missing on my query.


SELECT tab_customer.po_cust, tab_customer.po_date, tab_customer.po_number, tab_customer.po_error, tab_customer.po_note
FROM tab_customer
WHERE (((tab_customer.po_cust) Like forms!frmCboCust!combo4 & "*") AND ((tab_customer.po_date) Between (((tab_customer.po_date) Like forms!frmCboCust!text0 & "*")) And (((tab_customer.po_date) Like forms!frmCboCust!text2 & "*"))));


Thank you and I really appreciate your help.

Regards,

JErry

 

[boblarson]

Here's an alternate way of doing this (see sample):
http://downloads.btabdevelopment.com/Samples/combos/FormSampleFromMultipleCriteria.zip

 

[jerry28ph]

thanks bob, i'l try to revise my coding.
appreciated.

Regards,
jerry