neileg
AWF VIP
- Local time
- Today, 14:31
- Joined
- Dec 4, 2002
- Messages
- 5,975
I agree with Brian. Are we off at a tangent?
SQL is American. It doesn't like non-US dates. However, Access is usually pretty good at coping with non-US dates since they're all stored as decimal numbers anyway. It actually seems to work better with user input dates rather than hard coded dates and David's tip about using medium format makes it even more reliable.
Looking at the SQL, there are a lot of inner joins in there. You will need to have a record that matches in every single one of those tables to return any data. I suspect that somewhere there's a table, maybe more than one, that lacks a matching record and so you're loosing that row in your results.
SQL is American. It doesn't like non-US dates. However, Access is usually pretty good at coping with non-US dates since they're all stored as decimal numbers anyway. It actually seems to work better with user input dates rather than hard coded dates and David's tip about using medium format makes it even more reliable.
Looking at the SQL, there are a lot of inner joins in there. You will need to have a record that matches in every single one of those tables to return any data. I suspect that somewhere there's a table, maybe more than one, that lacks a matching record and so you're loosing that row in your results.
