Missing Entries from Select Query

Hi,

Is there any reason why a select query not running for only a specific data?

I am having problem to generate a report which runs after a Select Query (extracted from two tables).

The query extracted some data but not all of the data from the table.

Query details:
The query is built to have field types:
A, B, C - where the records are extracted from a table
D, E, F - calculative fields in the query.
Field C has a filter to include data type 1 and type 2. No other filter is input in the query.

I have tried testing few scenarios and the conclusion is that only a few a specific data does not generate for example:

For the following data in the table (Fields=Record):
A=1; B=1; C=1
A=1; B=1; C=2
A=1; B=1; C=3
A=1; B=2; C=1
A=1; B=2; C=2
A=1; B=2; C=3
A=2; B=1; C=1
A=2; B=1; C=2
A=2; B=1; C=3
A=2; B=2; C=1
A=2; B=2; C=2
A=2; B=2; C=3

The query generates the following combination
A=1; B=1; C=1
A=1; B=1; C=2
A=1; B=2; C=1
A=2; B=1; C=1
A=2; B=1; C=2
A=2; B=2; C=1
A=2; B=2; C=2

and it does not generate
A=1; B=2; C=2

(it will not generate the condition when C=3 because there is a filter in field C to only include record 1 and 2)

The odd thing is that in the test copy database, the query works fine. (the test copy has exactly the same format but just different test data input)

I had tried the following before but getting no result.
1) Re-run the query (by clicking the Run button)
2) Compact and Restore the database

Is this one of the case where the database is corrupted? Is there any other way to correct this other than re-inputting live data using a copy of the test version?

Many thanks in advance
Betty