Search results

Check table data types First check your table and data type (data type should be set as number, otherwise you can get results similar to yours. Second, in your query, put in your criteria field this: between 0 and 5 or use >0 and <5 -both work well.

I am trying to find the way to extend the maximal number of columns in acces tables. As far as I know the maximum is 250 or so. I need to have about 300 fields on the same form. If I put a subform, then I can not easily navigate through records - I can not navigate through records on a subform...