Null Values in a Make Table Qry

  • Thread starter Thread starter Anthony Viscomi
  • Start date Start date
A

Anthony Viscomi

I've spent the last 3 hours trying to figure out how to handle Null values
when using a Make Table Query that calls other queries. This entire project
has been a nightmare!

Here's my dillemma:
My original data is imported into various Access tables nightly from a
Mid-Frame. That's the easy part. The portion of the data that I am mainly
interest in is kinda the "Month to date". Simply put, we are into March,
thus there would be data that reads as follows:
# of x Date
300 200401
33 200402
56 200403

and so on. I want my create a new to that has fields for every month even
though there may not be any data and there won't be for the remaining 9
months. My problem is that the Make Rable Query won't work is the values are
Null. Can somone please help?

Thanks,
Tony
(e-mail address removed)

Sorry for the Cross-posting, but I am desperate!
 
Hi,


To make a table with one of its field from a NULL constant value, but
for a given type, say a date, in Jet, try to format it through the dummy
statement:

iif( false, #01-01-01#, Null)


as in:


SELECT f1, iif(false, #01-01-01#, Null) As MyDate INTO newTable FROM
tableName



You should get a null, in a dateTime field, for the newTable.



Hoping it may help,
Vanderghast, Access MVP
 
Back
Top