Recent content by JohnWard1947

I am using merge in Word to import a calculation from an Access query. The query calculation displays to 2 decimal points by setting format and decimal places - no problem here. In the Word merge field, the calculation is displayed to about 15 decimal places. I only want two decimal places. Any...

I'm using Access 2003. When I open the relationship window, one table linked to my main data table appears six times - the name is the same but with the addition of a number 1 -5. I can delete the five spare ones and drag a relationship to the main table but it keeps dissapearing.When I try to...

Field calcs Ha! - me frightened?

Field Calcs I think you've convinced me! I'll stick to Excel for this one. John

Thanks for that. Yes, this was originally an Excel spreadsheet report that was starting to grow in width with many columns. I just thought that the info could be more easily entered using a form and presented using an Access report format. Perhaps I should remain with Excel and be a bit more...

I am recording data (Totals) on a monthly basis using one row per month. I would like to be able to subtract the results of the previous month's field from the latest to give the difference. ie This month's recorded total hours run is 1566 - last month's recorded hours run is 720 - difference is...