Search results

  1. C

    Adding Date into Table Title via Make Table

    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...
  2. C

    Need to extract month from a date

    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...
  3. C

    Room Booking Scenario: How to identify free rooms

    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...
Back
Top Bottom