Hi,
I have a very strange query. I have two fields a and b. a is a text field and b in a number set to double with 2 decimal place.
I am doing a query to group the text field and find me the average of field b.
This works ok. my problem is that i want to find everything in field b that is below 90 now if i put in <90 it works fine. but if i put in <[Average Availability:] and put 90 into the input box.
It pulls out all records below 90 which is correct. Anything that is above 90 is not in there apart from exactly 100. 100 is the highest number there will be in the field. So when using the input box it puts in everything that = 100 exactly and everything below 90.
The very wierd thing is when i put <90 instead it works fine.
Very confussed so any help would be great
k0r54
I have a very strange query. I have two fields a and b. a is a text field and b in a number set to double with 2 decimal place.
I am doing a query to group the text field and find me the average of field b.
This works ok. my problem is that i want to find everything in field b that is below 90 now if i put in <90 it works fine. but if i put in <[Average Availability:] and put 90 into the input box.
It pulls out all records below 90 which is correct. Anything that is above 90 is not in there apart from exactly 100. 100 is the highest number there will be in the field. So when using the input box it puts in everything that = 100 exactly and everything below 90.
The very wierd thing is when i put <90 instead it works fine.
Very confussed so any help would be great
k0r54
