Problems in setting criteria in queries

[trendmatrix]

Hi,

I have a problem in setting the criteria of queries.

I have two inspection methods: ABC and XYZ. Every two years, ABC will be carried out, and all other years, XYZ will be performed. However, information to which factory XYZ is performed is required. If ABC is carried out, then the information can be simply "N.A".

But when I do the query, I therefore need to add an extra field which will show "N.A" if ABC is performed, or the factory name if XYZ is performed (factory name can be retrieved from another table).

May I know how do I set this criteria in Query?

Thanks in advance.

 

[andrew93]

Hi
If you have to input inspection information for both methods / factories for each year (even though XYZ is done every 3rd year), then it sounds like there is an issue with your table design. Can you post back with a description of the fields in the relevant tables?
Andrew