It occured in a table.
first record = 11 - down arrow
secondrecord = 12 - down arrow
third record = empty - Access filled this field with 13
After this I can push the down arrow and Access fills every field with the last number +1
I would like to have
11
12
empty
empty
But if I push...
Does someone know how I can change the sorting order in Access. It now sort - first and then +. In Access 97 this was + first and - after this. I build my query's this way and it would take me weeks to edit all my query's. If this works.
I asked this question before, but had no answer which...
Sorting descending won't work because in the query there also are some value's 01 and 02 and they should be sorted ascending.
The complete query is used to build loop diagrams and the +,-,01,02,...... are terminal rows used in the loop drawing. In a query there are about 600 records and I really...
This could be a theory. But I really need a solution to solve this problem, without rebuilding my complete database and I have no idee how to do this.
Thanks anyway
Does someone know why access 97 sorts + first and then -
and Access 2000 sorts - first and then plus and how I can get access 2000 to sort + and - like access 97
I''ve tested this with a simple table with 1 field:
+
-
+
-
a query sorting this field ascending gives:
Access 97:
+
+
-
-
Access...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.