Hey there! Sign in to join this conversationNew here? Join for free
x Turn on thread page Beta
    • Thread Starter
    Offline

    16
    ReputationRep:
    It's not really awesome sorry.

    I was wondering if anybody could help me with my ICT coursework - Access/Database.

    So basically: I am making a booking system for a tuition centre. I have done pretty much everything (queries, reports, tables, forms) but there are two things that I am struggling to do:

    1: I want to make an invoice for the lessons. All of the lessons are £30.00 so this is what I have done so far: I made a query which contains the student and lesson details, a long whether if they have paid. I then made a report. So now, I want the system to automatically write down the total sum which needs to be paid. So basically to automatically count how many lessons they are registered for and times each lesson by £30.
    (managed to do this)



    2: I want the system to prevent double booking. I haven't done anything to do this so far since I have no idea what to do despite checking all the textbooks and the internet. I am aware it is something based on a query but that's about it.


    Would appreciate any help Thank you!
    • Thread Starter
    Offline

    16
    ReputationRep:
    Giving this a subtle bump.

    If anybody can help me, please do
    Offline

    17
    ReputationRep:
    Bump!
    • Thread Starter
    Offline

    16
    ReputationRep:
    So I managed to create the invoice, just need to prevent double bookings then I am done

    Anybody know how to do that? I have looked everywhere
 
 
 
Reply
Submit reply
Turn on thread page Beta
Updated: January 17, 2015
Poll
Do you like carrot cake?

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.