[AccessD] A2K: Repeat Appointments

Hi Darren

Oops - a closing parenthesis was cut off. Sorry.
Try this:

<SQL>

SELECT
  tblBooking.ID,
  tblBooking.Interval,
  tblBooking.DateStart,
  tblBooking.DateEnd,
  DateAdd([Interval],[Factor],[DateStart]) AS DateRepeat
FROM
  tblBooking,
  tbzMultiply
WHERE
  (tbzMultiply.Factor <= DateDiff([Interval],[DateStart],[DateEnd]))
    AND
  (tblBooking.Interval IN ("h","d","w","m","q"))
ORDER BY
  tblBooking.ID,
  tbzMultiply.Factor;

</SQL>

/gustav


> Hi Gustav
> Many thanks for the reply.
> This is over my head but I can certainly see the potential.
> I have modified my tables as per your SQL but when I copy and
> paste the SQL into the QueryDesignGrid I am getting errors related to
> the IN function

> Like I said - way beyond me <vbg>

> Any suggestions??