hello all,

i have a bit of a funny question, and there must be ways out of it.

i created a database for my company wich tracks all the hours worked,
money spent on dinner, materials bought for clients all the financial
stuff.
I put all off this in seperate tables (one for work, dinner,
materials, etc)
now here it comes, I want to create an invoice for a client but i want
to be able to choose what goes on the in voice and what doesn't.
for example, I import all the data into one table, find all records of
the client I want to invoice and make a report separated by work,
dinner, materials. that works but....

now I want to make an invoice with all the work records specified, but
only a total for the dinner and the materials sspecified again. or
thee other way around.....

i have been going on with this since may 2005 (i was to proud to aks
for help)

PLEASE SOMEONE HELP ME????

thanks in advance,

sander loonen

Sander,

I think you have made it too complicated with exporting and importing just
for a report. There must be more simple ways. Like creating one large
calculation that fills up using a set of checkboxes. These checkboxes are
the things you want to include. When checked NO the calculation doesn't
include the values and it does include them when the box is checked YES.
This could easily be set up through a series of relations.

OR

look deeper into summary parts and functions. These are not my forte, but
I'm sure there are readers here that might be able to help you along this
path.

AND

please state platform and version when you post.

Keep well, Ursus

<sanderloonen (AT) googlemail (DOT) com> schreef in bericht
news:1171271796.706889.183060 (AT) v45g2000cwv (DOT) googlegroups.com...

You need an invoice table. Each of your line items, work items,
material, dinner, etc. needs an invoice number. Relate the line items
to the invoice table via that number. In the invoice table you can
make calculation fields that sum each type of line item. In your work
table you find all the work items by invoice number and put the
related calc fields in the header and you have your bill.

I'd recommend one table for all your line items by the way, each line
item would have a 'Type' such as Work, Materials, Dinner.

DJ

On Feb 12, 2:16 am, sanderloo... (AT) googlemail (DOT) com wrote:

thank you both very much,

it gave me a few Ideas, and I will get to work on it straight away.

sorry for not having mentioned before;

version pro 7 on mac osX

cheers,

sander




On Feb 12, 3:28 pm, "Grip" <g... (AT) cybermesa (DOT) com> wrote: