Search results

there is a simpler way in design view of the query. you can add criteria for tableId as [tableid]/2 equals 'Like "*.5*" this returns odd numbers the logic is odd number/2 is always not an integer. for even numbers [tableid]/2 equals 'Not Like ".5"

hi i am prafull using ms access for solo use since office 3.1