View Single Post
  #1  
Old December 7th, 2009, 07:25 PM posted to microsoft.public.access.queries
Wayne[_13_]
external usenet poster
 
Posts: 19
Default Change Form/Report Query Based on User Selection

I have a form and report based on a query. I need to change the query
based on what the user selects on a form. Using VBA in MS Access
2002, can I change a single field in an existing query from GROUP BY
to LAST? This process would be initiated by a click event on a form.
Thanks in advance for any help.