CarysW
Complete Access Numpty
- Local time
- Today, 16:27
- Joined
- Jun 1, 2009
- Messages
- 213
It's been a good few months that I've been away from the world of Access, and I get rusty quite quickly!!
I can't understand what's wrong with this query though - if I open it via the query, and choose to leave all of the parameters blank, then it works - it returns all possible outcomes. If I input one or more values in the parameter boxes, I get nothing - no error, just no data returned.
If I try to run the query from the form (with code), I get nothing returned whether I choose a parameter or not.
Is it something silly and stupid that I'm missing? Have I done something wrong somewhere? Is it all completely wrong??
I can't understand what's wrong with this query though - if I open it via the query, and choose to leave all of the parameters blank, then it works - it returns all possible outcomes. If I input one or more values in the parameter boxes, I get nothing - no error, just no data returned.
If I try to run the query from the form (with code), I get nothing returned whether I choose a parameter or not.
Is it something silly and stupid that I'm missing? Have I done something wrong somewhere? Is it all completely wrong??