Recent content by ashni

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

heyy thanx alot, it worked...it got it how to do it.. realy appreciate it...thank you

Order TableOrderIDCustomer IDStockIDHamperTypeDestinationOrderDateDeliveryDateItemNoCountryOfOriginQuantityOrderedItemWeightItemPriceStandardHamperPriceDeliveryChargeTotalWeightTotalCostAmountPayableStockLevelReorderLevelO1000C1000S1000Standard HamperUnited...

there no value comin on the field, iv put the code... is it because iv not made a query or?coz im not plannin to have a query for tht.,..leme knw thnx

thank you... im trying to make it work, hope it does...thanx

well im copy pasting the code in the DeliveryCharge field but it aint working. is there any other way?basically i paste the code in the code builder buh my other fields are now not workin... can i retype how my system is workin?maybe i left out somethng... i have the following fields...

i tried, its not workin, is there any other way?

if the weight is 10 then 5 should be charged

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

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

hey thanx alot..it worked...thank you

and forgot to mention my query is called Player Scores Query Under10 Female

hey thanx...buh it not helping..is it possible i give u my field names n then u give me the SQL code accordingly? its Player ID, Total_Points and the new column i want is rank. thank you

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