Setting up a calendar

[epete367]

I have a shipping calendar report. For most orders the ship date is
determined from a form field for ship date. However, there are special
orders that are sent monthly, quarterly, or every other month. On my
form checkboxes are used to indicate months desired. My problem is I
need these items to show on the calendar also - with shipping to occur
on the first day of that month. Is there some way to do this?

 

[Duane Hookom]

There probably is a solution but we have no idea what you mean by
"checkboxes are used to indicate months desired". A wag suggests you have a
yes/no field for every month which would be un-normalized.

 

[epete367]

You are right. Currently on the special order form there are 12 check
boxes one for each month. It is set up so that you can indicate which
months orders are desired to be sent. I am open to changing anything
necessary to make this work.

 

[Duane Hookom]

You can possibly create a union query to normalize your data...

SELECT FieldA, FieldB, DateSerial(Year(Date), 1,1) as ShipDate
FROM tblNoNameGiven
WHERE [Jan]=-1
UNION ALL

SELECT FieldA, FieldB, DateSerial(Year(Date), 2,1)
FROM tblNoNameGiven
WHERE [Feb]=-1
UNION ALL
--etc--

Try to match your field output to what you need in your calendar. You should
be able to union in your actual shipping date records.