Hi,
I'll try to explain what I have to get and what i did.
I have a system in Access, which uses SQL Server as a back end.
There are clients in database with orders from inventory, billing report to see charges and orders.
I was asked to add an additional value to show on the report. I added this column in the tables where needed, i can see the label with amount, but it uses "RegionSort" to sort by region and show an additional region i added, here I have a problem.
I added some code in the sourse for this report:
originally it was:
Me.RecordSource = "SELECT JobOrder.*, IIf([ProvinceState].[Region]=""E"",1,IIf([ProvinceState].[Region]=""O"",2,IIf([ProvinceState].[Region]=""U"",3,4))) AS RegionSort,
I changes it to:
Me.RecordSource = "SELECT JobOrder.*, IIf([ProvinceState].[Region]=""E"",1,IIf([ProvinceState].[Region]=""O"",IIf([ProvinceState].[Region]=""N"",3,IIf([ProvinceState].[Region]=""U"",4,5))) AS RegionSort,
In report'sdesign view, i changed data tab for "RegionSort" as well to:
=IIf([RegionSort]=1,"Alberta,Manitoba,Northwest Territories,Prince Edward Island,Quebec,Saskatchewan,Yukon",IIf([RegionSort]=2,"British Columbia,New Brunswick,Newfoundland,Ontario",IIf([RegionSort]=3,"Nova Scotia",IIf([RegionSort]=4,"USA","International"))))
when trying to "preview" this report got Error 3075, then when tried to change things Error 3720, then 3075.
Spent so long already trying to figure out the problem (checked all the tables, source), but no luck.
Will appreciate your help
Thanks
Tali