G Guest Mar 8, 2004 #1 I am trying to set up a formula. I want the formula to look at the following: When a 1 is entered into the cell I want it calculated as .33
I am trying to set up a formula. I want the formula to look at the following: When a 1 is entered into the cell I want it calculated as .33
R RobFMS Mar 8, 2004 #2 Debbie Are you asking how to change the value '1' to '.33' within an Access table? -- Rob FMS Professional Solutions Group http://www.fmsinc.com/consulting Software Tools for .NET, SQL Server, Visual Basic & Access http://www.fmsinc.com -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- Debbie said: I am trying to set up a formula. I want the formula to look at the Click to expand... following: When a 1 is entered into the cell I want it calculated as .33
Debbie Are you asking how to change the value '1' to '.33' within an Access table? -- Rob FMS Professional Solutions Group http://www.fmsinc.com/consulting Software Tools for .NET, SQL Server, Visual Basic & Access http://www.fmsinc.com -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- Debbie said: I am trying to set up a formula. I want the formula to look at the Click to expand... following: When a 1 is entered into the cell I want it calculated as .33