Recent content by KenHigg

Hum... removed the [datDate] ref from the Chart Axis option and that fixed it. :)

Yes, modern charts.

I am doing charts similar to the ones below and can't find the options to format the top chart dates like the ones on the lower chart. Any suggestions? These just appeared this way and as far as I can tell comparing the options for the two, I can't see anything to set/reset...?

I wonder if windows maintains a list of read-write/read-only file extensions...

Yeah, I mucked up the entire thread by posting wrong screen shots, sorry. And thanks for your help...

Yeah, I posted the wrong code and error msg, sorry. I did have the table name in the docmd. Here is what I was getting: And it was the csv causing the issue. fyi - when you pull up the explanation for the error msg 3027 is says nothing about the file name extension issue. Why is a .cvs read...

When I run this: ================================================= ================================================= I get this: Any suggestions? The cvs does not exist yet... >>>Thanks for any help :)<<<

Smart folks here :)

Thanks! I think I’ll just add a “” and use the <>

yes, what isladogs suggest! Thanks

A little wordy but sparked an idea, Is Null works - thanks! May have to trap empty len strs too...

Here is watered down example, still does not work - ?

Hum... it's really just a table with a column that has an occasional 'x' to indicate the need to exclude the row and a simple query with the criteria <> 'x'. It is an attached excel table though, hum...

Want to exclude these:

Why does this not work: Column with occasional 'x' but <> 'x' will not exclude them... ?