Financial

J

jd

I am trying to select specific items out of the financial statement,
such as fuel charges, and find the total cost of these. I have used advanced
filter to get the items I want, but the joined "sum" guery gives the total
sum of the original database not the selected items sum. What's the best way
to get the specific items desired and then the costs associated with those?
 
J

John Vinson

I am trying to select specific items out of the financial statement,
such as fuel charges, and find the total cost of these. I have used advanced
filter to get the items I want, but the joined "sum" guery gives the total
sum of the original database not the selected items sum. What's the best way
to get the specific items desired and then the costs associated with those?
Click to expand...

Given that we cannot see your database, have no idea how your table is
structured, and you have not posted the SQL of your query, it's
impossible to reply.

Please give us a bit more information.

John W. Vinson[MVP]
 
Top