Creating Non-Calculated Fields in Select Queries (1 Viewer)

[x0reset]

Hi All!

I am trying to create an updateable non-calculated field in a select query. Specifically, I want to create a Yes/No data type called "Fail".

This is a multiple-user application so I can't solve the problem by using append and delete queries to modify records in a table.

This has turned into a much stickier problem than I anticipated. I would appreciate any insight or advice you have.

 

[RuralGuy]

If I understand your question correctly, you should be aware that updateable fields in queries can *only* be real fields in a table.

 

[x0reset]

Ok, thanks, I was afraid of that.