Error "Item not found in Collection"
- Thread starter govuser1
- Start date
- Local time
- Yesterday, 21:10
- Joined
- Aug 30, 2003
- Messages
- 36,157
For starters, try changing
SELECT tblCoss.*, tblCoss.Loc, *
to
SELECT tblCoss.*
as the others just confuse the issue and will cause Access to do weird things with field names. I personally would do:
...And tblCoss.Loc <> "SCHED"
SELECT tblCoss.*, tblCoss.Loc, *
to
SELECT tblCoss.*
as the others just confuse the issue and will cause Access to do weird things with field names. I personally would do:
...And tblCoss.Loc <> "SCHED"
