Turn on thread page Beta

I.T Coursework, searches and queries within a databse - need help!!!! watch

    • Thread Starter
    Offline

    0
    ReputationRep:
    Is there any one out there who can help?
    I need to create a search for my dtabase, so the people i am making the database for can search for each date and see who has booked etc.
    please help if u think u can.
    Offline

    1
    ReputationRep:
    (Original post by dormant)
    Is there any one out there who can help?
    I need to create a search for my dtabase, so the people i am making the database for can search for each date and see who has booked etc.
    please help if u think u can.
    If you're doing it in access, do something like:

    SELECT * FROM BookingsTable WHERE DateBooked-Start = @Enter date
    • Thread Starter
    Offline

    0
    ReputationRep:
    i dont really understand what your saying
    Offline

    12
    ReputationRep:
    (Original post by dormant)
    i dont really understand what your saying
    Do you know SQL?
    • Thread Starter
    Offline

    0
    ReputationRep:
    dont think so. well no
    Offline

    10
    ReputationRep:
    Which level is this for? GCSE?

    In which case is this about the Garden Centre? or are you in Y10 at the moment?

    To make a report you should make a Query in Access, and then using the wizard you can change this into a Report.

    It is possible to make the Query in a wizard too.
    Offline

    10
    ReputationRep:
    The following site should be useful:

    http://www.google.com/search?sourcei...ts+and+Queries
 
 
 

University open days

  • University of Warwick
    Undergraduate Open Days Undergraduate
    Sat, 20 Oct '18
  • University of Sheffield
    Undergraduate Open Days Undergraduate
    Sat, 20 Oct '18
  • Edge Hill University
    Faculty of Health and Social Care Undergraduate
    Sat, 20 Oct '18
Poll
Who is most responsible for your success at university

The Student Room, Get Revising and Marked by Teachers are trading names of The Student Room Group Ltd.

Register Number: 04666380 (England and Wales), VAT No. 806 8067 22 Registered Office: International House, Queens Road, Brighton, BN1 3XE

Write a reply...
Reply
Hide
Reputation gems: You get these gems as you gain rep from other members for making good contributions and giving helpful advice.