Hi,

Does anyone know anything about Access 97?

I'm using an Access report as part of a small front end application.

Now, on my report there is a text box for total mileage.

I want this control to show the sum of 8 fields in each record for every record with a date preceeding the one the report is currently displaying.

On my VB form I have managed to do this by placing a data control (dtaTotMil) on the form and giving it a recordsource of:

dtaTotMil.RecordSource = "SELECT Sum(Up428 + Up435 + Up445 + Up453 + Ov417 + Ov420 + Ov425 + Ov436) AS [TotMil] FROM tblMain WHERE [WeekEndingSun] <= #" & frmFind.datSelDate & "#;"

Bit of a mouthfull I know but it does the job.

Does anyone know how to do this in Access.

I don't care how I have to go about it as long as I can get the correct information into my text box.

This is the very last thing I have to do before I can deploy my application so any suggestions would be much appreciated.

Best Regards,

Rob Brown.