How to Format text field to a number field

  • Thread starter Thread starter doyle60
  • Start date Start date
D

doyle60

I have a query that subtracts one date from another, returning the
number of days. The field is certainly numeric. But when I bring this
field into another query, Access interprets it as a text field. There
are no possibilities of any of the records being null or having text.

How do I get this query to understand it is numeric?

I believe it is happening because of the right join in the query. But
I am not sure.

Thanks,

Matt
 
Guessing, but it might be converting a date value to text, so convert
it to number, via cInt() or cDbl() before passing it to query.
 
Thanks. I got it to work but I had the wrong problem. I didn't
realize that it was actually the Filter expression that needed shaping
up; a point that could be added to that helpful tip sheet. I believe
there is some sort of statement about doing this on the properties of
the control. But that did not help in my case.

Thanks so much,

Matt
 
Back
Top