Recent content by bb3261

Thanks for the response. I understand what you're saying, but I wouldn't trust the user to be able to type in the sort field. I have a form where they select the field on which to sort in a combo box, and then I want to open the report sorted by that field. Could I use your technique and have...

Thanks for trying to help, Shep. I'm sorry it was a little confusing. Here's the situation, hopefully explained more clearly: I have a form which IS bound to a particular table, so some of the controls on the form are tied to that table. However, there are also other controls on the form...

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 actually figured this one out on my own. If you do an outer join to a table that has Yes/No fields, and you wish to group by those fields, the NULLS that result from the other table not having matches on that field cause a problem, because Access is only expecting the value of those fields to...

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...