Define an export

[James_bk]

I’m trying to get my database of 100,000 records to export 3000 unique records at a time as fast as possible. I need the database to do this 8 times in a row.

What I have been doing up to this point is sorting the records by

item name ascending export , and then descending export

weight ascending export , and then descending export

color ascending export , and then descending export

size ascending export , and then descending export

This gives me eight mostly different sets of records but sometimes the size and weight are both low I get duplicates.

I cant think of another way of doing this? Please help!!

[Ender]

What are you trying to get, each unique combination of weight, size, and color?

You can do this with a calc that concatonates all three, sort by that, then in the export dialog, use the Group by option to group by the calc, and add the fields you wish to export to the Export order.

[James_bk]

I dont care about how it picks each bundle of 3000 records all I need is that those 3000 are unique from the next 7 exports. Does that make sense?

[Ender]

Sorry, this doesn't make sense to me.

[James_bk]

I just need to have each export as follows:

export 1 3000 unique records

export 2 3000 unique records

export 3 3000 unique records

export 4 3000 unique records

export 5 3000 unique records

export 6 3000 unique records

export 7 3000 unique records

export 8 3000 unique records

So a total of 24000 records are exported into eight files.

I dont care about the order for the export just that each record is exported once from the 100,000 records.

[Ender]

How about something like:

Show All Records

Omit Multiple [ 3000 ]

Show Omitted

Export Records []

Show All Records

Go to Record/Request/Page [ 3001 ]

Omit Multiple [ 3000 ]

Show Omitted

Export Records []

Show All Records

Go to Record/Request/Page [ 6001 ]

Omit Multiple [ 3000 ]

Show Omitted

Export Records []

Show All Records

Go to Record/Request/Page [ 9001 ]

Omit Multiple [ 3000 ]

Show Omitted

Export Records []

Show All Records

Go to Record/Request/Page [ 12001 ]

Omit Multiple [ 3000 ]

Show Omitted

Export Records []

Show All Records

Go to Record/Request/Page [ 15001 ]

Omit Multiple [ 3000 ]

Show Omitted

Export Records []

Show All Records

Go to Record/Request/Page [ 18001 ]

Omit Multiple [ 3000 ]

Show Omitted

Export Records []

Show All Records

Go to Record/Request/Page [ 21001 ]

Omit Multiple [ 3000 ]

Show Omitted

Export Records []

Show All Records

Go to Record/Request/Page [ 24001 ]

Omit Multiple [ 3000 ]

Show Omitted

Export Records []

[James_bk]

Why I didnt see that for all this time I will never know! Thanks a Bunch!!!