I have produced a query that includes a contatenated field as follows:
TextDescription: [EuropaPOno] & ", " & [conceptno] & ", " & [servicescheduleddate] & ", " & [site] & ", " & [suppliername]
This query will be run on a monthly basis and currently the following text is being added as a prefix to this field manually in Excel:
AccP112
This text refers to accruals for period 1 year 2012 and will change each month i.e. AccP212, AccP312
Is there anyway that this text can be added as a prefix to the concatenated field at the point of running the query, i.e. is it possible for the query to ask if any text is to be included as a prefix to this field?
This prefix text does not appear in the database at all and does not need to be saved once the query is run and the data is dropped into an excel form for issue to another department.
All guidance is much appreciated.
Allison
TextDescription: [EuropaPOno] & ", " & [conceptno] & ", " & [servicescheduleddate] & ", " & [site] & ", " & [suppliername]
This query will be run on a monthly basis and currently the following text is being added as a prefix to this field manually in Excel:
AccP112
This text refers to accruals for period 1 year 2012 and will change each month i.e. AccP212, AccP312
Is there anyway that this text can be added as a prefix to the concatenated field at the point of running the query, i.e. is it possible for the query to ask if any text is to be included as a prefix to this field?
This prefix text does not appear in the database at all and does not need to be saved once the query is run and the data is dropped into an excel form for issue to another department.
All guidance is much appreciated.
Allison