Recent content by Bpgasguy

Between DateAdd("d",-6-Weekday(Date(),2),Date()) And DateAdd("d",-Weekday(Date(),2),Date()) Between DateAdd("d",+1-Weekday(Date(),2),Date()) And DateAdd("d",+7-Weekday(Date(),2),Date())) They both will work just not in the iif statement

I have a query that sometimes need to have last weeks Data versus this weeks data So I put a check box on my reports menu and made this IIf Statement IIf([Forms]![ReportsMenu]![Chkwk]=False,Between DateAdd("d",-6-Weekday(Date(),2),Date()) And DateAdd("d",-Weekday(Date(),2),Date()),Between...

Glad to be a member of the forum. I am always trying to find something to make my databases better and run smoother and easier. I have used access for quite a few years for our business and personal use. I continue to learn all aspects of access and trying hard to learn vba. I have already...