Using Wildcards code queries to retrive data

[lewismwangi]

How can you use wildcards code queries to retrive
-three different records from each table using
a.One character as criteria e.g LIKE"
[*]*"
b.Range of letters e.g LIKE"[a,z]*"
c.Range of letters e.g LIKE"[a-e]*"
And how to copy these queries to word.

 

[rexmorgan]

Could you give a better example of specifically what you want to have happen? What I mean is describe the table somewhat.

If you use the OR function you could conceivably use something like

SELECT *
From tblSomeTable
WHERE tblSomeTable.SomeField = "abc*" OR tblSomeTable.SomeOtherField = "a*" OR tblSomeTable.AlsoAnotherField = "def*"

Hope this helps.