R
Roger
I have a DB with financial info, income expenses etc.
I have a querry which takes all the info and makes more
fields. Net Income sum([income]-[Expenses] then another
field where I take 5% of net income for one of our
departments. I do these by date using the date critiria
which works great, I then make a report using this info,
but I need a report which I can do this by date and by
total for all entries. I cannot get it to give me the
grand total of net income or the 5% offset. It always
ask for and only gives info for dates entered. I have
tried making another querry from orig, but it also ask
for date. Is what I need impossible ?
Thanks for any help
Roger
I have a querry which takes all the info and makes more
fields. Net Income sum([income]-[Expenses] then another
field where I take 5% of net income for one of our
departments. I do these by date using the date critiria
which works great, I then make a report using this info,
but I need a report which I can do this by date and by
total for all entries. I cannot get it to give me the
grand total of net income or the 5% offset. It always
ask for and only gives info for dates entered. I have
tried making another querry from orig, but it also ask
for date. Is what I need impossible ?
Thanks for any help
Roger