Sql

SQL = "SELECT Lokaler.Id, Lokaler.lokale, Booking.bookid as bId, Booking.lokalenr, Booking.Dato, Booking.initialer, Booking.firma, Booking.tid, Booking.kommentar, Booking.samletpris, Booking.andet, Booking.sagsnr, Booking.antal, Booking.tlf, Booking.foldevæg, Booking.projektør, Booking.KaffeThe, Booking.kaffekande, Booking.tekande, Booking.rundstykker, Booking.ost, Booking.eftermiddagskage, Booking.småkager, Booking.frugt, Booking.isvandkande, Booking.opdækning_uden_dug, Booking.opdækning_med_dug, Booking.buffet, Booking.buffetantal, Booking.bordopstilling FROM booking INNER JOIN Lokaler ON Booking.lokalenr = Lokaler.id WHERE Booking.initialer = '" & Session("auth_Initial") & "'  AND dato >= Date() GROUP BY Lokaler.Id, Lokaler.lokale, Booking.bookid as bId, Booking.lokalenr, Booking.Dato, Booking.initialer, Booking.firma, Booking.tid, Booking.kommentar, Booking.samletpris, Booking.andet, Booking.sagsnr, Booking.antal, Booking.tlf, Booking.foldevæg, Booking.projektør, Booking.KaffeThe, Booking.kaffekande, Booking.tekande, Booking.rundstykker, Booking.ost, Booking.eftermiddagskage, Booking.småkager, Booking.frugt, Booking.isvandkande, Booking.opdækning_uden_dug, Booking.opdækning_med_dug, Booking.buffet, Booking.buffetantal, Booking.bordopstilling ORDER BY Booking.bookid"

Eller brug distinct:

SQL = "SELECT Distinct Lokaler.Id .............................."

isvandkande? :o)

Hvis jeg bruger overstående så lister den dem stadig enkeltvis ... det er nok fordi at book.tid ikke er den samme ... det er alle de andre ... hvis jeg fjerner denne fra group by får jeg:

You tried to execute a query that does not include the specified expression 'tid' as part of an aggregate function.

Hvis jeg bruger:
SQL = "SELECT Distinct Lokaler.Id .............................."
Får jeg:
Cannot include Memo, OLE, or Hyperlink Object when you select unique values (Booking.andet).

Nej, det er fordi, du har et alias med i din group by. Brug denne i stedet:

SQL = "SELECT Lokaler.Id, Lokaler.lokale, Booking.bookid as bId, Booking.lokalenr, Booking.Dato, Booking.initialer, Booking.firma, Booking.tid, Booking.kommentar, Booking.samletpris, Booking.andet, Booking.sagsnr, Booking.antal, Booking.tlf, Booking.foldevæg, Booking.projektør, Booking.KaffeThe, Booking.kaffekande, Booking.tekande, Booking.rundstykker, Booking.ost, Booking.eftermiddagskage, Booking.småkager, Booking.frugt, Booking.isvandkande, Booking.opdækning_uden_dug, Booking.opdækning_med_dug, Booking.buffet, Booking.buffetantal, Booking.bordopstilling FROM booking INNER JOIN Lokaler ON Booking.lokalenr = Lokaler.id WHERE Booking.initialer = '" & Session("auth_Initial") & "'  AND dato >= Date() GROUP BY Lokaler.Id, Lokaler.lokale, Booking.bookid, Booking.lokalenr, Booking.Dato, Booking.initialer, Booking.firma, Booking.tid, Booking.kommentar, Booking.samletpris, Booking.andet, Booking.sagsnr, Booking.antal, Booking.tlf, Booking.foldevæg, Booking.projektør, Booking.KaffeThe, Booking.kaffekande, Booking.tekande, Booking.rundstykker, Booking.ost, Booking.eftermiddagskage, Booking.småkager, Booking.frugt, Booking.isvandkande, Booking.opdækning_uden_dug, Booking.opdækning_med_dug, Booking.buffet, Booking.buffetantal, Booking.bordopstilling ORDER BY Booking.bookid"

Så viser den stadig dem med samme bookid :-(

Hvad så med

SQL = "SELECT DISTINCT Lokaler.Id, Lokaler.lokale, Booking.bookid as bId, Booking.lokalenr, Booking.Dato, Booking.initialer, Booking.firma, Booking.tid, Booking.kommentar, Booking.samletpris, Booking.andet, Booking.sagsnr, Booking.antal, Booking.tlf, Booking.foldevæg, Booking.projektør, Booking.KaffeThe, Booking.kaffekande, Booking.tekande, Booking.rundstykker, Booking.ost, Booking.eftermiddagskage, Booking.småkager, Booking.frugt, Booking.isvandkande, Booking.opdækning_uden_dug, Booking.opdækning_med_dug, Booking.buffet, Booking.buffetantal, Booking.bordopstilling FROM booking INNER JOIN Lokaler ON Booking.lokalenr = Lokaler.id WHERE Booking.initialer = '" & Session("auth_Initial") & "'  AND dato >= Date() GROUP BY Lokaler.Id, Lokaler.lokale, Booking.bookid, Booking.lokalenr, Booking.Dato, Booking.initialer, Booking.firma, Booking.tid, Booking.kommentar, Booking.samletpris, Booking.andet, Booking.sagsnr, Booking.antal, Booking.tlf, Booking.foldevæg, Booking.projektør, Booking.KaffeThe, Booking.kaffekande, Booking.tekande, Booking.rundstykker, Booking.ost, Booking.eftermiddagskage, Booking.småkager, Booking.frugt, Booking.isvandkande, Booking.opdækning_uden_dug, Booking.opdækning_med_dug, Booking.buffet, Booking.buffetantal, Booking.bordopstilling ORDER BY Booking.bookid"

Det giver igen denne:

Cannot include Memo, OLE, or Hyperlink Object when you select unique values (Booking.andet).