select information from a field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have created a table for surgical procedures, the field containes both
left, right, and bilat along with varies procedures (example: right wrist
CTR, left ganglion, bilateral bunions, etc). I am wondering if it is
possible to query for a certain procedure without having to create a diffent
query for each, but by asking for a procedure (CTR, ganglion, etc)
 
Yes, you would use a Like Statement. You could set up your query so
that the user enters a procedure they are looking for. For example,
your statement could look like this:

Like "*" & [Enter Procedure Type] & "*"

When you run the query, a box will pop up labeled Enter Procedure Type
and a box to type in the value. If you enter CTR, you will get all
procedures that have CTR in them.

Hope that helps!
 
Yes you can, try something like

Select * From [surgical procedures Table] Where [procedures Field Name] =
[Please enter a procedure]

When running the query, you'll be prompt with the message "Please enter a
procedure", and the query will be filtered by the value entered

Or, if you want to refer to a field in a form where the procedure will be
entered, you can try

Select * From [surgical procedures Table] Where [procedures Field Name] =
Forms![FormName]![FieldName]
 
Back
Top