help with logic

[davyre]

Hi, I have a table called tblReport(CustName,Item,Qty) -> just an example
roughly this is the look inside the table

|CustName |Item  |Qty  |
|A        |ab    |1    |
|A        |pq    |1    |
|A        |zz    |2    |
|B        |qwe   |1    |
|B        |zz    |1    |

now I want that table to be exported to an Excel file. This is roughly my code:

dim cust as string
dim item as string
dim qty as long
dim qry as string
dim dbs as database
dim rst as dao.recordset

set dbs=currentdb
qry="SELECT * FROM TblReport"
set rst=dbs.openrecordset(qry)
rst.movefirst

do while rst.EOF=false
  cust=rst("CustName")
  item=rst("Item")
  qty=rst("Qty")

  xlsheet.Range("A1").value=cust
  xlsheet.Range("B1").value=item
  xlsheet.Range("C1").value=qty
  
  rst.movenext
loop

with codes above, the excel file would look exactly like the table. But what I want is to look like this:

|CustName |Item  |Qty  |
|A        |ab    |1    |
|         |pq    |1    | --> CustName is omitted because it is the same customer (A)
|         |zz    |2    | --> CustName is omitted because it is the same customer (A)
|B        |qwe   |1    |
|         |zz    |1    | --> CustName is omitted because it is the same customer (B)

how can I do that? Any help is appreciated. Thankyou

 

[SkipVought]

Dave,

Why would you export such a report, with missing data, that renders your data USELESS for anything in Excel other than simply scrolling thru the data for viewing. You could do that just a easily in Notepad!

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[SkipVought]

BTW, your TABLE data in Excel, can be Conditionally Formatted quite easily to make the data APPEAR as you indicated, but without destroying the usefulness of the data.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[davyre]

Hi Skip,
well this is my boss' request so decision is not mine to make. He prefers excel as he can print out/access it easily with his laptop.
Anw, can you help me with this request? THanks

 

[SkipVought]

Then my BTW would work perfectly

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}