Recent content by activemars

You can have as many backend as you like(need). Personally I had situations with having backend in more that 10 MS Access DB( reasoning was table size) and ability to compact and repair individual backend on demand without bringing whole system down. Now I migrate lot of stuff to SQL and I have...

In your report query add field with name something like put iif([PART_NO] Like "AC*"= True,[PART_NO],null) as AC_example (AC_example can be whatever name) in your report point field that you want shrink to source AC_example Your report Field should auto shrink if there is null value AC_example...