Scenario: Someone at work has an Access database she fills in daily. We need to design a query that filters on a number field called 'Week_Number' so that records are only shown if they are between 2 weeks that the user is prompted to give.
A query was built which has a WHERE clause that goes...
WHERE ((([blah].Week_Number)>[Week greater than] And ([blah].Week_Number)<[Week less than])
But it doesn't seem to work properly and I don't get why. Eg. If you put 2 in for 'Week greater than' and 8 in for [Week less than] it will still show you results with 'week_number' values outside that range.
What am I doing wrong here?
Thanks.
A query was built which has a WHERE clause that goes...
WHERE ((([blah].Week_Number)>[Week greater than] And ([blah].Week_Number)<[Week less than])
But it doesn't seem to work properly and I don't get why. Eg. If you put 2 in for 'Week greater than' and 8 in for [Week less than] it will still show you results with 'week_number' values outside that range.
What am I doing wrong here?
Thanks.