"Dmorri254" wrote in message
...
Hi,

Whenever I update my query to bring in new data, the defined range will
not
expand to include the new data. How do I correct this si that when the new
data is returned, the defined range expands to include the new data.

Thanx

An alterantive approach is to use the combination of VBA and ADO to get data
from your datbase into Excel. With this approach, you don't have to worry
about range problems. Here's a link
http://www.exceltip.com/st/Import_data_from_Access_to_Excel_(ADO)_using_VBA_i n_Microsoft_Excel/427.html

/Fredrik