I have various reports based on various queries & cross tab queries. These queries drag out data from a previous month & collate information dependant upon what criteria is met, i.e. Ethnicity, Gender, etc. This criteria is taken from a list held in a table, ie TblEthnicity, which details all the possible choices. The user selects these from a combobox and this value is then stored in the main table.
When I try to run specific reports i get the following error message:
The Microsoft Jet Engine Database does not recognize 'Field Name' as a valid field name or expression.
I have thoroughly gone through each query and crosstab query to see if the data that its pulling is not there. In a sense its not there as specific fields values have not been chosen, but the actual source of the data (the table) is not wrong. The problem lays that the report is not displaying any of the data that relates to the query, not just the data that is missing. For instance:
TblMain, field Ethnicity, for the month of September has 42 entries for Black, 12 for Asian, 19 for Irish, 92 for white, 0 for Afro-Caribbean. Totalling 165.
In relation to this, TblMain also has field of Game, of which there are 120 entries for paper, 45 entries for scissors, but 0 for stone.