Search results

I have a plethora of unbound controls on my form which I use to input data into a separate reporting table that's not bound to this form. The problem is that I need a way to trigger an event every time the record is changed on the form so I can save the data in the reporting table. The old...

I need to sort a report based on a field the user inputs and I can't seem to find an easy way to do it. I tried making the ORDER BY clause of the query a parameter but Access didn't like that. I tried building the entire query in code and then basing the report on a form field which contained...

I have the following query: SELECT plo_categories.description, plo_categories.category_id, plo_items.item_id, plo_items.description, plo_data.value, Count(plo_data.item_id) AS MyCount FROM plo_categories INNER JOIN (plo_items INNER JOIN plo_data ON plo_items.item_id=plo_data.item_id) ON...

I'm trying to use a user-defined function with the fields portion of a SELECT query, for example: SELECT MyFunction([client_value]) AS new_client_value FROM client_info; The function is defined as follows: Public Function MyFunction(client_id) If (client_id = 1) Then MyFunction = 50 ElseIf...