Search results

  1. B

    COUNT And IFF Statement

    I have the following query, and am counting the total number of bookings and need to check against the capacity to ensure that I do not overbook. On any session(tblSessions table) the total number of bookings should be <= to the capacity(tblVenues table). Now the query below shows the total...
  2. B

    Check to see if 72 hours

    I have an access table, and there is a field called user_time. Once a user record has been inserted, it puts a timestamp on this field, to record the date/time the record was saved to the database. Now I need to write a query to check if it has been 72 hours since the insertion of the user into...
  3. B

    WHERE CLAUSE in SELECT

    Hi Everyone, I have the following SQL statement. The COUNT(b.BookingID) AS TB, gives me the number of bookings. I need to ensure that the number of bookings + PrebookCapacity is less than v.Capacity. I do this by: COUNT(b.BookingID) AS TB + PrebookCapacity < v.Capacity in the WHERE CLAUSE. But...
  4. B

    Executing query

    Hi there, I am trying to run a query from an ASP page, which also uses other queries. I get the following error message: [Microsoft][ODBC Microsoft Access Driver] You tried to execute a query that does not include the specified expression 'Expr1' as part of an aggregate function, this is in...
Back
Top Bottom