Again, something that stumps me but should be easy for many of you. I have a Health Benefits Dbase where we are importing data from three seperate systems into Access. The information we are getting from benefits specifies either "PPO Basic" or "PPO Plus" for a number of the plans available. On each of these, I need to split them into "BCBS PPO Basic" and "UHC PPO Basic", taking ONE record with 5 pricing options and turning it into TWO records with 5 pricing options.
I have been trying to use an append query to add the records. Currently, my attempt is as follows:
If ([HU and HUF 2003 Test Rates]![Plan Type] ="PPO Basic") Then
["BCBS PPO Basic"]
["UHC PPO Basic"]
End If
Any suggestions?
BLT1976
I have been trying to use an append query to add the records. Currently, my attempt is as follows:
If ([HU and HUF 2003 Test Rates]![Plan Type] ="PPO Basic") Then
["BCBS PPO Basic"]
["UHC PPO Basic"]
End If
Any suggestions?
BLT1976