Hi,
I Have a query that uses a function for setting the Criteria.
When I view the return value of the finction it appears to be exactly what I
want for my criteria. The problem is if I type the criteia directly in the
query all's well however if I set it to the return value of the function I
get no records returned. Here's the function I'm using. Any help is appreciated. Thanks!
Option Explicit...
User Profile
Collapse
-
Pass Parameter to Query using Function
-
chinkyk started a topic Want to use the selected items from list box in a Attached query of a reportin AccessWant to use the selected items from list box in a Attached query of a report
I have a form that has a list box(multiple values selected) and multiple report names(when clicked on the button, it will run the report) on the form. I have selected multiple items from the list box. Now I want to use the listbox selected items, in the reports query. All the reports have a query attached to it. So I want to use the selected items from the list box in the query, in the In clause of the query. Please help.
No activity results to display
Show More