Search results

Studying your code again I think I've explained myself wrong in that you think I want the sales FROM 0 to 2am ONLY. You see, sometimes we close before midnight and sometimes after midnight, what I want to do is first determine if NOW is after midnight, if so then print yesterdays report plus...

Well the reason was I could not really understand it and it was always giving me Case Error Mismatch, I finally got it to stop giving the error message by removing the AND and replacing it with a comma. But I still can not get the first part to fire up under any circumstance... Dim strWhere As...

vbaInet, I hope you'll be paitient with me a little bit more, I played around and found the following to be working except that I don't know why the first IF is not returning yesterdays sale + the first 2 hours of the next day? But I'm very close to what I want now. If Time >...

vbaInet, thank you in advance for your aircode, i sat this morning trying to work out your code to fit my application, first the simple things, My report had a criteria on the BillDate field which was "Date()" so that it would open up on today's date. Well no matter what I did, I could not even...

Thanks for your answer, No I don't, paraphrasing myself from the first post... we have a peculiar problem in my city in that our shop hours are from 11am till 1pm and then from 8pm until 2am. And here is where the problem lies, I need a way to tell Access that our day ends, let's say at...

I know that I need to learn more about this myself, I've been pulling my hair now for weeks and now I'm even MORE confused then when I started, to make matters worse I think I've upset Spikepl a bit, English is not my 1st language so forgive me if I blunder. I have now realized that what I want...

Yes I realize I was not clear, as you said, work in small steps... 1-Make a query that works, and gives you "yesterday and the first 2 hours of the next day" I can make a query that gives yesterdays results with: Date()-1 and it works. I can make a query that gives today's sale with the next...

Hi again Spikepl, I studied the link you sent me, even though it was hard to understand, and here's what I came up with. First I like to really be honest and thank you for pointing me in the right direction, now if this is still wrong, I don't expect you to do the work for me ofcource, just...

Yes, my mistake, I read it now and I feel ashamed. I will do my best to come up with something tomorrow with the link you were kind enough to provide. I would like to deeply thank you for spending your time with me today. God Bless. Bobak.

THAT'S IT !!! It worked like a charm, However now one other problem surfaced, when I view the report on THIS day, it displays all of today's sale PLUS 2 hours into the next day like expected, but the employees usually print this report at around 2am which then it only displays the records...

Thank you so much Spikepl for your very quick reply, please bear with me for a little bit more as I'M a newbie I know. Your suggestion is starting to make sense to me, I tried what you said in my query criteria but I think some small thing is wrong with the syntax, here is a screen shot...

Hello and thank you in advance for your time. I have a simple report whose underlying query is set to Today's sale table, so in the Date field, the criteria is simply Date() and everything is fine. However, we have a peculiar problem in my city in that our shop hours are from 11am till 1pm...