Append Query

[Guest]

Hi,
I desperately need some help. I have got an append query which grabs
data from different tables in order to create an Invoice.

The system is ofr a nursery and therefore, 1 child can have many sessions. A
discount maybe applied. now the problem i'm having is that, when the append
query is run, the discount is applied to each session, whereas it should be
applied once for the whole week.

Dont know if this can be done.

Any help appreciated.

A

 

[Ken Snell \(MVP\)]

Might be possible to do, but it's impossible to make any suggestions because
you haven't given us any information about the table and its structure, the
query and its SQL statement, examples of data, etc. Please post more
information.

 

[John W. Vinson]

I desperately need some help. I have got an append query which grabs
data from different tables in order to create an Invoice.

If you're assuming that you must have all the data in one table in order to
print an invoice, that assumption is *wrong*.

It's quite possible - completely routine, in fact! - to base a Report on a
Query, often a multitable query.

If you have a one to many relationship between a table of Accounts, or
Parents, and a table of caretaking events, you can create a Query joining
these tables; apply the discounts appropriately in the query, or as calculated
fields in the report.

Since we have no way to see how your tables are structured, it's hard to make
specific suggestions - but as a rule, if you're printing a Report, an Append
query will *not* be necessary.

John W. Vinson [MVP]