Search results for query: *

Can I set a command button that will populate a query parameter value box? And How??? Thanks in advance

what I meant was that when you select a button, the afterupdate procedure runs, the text box is populated. When you close the form, then reopen to that record, the text box is still populated (good), but the option button is blank

bob stubbs.. It works beautifully, but with one exception. When you reopen that form, those options buttons have no dots.

on an option radio button, that is part of an option group, is there a way to set the value to any text that you wish, so that that value can be stored in the table. It seems to not let you select anything but numeric values. Thanks in advance.

can't just put in formula. "inlet" and "outlet" are names I have given to the same group to get the order that I wanted the group sorted into. How would you take that same group and instead of summing, subtract?

Creating a report with values grouped by a field. The group is then summarized. There are only 2 values that will be grouped... What I want to do is instead of a grand total showing in the report footer, I want the difference between the 2 groups to show. Example Inlet total 500 outlet...

want to take a report, make it look like an excel table like this... Jan. Feb. March. meter1 34 35 54 meter2 44 66 77 meter3 55 7 55 and so on... now, the meter field must be grouped, I can also group by date.. A cross tab will display this...

trying to extract data from a spreadsheet based on a field. I want to have the output of a filter go to a different file. I want to write this in VBA. Help??? can this be done.. I can't record the macro, too many records.

don't want to group by any field.. just want this.. eval1 eval2 eval3 average 2 2 2 3 3 4 3 4 all I want to do is display the average for those 3 fields.

Don't know if that will work because when I try it I get the same error everytime I try "avg".. the error reads as "you have tried to execute a query that does not include the specified expression 'instrutorlname' as part of an aggregate funciton"... the field 'inst..&quot...

I have three fields in a query and I want to add those three fields and create a column with the average of those totals. Some of the records will be null. What do I do? Simply creating an expression, "avg([field1]+[field2])" doesn't seem to work.. Please advise

I want to know if there is a way to supress a control box if there is no value for one record. I know how to make a blank appear with an IIF statement, but this is not what I need. I need to eliminate the blank space. Thanks in advance.

That will not give me a grand total for that field from that query. At least not when placed in the form footer section. All it does is sum up the subtotals on the report. As I stated I am using parameters to limit the data on the report. But in the grand total section I wish to total all...

How do I place a field on a report that will place a grand total for ALL the records in one field on the query? I have several grouping levels already and I open the report with parameters in my query criteria. Thank you for any help...