Hide the content of a field

[peter_lawton]

I have to pull information out of an access database to create an excel sheet so another database can absorb it. It's a bit tricky to explain... so I won't unless someone really really wants to know. It's all fine except the information in the first field is repeated in the next row. Nothing wrong with the query but each entry in field one triggers a new record in the target database so I need to avoid showing the contents of the first field in subsequent rows if the same..



Reducing it to a very simple format

Item
With


Tea
Milk
Tea
Sugar
Coffee
Milk
Coffee
Sugar


I need to hide the second instance of Tea and Coffee.

Please note I am outputting a great deal of data in each row and Unique Records/Values will not work in this case. However because it's going into excel and I can use copy and paste, all I need to do is hide/not display the second instance of the word in the first field.

I do hope that's clear…

If you can get your head round the above and tell me how to do it I promise the sun will shine on your next birthday.

[aytee111]

I don't suppose you know any VBA?

[peter_lawton]

Only in the most rudimentary way I'm afraid. I manage most of my issues using SQL. Peter

[aytee111]

query 1 - make table - group on everthing, make sure you include the primary key
add one additional field which will be the first field repeated

query 2 - append query - use the wizard to create an unmatched query, these will be records on the original table which are unmatched on the new table made in query 1 - leave the first field blank but be sure to populate the additional field mentioned above

If I can explain - the first query outputs just one record, which will contain "Tea" in the first field. The second query outputs the rest of the records (hence the unmatched) but this time leaving the first field blank so that it only appears once. The additional rendition of the first field will allow you to sort the records so that all the Teas are together, and you can exclude this field (and primary key?) when you export.

Hope this works!

[peter_lawton]

Just getting to play with it now. Been a long day. Will report back. Thanks Peter

[peter_lawton]

Have tried my best with this but I don't think I get what you mean. Peter

[aytee111]

Query 1 - did you do it? what doesn't work? what is your question?