calculated field in Query?

[CDICKENS]

Hello,

Access newbie here. I have a query that is running against 2 tables. The first table is the INVENTORY table which contains the INVNUMBER. The second table contains the sales records. My query currently outputs INVNUMBER, Sum of Count, Sum of Successful, Sum of Total Sale. I want to add calculated fields that do the following.

1- gives me the last data an item was listed
2- calculates the close rate = [Sum of Successful]/[Sum of Count]
3- Average sale price = [Total Sale]/[Sum of Successful]

I would like to make another table with the results of this query.

Thanks in Advance,

Chuck

 

[drjekyll325]

Hi Chuck,

1) max(invoice_date)
2) & 3) if you use column aliases (ie. sum(Successful) as SumSuccess and sum(count) as SumCount) you can then define a calculated field as [SumSuccess]/[SumCount]

Hope this helps.

 

[Joe4]

I would like to make another table with the results of this query.

For this last part, check out the Access help on "Action Queries", specifically the "Make Table Query" and/or the "Append Query".