Thanks for the response. The customer wants to list their data in a table. This in my opinion would be best done in a query but they are adamant.
I guess this is one of the reasons that Microsoft created the calculated field in a table, where it wouldn't have been in older versions.
I disagree...