MS Query

[MarkAndrews]

I have a problem with MS Query

It isn't copying some data over (which derive from an excel formula & is numbers)

Any idea's?

TIA

 

[lozzablake]

send to me at lozzablake@yahoo.com

 

[MarkAndrews]

Hi there, I have sent you a copy of the file

Thanks again

Mark

 

[lozzablake]

This seems to be to do with the fact that the NULLS are text while the dates are Dates. It seems the SQL query cannot handle mixed data types (which make sense as a normal database would have only dates or blanks). If you manually delete the NULLS and then refresh the query, the dates come through as do the networkdays. The answer therefore is to replace the NULLS with blank cells

 

[MarkAndrews]

Thankyou, However I have 8 documents like the one i sent you, Is it possible to use VBA to do this for me?

(I dont know where to start)


Thankyou

 

[MarkAndrews]

If i delete the NULL from E & F, the formula I have in G no longer shows?

 

[lozzablake]

You can just use Find and REplace (Control+H)

 

[lozzablake]

Well it works for me!

 

[MarkAndrews]

You can just use Find and REplace (Control+H)

Hi, Thanks i did this

Find & replace, replace with 'space' bar

Think i'll have to amend my formaula's on Data tab

Thanks again