Recent content by L3igh

Its called EventDetail.UniqueID and I'm not too sure, the query without in and group by worked fine, and then when I implemented the IN() clause it complained until I added group by

The GROUP BY was requested by access after I used the IN()function. Although your code seems a lot neater I can't seem to implement it correctly. I figured out this way and it seems to work well with a lot of tests: SELECT TOP 10 * FROM ( SELECT TOP 10 * FROM ( SELECT TOP 20 * FROM ( SELECT...

Yes There is a Primary Key field in the EventDetail table. How is that relevant sorry? so to select the top 10 (I think i was just wording the question badly when searching for a method): SELECT TOP 10 EventDetail.EventStart, EventDetail.EventEnd, EventDetail.FunctionName, EventDetail.LocCode...

The timetable will be displayed on a TV screen in our foyer, it is supposed to be entirely automated. The software we are using allows SQL when querying access databases but not much else like stored procedures and such. It can take xml input but that would require constant updates in case of...

Thanks very much for the head up with the IN() function, much cleaner. And yes I realized about TGML shortly after I posted the question. I didn't notice the table was out of format until after I submitted the question: EventStart [tab] EventEnd [tab][tab] FunctionName...

Apologies for the table not quite being displayed correctly. This is my first post by the way.

If I have a table like: EventStart EventEnd FunctionName LocCode EventDate StatusID 30-Mar-12 4:30:00 PM 30-Mar-12 6:30:00 PM Chemistry Year 12 - Master Class CONFERENCE ROOM 03 30-Mar-12 {CF56AC74} 30-Mar-12 4:30:00 PM 30-Mar-12 6:30:00 PM Maths Methods Year 12 - Master Class...