Subtotaled data imported from Excel????

[sunshine]

I have an Excel spreadsheet that has subtotaled data. ACCESS does not seem to like those fields that are empty because of the subtotals. Is there a way in ACCESS to subtotal data as well?

I am a new user so I don't yet know many of the functions.

Thanks!

 

[Dugantrain]

Are you saying that you have certain fields that contain no values and that Access won't total rows/columns with no values in them? Yes, Access isn't as forgiving as Excel about Null Values, so you should do this:
-Write a query that captures all of the fields that you'll be needing
-In the criteria of each field that you'll be performing calculations on, write:

Iif(is null([YourTable].[YourField],0,[YourTable].[YourField]))

What you're saying here is "If a field is Null, then return a 0 in that field, else if it's not Null, return the original value". I know this isn't nearly as user-friendly as Excel, but you get used to it.