How to arrange order of records

[Welshgasman]

Well I would say you should use another field that defines the sort order?

So if you want Session fee first, then you assign that field the value 1, for Mining Fee which you want next, make that 2 etc?

[neilsolaris]

Well I would say you should use another field that defines the sort order?

So if you want Session fee first, then you assign that field the value 1, for Mining Fee which you want next, make that 2 etc?

I see, that make sense. I'll give it a go now and let you know how I get on.

[neilsolaris]

It worked perfectly. Thanks a lot for your help.

[moke123]

I have a lot of sensitive information on my database, so it'll take me a while to edit it before I can take any screen captures.

Heres a utility to randomize data in a COPY of your database. Just import the one form into a COPY of your database.
Select the tables and fields containing sensitive data and click randomize.
Just to be sure you dont miss my warning, do this on a COPY of your database!

Here's what original data looks like and the randomized data preserving the first 3 letters.

[neilsolaris]

Heres a utility to randomize data in a COPY of your database. Just import the one form into a COPY of your database.
Select the tables and fields containing sensitive data and click randomize.
Just to be sure you dont miss my warning, do this on a COPY of your database!

Here's what original data looks like and the randomized data preserving the first 3 letters.

Thanks, that'll be helpful for next time.

[moke123]

It's been 4 years but a flaw in my code was just discovered in that users who have spaces in table and field names get errors.
Deservedly so as you shouldn't have spaces in object names.

the error is in this line

strSql = "select " & fld & " from " & tbl & " where " & fld & " is not null"

In the attached copy it has been updated to

strSql = "select [" & fld & "] from [" & tbl & "] where [" & fld & "] is not null"

here's an updated version

DataRandomizer2025.accdb