[AccessD] A2K: Repeat Appointments

Hi Darren

> When I copy and paste the SQL then run the query I get an output similar
> to returned recordset with no records. i.e. just column headers no records.

> How should I be applying this??

Did you add to your table the field Interval (text) which for every
record must contain an "h","d","w","m", or "q"?

/gustav


> 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