Search results

hi many thanks for replys this is what i am doin at the moment SELECT Order.[Quantity Ordered], Order.[Unit Price Paid], Order.[Total Cost], Purchase.ProjectID, ([quantity ordered]*[unit price paid]) AS Expr1 FROM Purchase INNER JOIN [Order] ON Purchase.PurchaseOrderID = Order.PurchaseOrderID...

Hi many thanks for the reply but i dont want to show any items on the report simple the final sum. I have tried doing the calcualting query, but this has meant i have 26 pages of report as each item is shown even though i clicked on visibilty NO Regards

Hi i asked for some help on making a report with three tables and would like ask if anyone knows of a way of making a query simple showing the total sum. Here is an example I am trying to calcualte quantity * unit price of 20 items which i then need to show on a report. Is there any way i can...

many many thanks I am just a bit confused as to how i can make a query calcualate the sum of two values and intotal output an overall sum. i.e. quantity * unit price = total and then calcuulate all the total. thank you kabir

Here you go Hi i have been using this site since october and it has helped me a great deal i have a site that i have created and i will be greatful to help you guys as this forum is brilliant here is my URL http://www.angelfire.com/theforce/precious/ many many thanks for all the help i...

Hi i am trying to do a report which calculates 3 different tables. However on the report i dont want any data except the final sum of the values i am trying to count. I have added a screen shot and labeled the tables i am trying to calcualte. Does anyone have any advice on how i can do this. I...

thank you so much - this is exactly what i was looking for Thank you once again kabir

Hi i am designing a database and want some fancy buttons on my main menu- I was hoping if someone could tell me if they know any good websites i can get some nice coloured buttons many many thanks kabir

Hi i am trying to do a form where the buttons change colour if you go over them with a mouse. I have heard there is a way but need some advice thank you

Hello Just wanted to ask anyone for advice on using pictures on a form. It is easier to put pictures on a form via the embedded link or the VB method. Im not too sure at present i have the picture embedded but when i load the form it seems to flash and tends to hurts your eyes after a few...

thank you so so much i have been struggling on this one for a while.

Hi I have a form and within it a subform. The form allows users to ammend order quantities. However on the subform there is a calcualtion field where it calculates using the order quanity and order already delivered how many is outstanding. With that in mind i made the order quantity validation...

Hi many thanks for the reply however i dont have norton on my hard drive so i cant see that as the problem thanks

Hi At present there is a 0 default value however the Total delivered field is a calcualtion field. the quantity ordered is say 5 for a example. and for whatever reason the order will now be changed to 9. if i change the quantity delivered to 9 then my error message pops up. the Total...

Hi i am trying to do a testing feature on my form where the user can not alter a order and make the new figure lower than what has already been ordered. At present i am using this calcualation >=[Orderammended1].[Form]![Text22] but if a order has not been delivered the quantity delivered is...

many thanks for that

Hi does anyone know what the following error message means as it has started to appear a few too many times i have attached the error message many thanks

Hi due to other problems i have made two tables that are similar except one holds the main data while the other one is used for simple entering new date. To make the second table save all the data to the main table i have designed an append query where i add new data to the second table and...

Hi i have an append query which i need some help on. Due to reasons i have two tables 1 stores all the items ordered and the second table is used for adding new items which in turn is linked to an append query and is saved on the first table. However i now have a problem in making the append...

many thanks works a treat