Search results

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 :)

Hi everyone, I'm learning the basics of Access and I was looking for advice with regards to appending. I have a large transaction table that I am trying to break down. It had over 20 fields in it and it contains transactions with details such as customers and the products they bought. I am...

Ok, here's the final structure I've came up with. I don't think there is a need for that "main table" I have above since all the info is already contained within the following tables I think? tblCustomer Customer Reference <PK> Customer Name Customer Address Customer Phone tblSalesRep Sales...

TransDetails details is what was sold (e.g. Desk Lamp). Does this make a difference? Also, I'm trying to identify the entities and relationships. I maybe should've done this before. I take it the entities would just be Invoice Line, Invoice Header, Sales Rep, Product, Customer and Transaction...

Ok great. Whilst looking at my existing table, it doesn't have a line number for invoices. How would I go about creating this? There are over 1,500 transactions in the table at the moment and these need to be integrated into the new system.

Ok thanks for your help :) So the invoice header above will replace my tblSalesInvoice? And the "invoice line" table above is used for multiple products in the database? Hope I've got it right!