Recent content by chubbychap

I need to take a copy of my main data table before various updates are applied to it by the user. Before running queries and applying the updates, I have a macro which runs a make-table query to create the main data table. I would like to be able to save dated versions of this main data table...

Hi - I need to extract the month from a date via an SQL pass through query. e.g. if the date reads 19/02/2008, I need to have returned to me 'FEB', so that I can link the month (string) to another table. I have though about "decoding" the date - I've seen that practice used in other scenarios...

Hi - newbie here... I have a project to set up a "simple" room booking database. Basically, rooms are booked, for periods (several days at a time), and I need to be able to query when rooms are free. My main problem is identifying the dates when a room is not booked. The main booking table...