How to Format the exported Data 1

[khwaja]

I am exporting data from a query in Access which I need to upload to another system. Data extract looks like this:

9006 RECIPE BASES 1 9Y
9006 RECIPE BASES 2 9K 9K
9006 RECIPE BASES 3 9K 9K 9K
9006 RECIPE BASES 4 9K 9K 9K 9K

Unfortunately the system this data is uploaded to does not work with duplications in column one and two. Previously, we were maintaining the data in Excel so, we could produce in the required format but not in Access. Is there some way I can remove duplicate enries as part of data export process in Access? So that my data looks like this:

9006 RECIPE BASES 1 9Y
2 9K 9K
3 9K 9K 9K
4 9K 9K 9K 9K
[A blank line before next category starts]





Cheers

AK

Note: Using Access 97 for back end A2002 for front end.

 

[ycim]

Try exporting your data from a query. Set unique values = yes on the properties menu for your query.

 

[johncasimir]

Try this:
1. Build a simple Tabular report (you can use the wizard)
2. In the design mode, select the fields you wish to hide the duplicates on.
3. Set their Format property 'Hide Duplicates' to YES.
4. Export the report to excel, or whatever.

JC
Consider this: Maybe we live to 120; a split moment compared to eternity.
What we do with The Free Gift Offered by Jesus, determines where we spend it.

 

[khwaja]

Thanks a lot John. I somehow missed your response and discovered only today that a neat solution was waiting for me. I appreciate your help and aplogise for belated appreciation.



Cheers

AK

Note: Using Access 97 for back end A2002 for front end.