I have the following query ms access 2010: field drawnumber should bring up the right part of the numbers 00 to 99 from the 4 digits number in the database
the second field should count how many (records) with the right part of these numbers appears in the database
I used the following code but don't get the correct info in neither of the two fields.
Field1 Drawnumber Field2 TotalHits: Count(Right([Drawnumber],2))
citeria:Right([drawnumber],2)