Search results

Hi All; I am using the expression below to convert from decimal to time. The problem I am having, is that when the result includes a leading zero (13:04), it doesn't display the zero (13:4). Any ideas on how to fix this? Thanks- Pete Int([AGACD]/60) & ":" & ([AGACD]-(60*Int([AGACD]/60)))

I'm an Access beginner/intermediate level user and I'm trying to merge data from a performance table (3 of calls per day) and a cash collected table (cash per day) I've tried several different combinations within the query but am unable to get the result to show zero cash on a day calls were...