Search results

Hi, How do I calculate the sum of certain fields in a row on the form Sudha

Thank you it worked! Sudha

I have two subforms(not nested) on a main form. Both the subforms have a total field(=sum[(fieldname)]). Now I want the sum of these two totals on my main form. Please help. Sudha

Hi, I have a table with details of week no and the hours worked during that week. On a form I have two combo Boxes that are used to select the "Start Week" and "End Week".Suppose the user selects 46 and 52 then I want the all the weeks from 46 to 52 to be displayed as headings, and the hours...

Hi, I have a table with details of week no and the hours worked during that week. On a form I have two combo Boxes that are used to select the "Start Week" and "End Week".Suppose the user selects 46 and 52 then I want the all the weeks from 46 to 52 to be displayed as headings, and the hours...

I am sorry, it is not the total column, but the total row(where group by condition is given or press View and select total). My form is not displaying any data as the is no value in the combo box to choose from. If I give any value by typing it,then also no data is displayed.

I think I have put my problem wrongly. let me give you some more details. I have a query based on two tables joined by 'Staff No'. The fileds in my query are 'Discipline', 'Category', 'Week No', Hour',Rate'. I have used the group by option. I have created a form for this query and in the form I...

No, I have a combo box using which I want to select a value and then that value shoud be the criteria(the parameter box option) for the query and then display the result in the same form(as this form is for this query

I have created a form for a query. Now I want the input from the form to be the parameter criteria for the query and then display the result in the same form.