G
Guest
Halp! 
I have a very simple query from an ODBC connection which is refreshed
everytime we open the s/s.
It's 3 columns.
Invoice # = Column A
Close Date = Column B
Status (Open or Closed) = Column C
It's sorted, in the query, by inv # (column A)
We add 2 more columns of info. (I have another question abou that!...but
back to this problem...)
Sometimes the inv #'s SHIFT UP, as if for some reason, thery have been
deleted in the original database...they shouldn't be, but regardless, how do
I ONLY APPEND New records?
The invoices are created in numerical order, so they should be appended in
order (I hope)
Anyway, I have query properties set to "Insert entire rows for new data,
clear unused cells."
Is this correct?
If not, halp!!!
Thank you very much.!!
I have a very simple query from an ODBC connection which is refreshed
everytime we open the s/s.
It's 3 columns.
Invoice # = Column A
Close Date = Column B
Status (Open or Closed) = Column C
It's sorted, in the query, by inv # (column A)
We add 2 more columns of info. (I have another question abou that!...but
back to this problem...)
Sometimes the inv #'s SHIFT UP, as if for some reason, thery have been
deleted in the original database...they shouldn't be, but regardless, how do
I ONLY APPEND New records?
The invoices are created in numerical order, so they should be appended in
order (I hope)
Anyway, I have query properties set to "Insert entire rows for new data,
clear unused cells."
Is this correct?
If not, halp!!!
Thank you very much.!!