Search results

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:

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?

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...