Convert 1 to 85?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
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] )
 
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...
 
Back
Top