Search results

To all who responded to my Post. Thank you so much, this site is so useful and the responders so helpful. Thank you again.

I might be able to if I knew how! Can you explain how to include a calculating field in a query?

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

Thanks to all who have responded to this thread. Problem solved

Thank you, you were right. The two numbers in Field 1& 2 now Sum correctly in the sum column. However another problem has arisen. The form is a continuous form and when opened selects x number of records from two tables which are linked by a unique identifier. Thus for each record there is a...

Do you mean control source? I have tried that on Control source and the total control just puts the two numbers together, i.e if the value for Control 1 is 22 and the value for Control 2 is 23 the answer in the control which should sum the two values is 2223. !!

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:

Minty, thanks so much that seems to have provided the answer, instead of :banghead: I am :D regards Clem

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?

Hi again. You are being very patient and thanks for the help so far. Your expression works in that in the datasheet field where there is data it enters a number with two decimal places, fine. But what I want is an average at the bottom of the column which has calculated the average for the whole...

Plog, thanks again but I am still struggling. I open my query in Design View I click on Totals on the Show/Hide box on the ribbon I select Expression from the drop down list in the Group By line in my column I Type in DataAvg: Format("Standard", Avg([KS1 RDG PTS])) I run query The datasheet...

Plog, thanks but I'm afraid I am a bit lost. Where do you put the 'Format Function'? When you select design view for the query which runs to select the data, the totals line is not evident. The Totals line is only evident when the query presents results. You cannot edit the cell where the...

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?

Mr B Hi. My knowledge of VBA is pretty much nil. I have reached a point in the process where I am stuck. Thank for responding. I have a form (Yr3 Update) which draws data by query from two related tables. Some column are blank when the form opens. I have a look up table (Lvls Pts equiv) which...

Mr B, thanks for your help which has given me some direction as you hoped, however I am now struggling with the VBA code. Any guidance/help you can provide would be gratefully received.

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