ACCESS QUERY QUESTION

[Awarmplace1]

How do i use the asterick in a query that is referencing a form in the criteria...I am trying to get the query to find and part of the information that i put into the form.....help!!!!!!

 

[Sypher2]

You would use the LIKE operator and put an asterisk on each end of the arguement in the query criteria. If you're using the design view, turn on Totals and set the Total row to "Where" (The Show checkmark will turn off.) In the criteria row type:

LIKE * & (form reference here) & *

Access will put in the quotes where needed for you. Since this is a non-show field, you'll need to drag over the same field to another spot. Just delete out the "Group By" that it automatically sets the Totals to. Hope this helps.

 

[Nordyck]

I'm not sure what you are trying to say here.
As an example
st = "Select * from tableA " & _
where TableA.name='" & [forms]![formname].[name] & "'"

This will pick the field from the form and place it into
the crieria clause.

To use it in a criteria try this
st = "Select * from tableA " & _
where tableA.name like '" & [forms]![formname].[name] & "*'"

Good Luck
Nordyck