Date or Text field?

[Brianwarnock]

Yep, tho' the = is default so being lazy I ommitted it.
The Format function returns a string the mmmm ensures that it is just the long month, I have added 4 months to todays date as you did not indicate how the selection process is to be driven.

Brian

 

[davesmith202]

You were right Brian, got it working. But think I should add 3 instead, to take it into 4 months. Clever solution and mucho thanks.

 

[Brianwarnock]

You were right Brian, got it working. But think I should add 3 instead, to take it into 4 months..

That's fine , it depends how you look at it.
Happy to have helped.

Brian

 

[namliam]

namliam, I didn't go for your original idea because as you stated, it needs a real date. But the client has only the month as text. Therefore, my suggested solution would work but yours wouldn't, unless I changed the field or data entered. But I appreciate all help given.

That is just BS, to justify your pigheadedness....

IF (and I have asked this before) the month strings are proper month strings (October/December/March/Etc) which they seem to be... You can use CDate quite easily to convert the strings into proper dates and solve this the right and ultimately easier way.

Now looking at your code you posted later... its even more sure my date solution would work...

You were right Brian, got it working. But think I should add 3 instead, to take it into 4 months. Clever solution and mucho thanks.

Which is using A REAL FRIGGING DATE! ! ! ! ! ! ! Thank you very much !

 

[Brianwarnock]

Which is using A REAL FRIGGING DATE! ! ! ! ! ! ! Thank you very much !

Careful of your bloodpressure Namliam.

Your posts implied that he should have a real date in his data, I say he does not need one, I do think that the query will end up parameter driven and the parameter will just be a text month, but if not then all the criteria is doing is finding the current month and adding 4, or 3, the rest of the date doesn't matter. I asked how it was to be run but did not get an answer.

Brian

 

[namliam]

Careful of your bloodpressure Namliam.

Nothing wrong with my bp... but thank you for the concern

Your posts implied that he should have a real date in his data, I say he does not need one,.... I asked how it was to be run but did not get an answer.

And this is the problem now a days with many people.
1) Not answering questions (in full)
2) Not listening to advice given
3) Oh well, it must be me

 

[Brianwarnock]

And this is the problem now a days with many people.
1) Not answering questions (in full)
2) Not listening to advice given
3) Oh well, it must be me

Nope I think that we are all finding that more and more often, also some adopt an abrasive style, Genesis springs to mind, I just bail out but some of you younger members have more staying power.

Brian