hi
i am trying to do sql query in microsoft access. i have two table member and loan table. in member table all the member details are listed
in loan table contains those members who have taken film. but my question is i have to show all the members from loan and member table who have not taken a film for specifc period. for this question i have set two dates to see all the members who have not taken any film in that period of time....
125a29
Joined: Apr 22 '10
Location:
-
run query in microsoft access
-
how to update order table
hi i'm trying to update total order cost in order table , basically what i want when i edit order item table such as changing quantity then it automatically update the total cost in order table
i mean if there are two order items in orderitemtable such as for item 1 and the hire cost is £20 and quantity is 2 for each item and these two different orderitems ID are under one orderID and it calculates the total order cost but doesnot... -
how to update total cost in order table when you edit order item table
hi i'm trying to update total order cost in order table , basically what i want when i edit order item table such as changing quantity then it automatically update the total cost in order table
i mean if there are two order items in orderitemtable such as for item 1 and the hire cost is £20 and quantity is 2 for each item and these two different orderitems ID are under one orderID and it calculates the total order cost but doesnot...
No activity results to display