DSum in Queries

[D]

I have a field in my query: New_Cost:[Allocated_Cost]+[Base]

Need to take the total of that column and divide by each record [New_Cost]
to come up with a percentage in a new field New_Cost_Percentage. Can this be
done with DSum and if so, how?

 

[Ken Snell \(MVP\)]

SELECT New_Cost,
New_Cost/DSum("New_Cost", "NameOfYourQuery") AS New_Cost_Percentage
FROM NameOfYourQuery;

 

[D]

Thanks Ken -- Works great!! As always, you come through. It is wonderful
having people like you out there in cyber world to help us out.

SELECT New_Cost,
New_Cost/DSum("New_Cost", "NameOfYourQuery") AS New_Cost_Percentage
FROM NameOfYourQuery;

--

Ken Snell
<MS ACCESS MVP>

I have a field in my query: New_Cost:[Allocated_Cost]+[Base]

Need to take the total of that column and divide by each record [New_Cost]
to come up with a percentage in a new field New_Cost_Percentage. Can this
be
done with DSum and if so, how?

 

[Ken Snell \(MVP\)]

Thanks Ken -- Works great!! As always, you come through. It is
wonderful
having people like you out there in cyber world to help us out.

You're very welcome.