ttblWeekOf

I use a table named 'ttblWeekOf' to work behind a form dialog to call a
date range for a report. I got the idea from Mr. Hookum and the
brDemos. I currently use it in a shipping calendar report.
Can I use the same table to call for dates in other reports? For
example, I have a report (rptProductOnOrder). This report shows if
there is enough product in stock for a given date range. There is a
form (frmProductOnOrderDialog) that the user enters a start date and
end date on. Can that form use the same table (ttblWeekOf) or do I need
to create a new table for this form and report?
Thanks for the support!

Should be Hookom with three o's... ;-)
You can use the table as needed anywhere as long as you keep in mind that a
report might need to delete and then add records. I would probably just
create a static table of all weeks and use it over and over with setting a
criteria to limit the date range.

--
Duane Hookom
MS Access MVP
--

wrote in message
ups.com...
I use a table named 'ttblWeekOf' to work behind a form dialog to call a
date range for a report. I got the idea from Mr. Hookum and the
brDemos. I currently use it in a shipping calendar report.
Can I use the same table to call for dates in other reports? For
example, I have a report (rptProductOnOrder). This report shows if
there is enough product in stock for a given date range. There is a
form (frmProductOnOrderDialog) that the user enters a start date and
end date on. Can that form use the same table (ttblWeekOf) or do I need
to create a new table for this form and report?
Thanks for the support!

Thank you for your response and sorry about the incorrect spelling!

If I understand you correctly I can use the same table with different
dialog forms. The static table of all weeks you refer to - would I need
to pre-fill in the weeks or would that automatically be done from the
dialog form as it is now?

Once again, thanks! You have helped me in the past and I greatly
appreciate your assistance. I have been working on a db for a good
friend who opened a home based dessert business. Orders are really
taking off and she can really use the db to track. I think I got in
over my head when I offered to do this; but through help on the forums
I am getting there!

I would just create a table of all dates. You can do this either by creating
the values in Excel and then pasting them into a table or write a little
code. If you just want the Mondays or Sundays, create a query like:

SELECT TheDate as WeekOf
FROM tblAllDates
WHERE Weekday(TheDate0 = 1;

--
Duane Hookom
MS Access MVP
--

"Lisa" wrote in message
oups.com...
Thank you for your response and sorry about the incorrect spelling!

If I understand you correctly I can use the same table with different
dialog forms. The static table of all weeks you refer to - would I need
to pre-fill in the weeks or would that automatically be done from the
dialog form as it is now?

Once again, thanks! You have helped me in the past and I greatly
appreciate your assistance. I have been working on a db for a good
friend who opened a home based dessert business. Orders are really
taking off and she can really use the db to track. I think I got in
over my head when I offered to do this; but through help on the forums
I am getting there!

Mr. Hookom,
As always, thanks for your help and support. I hope you know how
much people like me (novices - who are trying to learn) appreciate the
time and knowledge that people like you offer. While I have bought 3
Access Reference books, use the help files, and search the forums I
find that the direct help that can be received here is far superior. I
have often spent days trying to achieve what is answered here in one
posting. Thanks again!