.Justin
Registered User.
- Local time
- Today, 08:32
- Joined
- Jun 29, 2009
- Messages
- 38
Hi There,
I am probably being really thick. I have a table which has a feild called Percentage complete which is manually entered. However I would like a query which only shows me items that are less than 100% complete.
I thought the query criteria would be <100% but that didn't work so I tired <100 and that didn't work either... The data in stored in the table as number data type which the format is set to percentage. What am I doing wrong?
I am probably being really thick. I have a table which has a feild called Percentage complete which is manually entered. However I would like a query which only shows me items that are less than 100% complete.
I thought the query criteria would be <100% but that didn't work so I tired <100 and that didn't work either... The data in stored in the table as number data type which the format is set to percentage. What am I doing wrong?
