Search results

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... ?

Probably right about better / worse but the slider is a. used to put a value in a field then it spawns values in several other fields which makes it a tad better than typing all the values in and, b. kind of sucks the user in watching a graph dynamically change as you slide it up and down... :)

I'll try that - thanks Edit = actually got it to work this way as well: =">="&M2 where I adjust the val in m2

Hi all, long time since I've been here. Anyway, I have a countif() where the if refs a cell that contains <=250. It all works but now I would like to make the 250 dynamic, like maybe it comes from a slider bar, etc. Any suggestions? Here is the countif()...

I will give it a look - thanks!

Wow - Thanks for both replies. I will see if I can get SSMS first!