Query Help

[mike760534211]

I have DB were the tables are all stored on a sharepoint site. I am using a form that uses =CurrentWebUser(1) in a field for the default value. When I look at the records in the form view they reflect who created the record correctly. So I believe this field is updating correctly.

In the query I created for a report I am using Between [Start Date:] And [End Date:] as a criteria to prompt the user to input the start and end dates for the report. But I would also like to be able to prompt the user for [Created By] and they input their name and it return the results of the date filter and the user that created the record.

[ItsMe]

Why use a parameterized query to get information that you already have with CurrentWebUser()? I have never used CurrentWebUser() so if it is not providing you with the correct info I suggest having some sort of user authentication implemented at login. Use the authenticated ID value