View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
DM Unseen DM Unseen is offline
external usenet poster
 
Posts: 233
Default Excel and SQL help

Short answer: don't do this, it doesn't even make sense from a Data
model perspective.

Long answer:

incorporating client side data that should be persistent with a report
on is not the way to do Information handling.

That said you can do the following to work around that:

1. Decide on which identifier field the comment is based, a customer
number, order number,invoice number?

2 on a new sheet make a table of 2 columns, column 1 contains the
field, and column 2 contains the comment/data.

3. besides your SQL report, fill down a lookup formula that looks up
the comment given the field value.

4. Select Data Range properties and tick "fill formulas adjectant to
cells"


Don't use Excel "Comments" because they are position oriented, while
the SQL query is data oriented.

DM Unseen