How to point out missing terms of a glossary?

[Giulia]

Hello,


I have a glossary with english terms in one column and french in another. The french glossary misses some terms. The final result I have to reach is another the glossary with the addition of a third Column in which the missed terms of the french column are pointed out.
Could anybody help me? I haven't any idea about how to do it.
Thank you very much!

[June7]

What do you mean by 'misses' some terms? How do you know some are 'misses'?

[Giulia]

I see that in some cells there is not the corresponding translation of the english terms... I would send you the glossary to show you but i don t know if here i can do it..

[June7]

A third column is not needed. Just do a query that retrieves records where the field is null:

SELECT * FROM table WHERE French Is Null;

Can attach files to post. Follow instructions at bottom of my post.

[Giulia]

The exercise ask me explicitly about another column...

[June7]

This is homework? What is the exact wording of the assignment? Maybe you should get clarification from instructor.

What do you want the third column to show - a value like 'Missing' or 'NotMissing'?

Doesn't make sense to me. If the field is empty, the lack of value is obvious. Why is another column with some value needed?

[Giulia]

Yes this is an exercise my professor sent me in order to practice for my exams. In the third column you must see the english words that don t have a french translation.
Sorry for the confusion!

[June7]

Still doesn't make sense. The third column is just replicating the English column.

Assuming French and English are field names:
SELECT *, IIf(IsNull(French),English,Null) As Missing FROM table;

[Giulia]

where do i have to write it?

[June7]

Use the Access query designer. You can build in the design grid or type the statement in the designer SQL View. This is basic Access query functionality. Refer to Access Help, web tutorials, or textbook.