I have a DataBase Table [Unit_Rental_Info]. My fields are [Unit #], [Total Cost], [Change Date], [New Cost]. I need my code set up so that in my Query it will show the [Total Cost] for all date ranges up to [Change Date], and the [New Cost] for all date ranges after Change Date?
I tried
IIf([OpData]![Month] <= [Unit_Rental_Info]![Change Date], [Unit_Rental_Info]![Total Cost], [Unit_Rental_Info]![New Cost]).
I have tried this as a Query Field and as a Criteria and I the results are not accurate. Any help you can provide would be appreciated.
Larry
I tried
IIf([OpData]![Month] <= [Unit_Rental_Info]![Change Date], [Unit_Rental_Info]![Total Cost], [Unit_Rental_Info]![New Cost]).
I have tried this as a Query Field and as a Criteria and I the results are not accurate. Any help you can provide would be appreciated.
Larry