Hi Everyone
I have a query in which I have created that extracts all payments that have not been paid (no invoice number). In one of my source tables I have an invoice number field (as my query draws from several tables it has become read only) which needs to be populated when the query is run.
I have created a formula that will auto-generate my invoice number in the query, but I am unsure how to make it populate into my invoice number column in the source table.
ClaimRef: ("641" & (CStr(Format(Date(),"yyyymm"))) & [ServiceID])
To add another layer of confusion for me, the source table column is called InvoiceNumber, however in the query it needs to be labelled ClaimReference. So I currently have it set up like this:
ClaimReference: InvoiceNumber
So I am not sure then how to incorporate my formula into this so it populates in the correct column.
Your help would be appreciated
I have a query in which I have created that extracts all payments that have not been paid (no invoice number). In one of my source tables I have an invoice number field (as my query draws from several tables it has become read only) which needs to be populated when the query is run.
I have created a formula that will auto-generate my invoice number in the query, but I am unsure how to make it populate into my invoice number column in the source table.
ClaimRef: ("641" & (CStr(Format(Date(),"yyyymm"))) & [ServiceID])
To add another layer of confusion for me, the source table column is called InvoiceNumber, however in the query it needs to be labelled ClaimReference. So I currently have it set up like this:
ClaimReference: InvoiceNumber
So I am not sure then how to incorporate my formula into this so it populates in the correct column.
Your help would be appreciated