Update Query with Parameter
On Thu, 27 May 2010 18:45:01 -0700, sg wrote:
I have an Update Query that asks for 3 fields with parameters. The first
parameter [ID] is the criteria in the query to identify which record we are
updating. The second and third parameters (city and state) are sending the
new information to the table. However, sometimes I only have a city that
needs to be updated where the state needs to stay the same as what is already
in the table. If I don't fill in the 3rd parameter, the state is deleted
from the table. How do I get around this without having to type the state in
when the parameter prompts me?
Thanks in advance.
Update the State to
NZ([Enter state:], [STATE])
to update the field to itself if the prompt is blank.
--
John W. Vinson [MVP]
|