I am trying to learn Access and am getting stuck on something which is probably quite basic.
I have looked here to find a guide on how to calculate a total time based on a start and an end time. I follow the guide and end up with something that doesnt work. Can anyone take a look at my simple database and explain what im doing wrong?
I have made a query which returns me a number of minutes. I would then like to use this in a text box but just get #Name?
(After that I will need to do this bit =[Minutes] \ 60 & Format([Minutes] Mod 60, "\:00") but ill worry about that when I get the first part working!)
Thanks for your help,
Dan