Recent content by ekses90

  1. E

    Appending Records with a desired auto number in a table with Auto Number

    hi..can you explained more how to append query and temp table?.i,m having the same problem and i dont know how do it.
  2. E

    how to display increament number in report

    my report display data from a table. i want to display column NUMBER at the left side of my report. how to do that?:confused:
  3. E

    search using wildcard

    i want to search something like yy in this xxxx/yy/xxxx. so i imagine the sql using wildcard is like below. SELECT * FROM place WHERE id LIKE '_ _ _ _ _ y y _ _ _ _ _'; but i want to make "y y" is a keyword that i key in. can anyone tell me how to do that?
  4. E

    problem searching name using sql

    thank you so much..i try it and it work. i'm a beginner.thank you for your help.
  5. E

    problem searching name using sql

    i want to search name that have keyword from another form. for example if i key in "nad", it will display all name that have "nad" in their name. i try this but it will display name with exactly "nad". SELECT * FROM supplier WHERE (((supplier.company_nm) Like Forms![search]!company_nm)); can...
See more
Back
Top Bottom