I'm stumped

[Adien]

Well this is my situation, I'm using access 2000, I have 2 querys, one
that has all of our purchases and one that has our sales. Sales are
broken down between lunch and dinner daily. For the invoices there
could be numerious on any given day. I'm trying to design a form that
the user enters either the week # or month and always enters the year
then hits calculate. The system would then calculate the total sales,
total purchases and total profit for the time period and outputs all
three totals to text boxes. Pretty sure I need an array but I can't
figure out the code for it. Any suggestions?

 

[akphidelt]

The best way to do it is to make sure the date always gets entered on the
forms. Then create a query... and create fields using DatePart...

Such as DatePart("ww",[YourDate],Start of your week)

This would show you the week in which the date falls under. If you look
under help and type in datepart you will be able to search for all the codes
for the things you want. You'll see that you can break a date down in to
anything you want. Hope this helps.