[AccessD] A2K: Repeat Appointments

Sorry Gustav
Still can't get it
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??

Many thanks
Darren


-----Original Message-----
From: accessd-admin at databaseadvisors.com
[mailto:accessd-admin at databaseadvisors.com]On Behalf Of Gustav Brock
Sent: Tuesday, 11 February 2003 6:44 PM
To: Darren Dick
Subject: Re: [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??

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com