Search results

  1. A

    Query Report

    hey, i'm trying to work out performance marks for a student database and i'm unable to. needed some help. baically i have a table called assessments which contains fields ass_id,weight,Type and Module code. I have another table that contains details about students. and finally i've linked the 3...
  2. A

    a formula that can be used to calculate delivery charge

    hey guyz, im buildin a database. in 1 of my forms i need to calculate the delivery charge accordin to the weight of the items. i have the followin fields that im using- itemprice, itemweight,deliverycharge. if the itemweight is below 10 then 5 should be charged and if above 10 then 5+5%of the...
  3. A

    how to put a validation on a calculated field

    hey, i am making a stock control system. in the system i have an order form in which i would like the order not to process if stock is below a certain level. the fields im using to calculate the new stock level is stock level and quantity ordered. i want a message to come up when the user clicks...
  4. A

    ranking in a query

    heyy i have a query which totals for me points for a game.i want the query to also rank for me the record. i have player id and total points in the query. i would like a have a new column which would rank the players. please let me know how i can do this. thanks ash
Back
Top Bottom