-
Data structure is not normalized and causes difficulty.
Access throws in a lot of unnecessary parens and that can make it hard to read. Use of .Value is not needed. Simplified via SQLView window:
SELECT * FROM Concerts WHERE ConcertDate BETWEEN [start date] AND [end date] AND ([B2] LIKE "*" & [Singer name] & "*" OR [B/B1] LIKE [Singer name] OR etc);
Really should not use punctuation/special characters in object naming.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|