msquery

[patti]

a simple stupid question....

does msquery add the data to what is already there or does it replce the
data? (query is linked to access db)

any links to explanations and examples of msquery appreciated.

thAnk you!

patti

 

[FSt1]

hi,
it is to my understanding that you can do it either way.
right click the MSQ, then click data range properties.
at the bottom you can opt to insert rows for new data or overwrite existing
data. not sure which is best. i always overwrite.
links....
http://office.microsoft.com/en-us/excel/HP052747511033.aspx
http://office.microsoft.com/en-us/excel/HA100996641033.aspx?pid=CH100648471033

regards
FSt1

 

[FSt1]

hi.
since you asked, i went looking. found another.
http://support.microsoft.com/kb/136699
about joins.
regards
FSt1

 

[patti]

thanks for the speedy reply. i've never used msquery but have been given a
spreadsheet to work over.

how do i right-click on the msq?

as for adding the data, i mean adding the retrieved cell contents to current
cell contents. If A1 was 4 and the incoming A1 was 10, i'd want A1 to result
in 14.

i mainly use access so i understand queries pretty well - just don't get
what's happening w/ data in excel.

patti

 

[FSt1]

hi.
You will find that MSQ work pretty much like access once you get into the
MSQ wizzard and the MSQ dialog. you add query criteria the same way.
but as to right clicking. somewhere inside the MSQ data, right click. if
the MSQ returns data that is 10 columns wide and 500 rows long. right click
on D5. think of it as a table.
MSQ don't work that way. it retrieves data that is in your access
database. that's it.
but unlike access, you can do some math by putting formulas along side the
MSQ and i have had them about 4 columns. In access, you do the math in the
header. you can also have formula at the bottom for totals or whatever but
you cannot add columns and put formula in the middle of the MSQ. The MSQ is
like a named range or table and all cells(columns and rows) the MSQ returns
is reserved for the MSQ. when your right click the MSQ, at the bottom check
"fill down formulas in columns adjacent to data". MSQ will add formulas for
new data (and remove if the data shrinks which it seldom does).

good luck. it's fun.
regards
FSt1