mrrayj60
Registered User.
- Local time
- Today, 13:01
- Joined
- Sep 3, 2009
- Messages
- 103
I dont want my users to accidently change data (name, addr, etc) in this query, only allow them to register a vote yes or no. I cannot find any lock or enable in the query properties. Thanks for your help, Ray
SELECT residents.num, residents.recordid, residents.name, residents.addr201, residents.[55plus yes], residents.[55plus no]
FROM residents
WHERE (((residents.num)>"6" And (residents.num)<"7") AND ((residents.residentstatus) Like '*po*') AND ((residents.Vote)="1"))
ORDER BY residents.num;
SELECT residents.num, residents.recordid, residents.name, residents.addr201, residents.[55plus yes], residents.[55plus no]
FROM residents
WHERE (((residents.num)>"6" And (residents.num)<"7") AND ((residents.residentstatus) Like '*po*') AND ((residents.Vote)="1"))
ORDER BY residents.num;