Unanswered: Query w/Expression needs to be # field
I have set up a field in a query (ElapsedTime: Format(Int((DateDiff("n",[beg time],[end time]))))that gives me the date/time difference in minutes. The problem I am now having is that I have created another query that takes the ElapsedTime field from the original query and I set the total line option to sum. It give me a warning box thta says "Data type mismatch in criteria expression". I think the field data type needs to be a number field but since I created the field in a query, I do not know how to set it up as a number.
I am trying to equate the difference in the beg time and end time in one field and then I will need to take that data and sum it by the part number. Should I go about this differently or can someone tell me how to set the elapsedtime field to number.