paul.raeburn
PR
- Local time
- Today, 11:18
- Joined
- Apr 29, 2001
- Messages
- 47
I am trying to update a table after a form is printed for members of a club.
The Table I am trying to update has two fields, 1 is membership card printed, and is a yes/no field. The other is membership card printed date, which is a date field.
I have a criteria that I have set to stOption.
Below is the two updates, firstly number 1 works, but the second does not can you tell me which one (2a or 2b) or is both wrong
1. sSql = "UPDATE Member_Detail SET membership_card_print = -1 WHERE
membership_card_print = 0 AND " & stOption
2a. sdSql = "UPDATE Member_Detail" & " SET membership_card_date = " &
Format$(Date, "\#dd/mm/yyyy\#")
2b sdSql = "UPDATE Member_Detail Set membership_card_date = " &
Format$(Date, "\#dd/mm/yyyy\#") & " WHERE membership_card_date = Is Null AND
" & stOption
Many Thanks
Paul

The Table I am trying to update has two fields, 1 is membership card printed, and is a yes/no field. The other is membership card printed date, which is a date field.
I have a criteria that I have set to stOption.
Below is the two updates, firstly number 1 works, but the second does not can you tell me which one (2a or 2b) or is both wrong
1. sSql = "UPDATE Member_Detail SET membership_card_print = -1 WHERE
membership_card_print = 0 AND " & stOption
2a. sdSql = "UPDATE Member_Detail" & " SET membership_card_date = " &
Format$(Date, "\#dd/mm/yyyy\#")
2b sdSql = "UPDATE Member_Detail Set membership_card_date = " &
Format$(Date, "\#dd/mm/yyyy\#") & " WHERE membership_card_date = Is Null AND
" & stOption
Many Thanks
Paul


