M
Michelle
Hello all.
I'm pretty new with Access and have a question about query criteria...
I have a workbook, "XYZ", and on the first worksheet that has a column
called "cusip." I also have a table, "ABC", in Access that has a column with
"cusip." I want to be able to run a query that would return only the rows
(of specified, static, columns) in ABC that have the cusips listed in XYZ.
I'm then going to want to put the output in the second worksheet in XYZ. I
will need to run this query daily so it would be nice if I can manage to
automate this process since the list of cusips is around 300 in XYZ. I would
want to overwrite the old data with the new data on the second sheet once the
query runs. I can always just hand copy/ paste the results into Excel once
the query runs in Access. My real problem is I have no idea how to get that
list of cusips into the query criteria. I should also mention that the list
starts in row 3 in XYZ, don't know if that matters.
I'm pretty familiar with VBA in Excel, but not in Access nor am I familiar
with SQL. (If the answer requires SQL you might need to explain fairly
thoroughly for me to understand.) If anything I've written is unclear please
ask, and I will try to clarify. Any help would be greatly appreciated. I
feel like this is a tall order. Thanks!
I'm pretty new with Access and have a question about query criteria...
I have a workbook, "XYZ", and on the first worksheet that has a column
called "cusip." I also have a table, "ABC", in Access that has a column with
"cusip." I want to be able to run a query that would return only the rows
(of specified, static, columns) in ABC that have the cusips listed in XYZ.
I'm then going to want to put the output in the second worksheet in XYZ. I
will need to run this query daily so it would be nice if I can manage to
automate this process since the list of cusips is around 300 in XYZ. I would
want to overwrite the old data with the new data on the second sheet once the
query runs. I can always just hand copy/ paste the results into Excel once
the query runs in Access. My real problem is I have no idea how to get that
list of cusips into the query criteria. I should also mention that the list
starts in row 3 in XYZ, don't know if that matters.
I'm pretty familiar with VBA in Excel, but not in Access nor am I familiar
with SQL. (If the answer requires SQL you might need to explain fairly
thoroughly for me to understand.) If anything I've written is unclear please
ask, and I will try to clarify. Any help would be greatly appreciated. I
feel like this is a tall order. Thanks!