Journey2
  Home FAQ Contact Sign in
 
 Advanced search
MATCHING GROUPS



more...
POPULAR GROUPS

more...
found 4 articles for 0.302 sec
That may be the way to go, but I'm trying to minimise the amount of data input. This is the situation: An engineer leaves home to do a job and records the start mileage. On return home, he can enter the business miles, end mileage or both. He goes out in the evening, using the company car. The following morning, he has a new start mileage, but this doesn't match the end mileage of the previous     

Group: microsoft.public.access · Group Profile · Search for Journey2 in microsoft.public.access
Author: Ian
Date: Nov 6, 2007 09:47

Why not just include both fields in the same record? "Ian" wrote: Is it possible to "link" 2 records in a table, such that a calculation can use information from 2 "consecutive" records? Let me explain. We are working on a database system where engineers will prepare service reports, timesheets, mileage sheets and expense claims within the database. On the mileage
Show full article (2.51Kb) · Show article thread
Ian Storing "calculated values" in a table is rarely necessary, nor a good idea. Use a query to derive the calculated value when needed. On the other hand, if you wish to track both business and private mileage, why not just have the users enter that info? Regards Jeff Boyce Microsoft Office/Access MVP "Ian" <ic2@NOSPAMntlworld.com> wrote in message news:gR_Xi.9389$ib1.4814@newsfe3     

Group: microsoft.public.access · Group Profile · Search for Journey2 in microsoft.public.access
Author: Lance
Date: Nov 6, 2007 09:28

Is it possible to "link" 2 records in a table, such that a calculation can use information from 2 "consecutive" records? Let me explain. We are working on a database system where engineers will prepare service reports, timesheets, mileage sheets and expense claims within the database. On the mileage sheet, it would be very helpful if we could enter only start mileage and business mileage
Show full article (0.93Kb) · Show article thread
    

Group: microsoft.public.access · Group Profile · Search for Journey2 in microsoft.public.access
Author: Jeff Boyce
Date: Nov 6, 2007 09:11

Show full article (1.26Kb) · Show article thread
    

Group: microsoft.public.access · Group Profile · Search for Journey2 in microsoft.public.access
Author: Ian
Date: Nov 6, 2007 06:27

Show full article (0.81Kb)