Hey,
I have a spreadsheet that our Rebates team refreshes. I have the following column in Access: Allowed: Sum(IIf([VARIANCECODES] Like "*QU*",0,[QUANTITY])). IF "QU" is listed as a Variance Code it should list as 0, otherwise just pull the quality since that rebate is allowed. This looks fine in Access, but when exporting to Excel it just pulls in the QUANTITY for everyone. I have tried changing it to "0" or "None", and again it all looks good in Access. It is almost like it is just formatting the 0 on their instead of adding it to the data set. Any ideas on what I can do? Thanks