Link Table - Invalid use of null 1

[scottian]

I have a bunch of linked tables which i query from within the database, when i try to run these queries i get error 'Invalid use of null' Ive worked out that this is due to blank records at the bottom of the excel spreadsheet that i query. once i delete these records the query runs fine. Is there a way to force the query to work regardless of whether these blank records exist in the spreadsheet or not?
search facility here is down at the moment, so sorry if this has already been answered.

"Children are smarter than any of us. Know how I know that? I don't know one child with a full time job and children."...Bill Hicks

 

[PHV]

Any chance you could post your actual SQL code ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[VRoscioli]

I suggest having a look at the Nz() function.


-V

 

[scottian]

Ha Ha Ha....what a muppet i am, Nz worked brilliantly. Cheers VRoscioli, if i could award two stars i would, but one will have to do. Thanks

"Children are smarter than any of us. Know how I know that? I don't know one child with a full time job and children."...Bill Hicks

 

[PHV]

Why not simply add a WHERE clause eliminating those blank records ?

 

[scottian]

Never thought of that.

"Children are smarter than any of us. Know how I know that? I don't know one child with a full time job and children."...Bill Hicks