Advertisement

12.12.2003 at 08:56AM PST, ID: 20824220
[x]
Attachment Details

Calculating Price Total based on different Type

Asked by tina69 in Microsoft Access Database

Tags: calculate, total

Hello,

I have following tables:
tbl Customer PK[CustomerID], FName, LName, etc.
tbl Inventory PK[ItemID], Brand, Type, Price,etc.
EX Inventory table entries
103,Kool Water,JUICE,$3.65
105,Rolling Spring,SODA,$3.50
I also have table that links Customer and Inventory table
Order table PK[InvocieNumber], PK[ItemID], FKCustomerID, Date, etc...

I have form that displays Customer Info and Orders Information
For Specific order they might be different items. I would like to calculate different totals based on different food type. For example, Totals for Type JUICE and Totals for SODA. Tried following without any success :
=IIf(([Type])="SODA",Sum([line item total]),"") ---[line item total] - total for each item...

I would really appreciate any advice

Thank YOU.

 
 
Start Free Trial
[+][-]12.12.2003 at 09:04AM PST, ID: 9929490

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]12.12.2003 at 09:07AM PST, ID: 9929507

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]12.12.2003 at 11:58AM PST, ID: 9930523

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]12.12.2003 at 12:06PM PST, ID: 9930580

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]12.12.2003 at 12:10PM PST, ID: 9930608

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]12.12.2003 at 12:16PM PST, ID: 9930647

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]12.12.2003 at 12:26PM PST, ID: 9930703

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]12.12.2003 at 12:29PM PST, ID: 9930723

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]12.12.2003 at 12:34PM PST, ID: 9930759

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]12.12.2003 at 12:35PM PST, ID: 9930771

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]12.12.2003 at 02:55PM PST, ID: 9931646

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]12.12.2003 at 03:00PM PST, ID: 9931673

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]12.14.2003 at 11:31AM PST, ID: 9938170

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]12.15.2003 at 01:31PM PST, ID: 9945068

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]12.15.2003 at 01:40PM PST, ID: 9945153

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]12.16.2003 at 08:51AM PST, ID: 9950478

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]12.16.2003 at 10:00AM PST, ID: 9950981

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zone: Microsoft Access Database
Tags: calculate, total
Sign Up Now!
Solution Provided By: rthomsen
Participating Experts: 3
Solution Grade: C
 
 
[+][-]12.18.2003 at 09:10AM PST, ID: 9965628

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32