SELECT statement in query

[Tiredmom]

I am having trouble in a query. I have tried to build the following statement with the intention of populating a Point Status field but only when the position is filled. The following is what I tried but I get various error messages.

Expr: (SELECT[Tosting Master].[Pt Status] FROM [Tosting Master].[Pt Status]WHERE[Tosting Master].[Status] = "Filled&quot

I am ready for a lobotomy.

 

[jane30]

you need to select the field from table: SELECT[Tosting Master].[Pt Status] FROM [Tosting Master]WHERE[Tosting Master].[Status] = "Filled" in SQL view and make sure [status] is a field in your table [tosting master].