Convert 1 to 85?

T

TKM

I have a query that is a number field. All the data currently shows the
number 1 in each field. I want to covert the number 1 to the number 85 to use
in my reports. How is this done?
 
J

Jeff Boyce

Are you saying that you want to leave the value "1" in the table, but show
the number "85" in the report?

Or are you saying you want to (permanently) change all the records in the
table that have a "1" to have an "85" instead?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
J

John Spencer

Use a calculated field in the query and add 84 to the field

Field: Make85: [YourTableName].[YourFieldName] + 84

If you only want to do that when the value is 1 and keep the original value
for all other numbers

Field: Make85: IIF( [YourTableName].[YourFieldName] = 1,
85,[YourTableName].[YourFieldName] )
 
T

TKM

Thanks perfect thanks again!

John Spencer said:
Use a calculated field in the query and add 84 to the field

Field: Make85: [YourTableName].[YourFieldName] + 84

If you only want to do that when the value is 1 and keep the original value
for all other numbers

Field: Make85: IIF( [YourTableName].[YourFieldName] = 1,
85,[YourTableName].[YourFieldName] )


TKM said:
I have a query that is a number field. All the data currently shows the
number 1 in each field. I want to covert the number 1 to the number 85 to
use
in my reports. How is this done?
Click to expand...
Click to expand...
 
Top