Recent content by kev88

Ok I tried that. Does the formula look right to you? (problem2.jpg) When I try and run the query, it comes up with the screen on problem1.jpg

Ok thanks I've managed to do that :) I am now trying to create a query like before but now with profitability. I've given it a shot and I set it up (query4.jpg), but when I try and run it, it comes up what is shown on query5.jpg. I think I've got the actual query itself right but not sure...

I tried to do this but Access modified the query to what is displayed below and produced the number of products in the invoice rather than the total of each invoice. Have I done something wrong? Thanks again :)

Ok, I understand how to get a select query now thanks :) But how do I enter this SELECT InvoiceID, SUM(Quantity*UnitCost) AS InvoiceTotal FROM InvoiceLineItemTableNameHere GROUP BY InvoiceID; I have attached what I have so far. Sorry about my lack of knowledge - but I'm keen to learn though :)

Thanks for the suggestion. I have attached an image of my query design page where I was thinking about putting the line above :)

How do I put the query in? Once going to "Query Design", do I copy and paste the line above into "criteria"? Sorry for the lack of clarity :)

ok thanks...I'm not very experienced with this so I'd appreciate if you could simplify this for me :) thanks for your help so far.

Hi there, I was wondering if someone could help me. I have two tables - one which contains the Invoice with details such as the Sales Rep who made the sale and the transaction date. It will also contain a total invoice cost - which is what I'm having trouble with. The other table contains...

Yes thanks. Although, I'm now having trouble trying to calculate the total of each invoice to be displayed in a column of another table For example, say I wanted to display the total of invoice ID 10264 in another table, how would I go about doing this? http://tinypic.com/r/99nh9e/5

Got it - thanks very much for your help. That box wasn't blocked out :)

Ok, I tried that but that particular option is blocked out? http://i41.tinypic.com/4sywt1.jpg Thanks again

That might be it. How would I save it as an .accdb? I went to the "Save As" bit and typed in Project.accdb since the ".accdb" option wasn't there (just Microsoft Access Database). Then went back into it but I have the same problem as before. Thanks for your help

Hi, I have a simple table where I want to insert a calculation. I have the following columns - "Quantity" and "Unit Cost" I'd like a "Total" column which gives the Quantity*Unit Cost to give the total. How do I go about doing this? http://allenbrowne.com/casu-14.html I read on the link above...

I should add that I want to move existing transactions to the new tblProduct that I've created.

Thanks for your help. Could you break that down for me? I'm a beginner so I'd really appreciate your help :)