Cstr format

  • Thread starter Thread starter gator
  • Start date Start date
G

gator

I tried to run a query with a where clause that would filter using two
criteria. When I run the query, only one of the parameters are met when I
know both parameters are in the records. I opened the table and did a
"filter by selection" for both parameters. One resulted with the criteria
field displaying the number, as was expected. The other resulted with the
criteria field displaying the number in parentethes with Cstr$ in front of
the parentethese. I don't know why two differernt records of the same field
are a little different. How can I format the entire field with the same
format so my query will display all results?
 
I went to the table and changed the format to text and ran it then changed
the format back to number and ran it and that seems to have fixed it.
 
Back
Top