jepoysaipan

Hi Jep,

I'm having a problem on string field, the value is "7081 - Paul Rooney" how can I get the 4 numbers on the string. Say I want to display the "7081" on a text field. I have an idea in my mind and when I applied it, it didn't work. Please help.

Thanks a lot my friend,

Regards,
Jerry


Please if you an idea i will really appreciate it.
Thanks in advance.

Regards,
Jerry

jepoy need your help,

I'm doing a report using between dates and using a Combo box to get a certain data for a particular customer from table. 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 from the table. I created the following SQL code but after I run the form, it gave 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