HELP: Importing Null Values from Excel

G

Guest

I am trying to import an Excel spreadsheet that contains Null values into
Access. Once the table is imported, I am trying to run a query off of it,
which performs some manual calculations (i.e. GM: [Revenue] - [Expenses]).
However, in this example, if the Expenses field contains a Null value
(implying no expenses), the result of the calculation is blank. Is there a
way to import the Excel spreadsheet and convert any Null values to 0 or blank?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Using "Null" in an IIf statement 2
Append Query 2 4
How to get null values when using Filter Excluding Selection 3
Null values in Pivot Chart 2
Importing Excel to Access Table 2
How to Import data from a different .xls file 2
Finding Null Values 3

Top