J
Reaction score
4

Profile posts Latest activity Postings About

  • 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
    J
    jepoysaipan
    Hi Jerry,

    Sorry for the super late response after hibernating for a while I am back, I know you've solved this issue and apologies for not replying soon, for what it's worth I will use the left() function:

    me.[ResultTextField].value = left(me.[SourceTextField],4)
    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
  • Loading…
  • Loading…
  • Loading…
Top Bottom