Reports that ask???

[greysquirl]

I have a table that I want to run a report off of. The table is called
"Position Change" and the layout is as follows.

Name Department Position DateStarted
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
John Maintenance Mower 5/3/00
Henry MIS Technician 3/15/00
Dave MIS Technician 3/15/01
Larry Admin Teacher 6/15/00
Dave MIS Support 3/15/01
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

What I'm am trying to do here is have a report that when opened/ran it asks you for the employees name to report on.

 

[LonnieJohnson]

Create a query as a recordsource for your report. In the column for Employee Name put the following expression as criteria:

[What is the Employee Name?]

By enclosing this in brackets the user will be prompted to enter data. ljprodev@yahoo.com
Professional Development
MS Access Applications

 

[Smack]

Put the fields you want in a query, then in the criteria under Names type [Enter Name] and buid you report from this query. When you open the report, you will be prompted to enter a name, John, and his info will pull up.
-Smack

 

[greysquirl]

Works great. . . .I have another question if your up for it???

Now that I can type in qn Employee's Name to query for how can I make it look over typo's?

In other words. . .if I typed Dave instead of David I would want it to list all the above. Or if I type in Bob, it should give me all the Bobby's, Bobbie's . . . .etc.

 

[Smack]

I'm interested in that one as well. It seems everyone here enters customer names differently i.e. Apex, Apex Inc., Apex Incorporated etc.
-Smack

 

[LonnieJohnson]

Your expression would be:

Like "*" & [What is the Employee Name?] & "*"

Using the Like operator and the wildcard charactors before and after the prompt. Important that you remember the ampersand inbetween.

Good Luck. ljprodev@yahoo.com
Professional Development
MS Access Applications

 

[THoey]

Good call Lonnie, but remember, if you type in "DAVE", it will not find "DAVID". This code will work, right up until the string does not match. So, if they type "DAV", that will find "DAVID" Terry M. Hoey
th3856@txmail.sbc.com
While I don't mind e-mail messages, please post all questions in these forums for the benefit of all members.

 

[LonnieJohnson]

Terry is correct. This will not return expressions that sound like another expression. Access does not support the SQL funtion SOUNDEX. ljprodev@yahoo.com
Professional Development
MS Access Applications