Search results

  1. E

    Grouping on report

    I have a report that has PO #s and there may be several lines for one PO#. I want only the top line to show the PO# and the ascending lines just to show the other data without the PO# and all be grouped together. Pease help.
  2. E

    Limit digits in text field on form

    I have a form that has a field to look up po numbers that are 10 digits long. I need to be able to put in the last 3 or 4 numbers, hit the home key and fill in with zeros. EX 0000000498. This is a text field and must stay a text field because of compatibility issues downloading new...
  3. E

    Look up records in a form

    I need a control that will look up an invoice record when the invoice number is keyed into the field. The form's record source is a table that has invoice #, amt, date, etc. When I put the invoice number into this field, I want the entire record to display. Can I do that?
  4. E

    Query to compare table differences

    I need to run a query to compare any and all differences between two tables. This includes a row that has been deleted or added or any field that has been changed. I've tried to use the unmatched query wizard, but no differences are coming up. What criteria do I use for this?
Back
Top Bottom