G
Gina Whipp
Craig,
Nope, never thought you were *snarky*, just confused... hence the asking for
the SQL. We are happy to hear the matter has been resolved. However, if
you still need help with your UPDATE query because, as by this posting, it
is not working as desired... posting it here might help yget you your
desired results!
--
Gina Whipp
2010 Microsoft MVP (Access)
"I feel I have been denied critical, need to know, information!" - Tremors
II
http://www.regina-whipp.com/index_files/TipList.htm
Bob/Gina:
My apologies...here I am coming off 'snarky' to people who are helping
me...inexcusable.
You are correct. My code was referencing a select query. This option
doesn't exist in an update query...only in a select query, in either 2003 or
2007. By choosing "inconsistent updates" you can update data in a select
query that has both a table and a query. If that query, however, is a group
by query, then you can't.
Thanks again.
Nope, never thought you were *snarky*, just confused... hence the asking for
the SQL. We are happy to hear the matter has been resolved. However, if
you still need help with your UPDATE query because, as by this posting, it
is not working as desired... posting it here might help yget you your
desired results!
--
Gina Whipp
2010 Microsoft MVP (Access)
"I feel I have been denied critical, need to know, information!" - Tremors
II
http://www.regina-whipp.com/index_files/TipList.htm
Bob/Gina:
My apologies...here I am coming off 'snarky' to people who are helping
me...inexcusable.
You are correct. My code was referencing a select query. This option
doesn't exist in an update query...only in a select query, in either 2003 or
2007. By choosing "inconsistent updates" you can update data in a select
query that has both a table and a query. If that query, however, is a group
by query, then you can't.
Thanks again.