var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Search whole field query multiple tables / fields
Hello folks - im using MS Access 2003
I am trying to create a search function that will query multiple tables / fields, I have got a simple search running that searches anywhere in a single field using LIKE etc (as below).
WHERE (((Tbl_Pymt_Breakdown.Pymt_Name) Like "*" & [name] & "*"));
Does anyone have any examples I could review please ?
Thanks in advance
to query multiple fields:
to query multiple tables, it depends on whether they are related
where Pymt_Name like "*" & [name] & "*"
or second_field like "*" & [name] & "*"
or third_field like "*" & [name] & "*"