Hi,
I have a report that opens when opens should open an update query where the query searches for a filed Name like PNR and updates its YES/NO field to No where that field is yes by default
I tried this in the criteria of the update query
set the PRN fields criteria to YES and update to NO and ran the datasheet but no results came in but when i just run the query itself it asked for the PNR field and when entered, the datasheet showed the results that i wanted.
How do i edit the criteria field to pick the PNR from the reports?
I have a report that opens when opens should open an update query where the query searches for a filed Name like PNR and updates its YES/NO field to No where that field is yes by default
I tried this in the criteria of the update query
Code:
[Reports]![rptInvoice]![pnr]How do i edit the criteria field to pick the PNR from the reports?
seems that although the PNR was available as i type the code but the PNR on the report was simple text also added into it so added another PNR field and that solved it.
