Calculate percentage within currency brackets

[pablavo]

Hey,

I'm unsure of how to do this one, any help would be appreciated.

The database I'm working on has around 2000 records within the parent table. These reflect projects around the world.

the child table has records on how much these projects cost.

I would like to calculate the % of projects cost less than £50,000, then, the % of projects between £50,000-£100,000 and so on.

i'm not entirely sure how to do this, anyone have any ideas?

Thanks

 

[GaryPanic]

one for union qry - and i am less than useless at these

what you need to do is a qry for all projects between 0 and 50k
50,001 and 100,000 etc

then join them some how --