Search results

I trying to order a report using a calculated field but seem to get nowhere. The calculated field is not a database column. Here is an example of the report. Field 1 Field 2 Sum of F1&F2 5 .......... 7 ........... 12 14 ......... 8 .......... 22 7 ......... 9 ...

Help. I am trying to sum two controls on a form. The two controls are a column in a table as is the sum column. All three are on a form but I cannot get the sum figure to be calculated in the third control when the control get focus.:banghead:

Hi, can anyone out there tell me if it is possible to calculate a value in a column in a datasheet view of a query. i.e. I want to take a value in 'Column A' and subtract the value in 'Column B' to create a value in 'Column C'? If it is possible. How?

I have added a totals line to a datasheet. One column had numerical values for which I wish to calculate an average. No problem with this but the average comes out something like 13.85746354657. How can I limit the number of decimals places to two?

I have a form and wish to automatically update one control after updating another. i.e. I enter data in control 'A' (which saves date in Table x) and want another control (Control B) to look at that data, convert the value by looking at a look up table and then inserting the new data into...