Please help! I have a very simple numeric query for my DB which is to display >0 And <5 however anything over the value of 9 is also displayed as a result. I have tried with a leading zero but this just means that my last query becomes >07 and this then displays all numbers????
I'm sure it's something very simple but please help!!!!
I am new to Access and have to create a report that finds a discrepancy in an one of the tables.
there are 2 fields- field A and field B
the report needs to list all the intances the same string appears in field A, but had different values in field B
for example
A_____________B
apple_____________cow
pear_____________cow
banana_____________cow
pear _____________cow
apple_____________pig
banana_____________pig
the output should be:
banana
cow__________ pig
how can i go about creating this report?
Any help would be appreciated, this is a work assignment that needs to be completed ASAP.
Thank you!