Mile-O Back once again... Local time Today, 10:37 Joined Dec 10, 2002 Messages 11,316 May 15, 2003 #21 For date ranges have a look at the example I put on this thread as it has one query that can gather data over any date range you specify.
For date ranges have a look at the example I put on this thread as it has one query that can gather data over any date range you specify.
B btothap jr. member, sr. lurker Local time Today, 05:37 Joined May 9, 2003 Messages 20 May 15, 2003 #22 Thanks Mile. I haven't quite got the fancy calendar form up and running yet, but the Between function is doing the trick. Thanks a bundle for your help. -shane.
Thanks Mile. I haven't quite got the fancy calendar form up and running yet, but the Between function is doing the trick. Thanks a bundle for your help. -shane.
Mile-O Back once again... Local time Today, 10:37 Joined Dec 10, 2002 Messages 11,316 May 16, 2003 #23 If you just import the calendar form and the calendar module into your database then it will work. Just look at the code on the command buttons and copy that to, remembering to fix it to your control names.
If you just import the calendar form and the calendar module into your database then it will work. Just look at the code on the command buttons and copy that to, remembering to fix it to your control names.
B btothap jr. member, sr. lurker Local time Today, 05:37 Joined May 9, 2003 Messages 20 May 16, 2003 #24 yep, got it working. now about my lawn...