Update query exception based on parameter

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • FlyersJoe

    #1

    Update query exception based on parameter

    SQL View:

    UPDATE AttendanceDataB ase SET AttendanceDataB ase.[1] = [Enter Day Code]
    WHERE (((AttendanceDa taBase.[1])<>"D") AND
    ((AttendanceDat aBase.Site)=[forms]![f1_Calendar-site].[txtSite]) AND
    ((AttendanceDat aBase.Month)=[forms]![f1_Calendar-site].[txtMonth]));

    Trying to run an update query that will skip over records with a value
    of "D" if...."the Entered Parameter Value = X"

    I am a novice at SQL. I mainly use Access's query design, but will try
    any suggestions.

Working...