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)))

Thanks, SOS, I made the change and also removed the space on "Cash Date", it still didn't work...

Thanks for the reply rookie, I got the same result, though. All it populates with is "#Error" :confused:

The Table fields are: Tbl MonthlyCash - Cash Date, Agent Name, Amt Coll, Supervisor Tbl PerfRPT - Date, Agent Name, Team, Group, cash, ACD Calls, Staffed Hours I have them joined by "Agent Name" and then was trying the following IIf statement, but am getting "#Error" as a result: Cash...

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...