Re: Duplicate entries

Ok, a step at a time.

Do you have a Clients table and an Invoices Table? What other tables do you
have that are relevant to the problem (Invoice Items table)?

Assuming you have a clients table, is the client in there more than once.
If so, that is part of the problem, the client should be unique in the
clients table.

The minimal structure I would expect to see would be
Clients Table
ClientID
ClientName
ClientAddress
.... other things you need to know about the client

Invoice Table
InvoiceID
ClientID (so you can link to the Clients Table)
InvoiceDate
.... Other things specific to the overall invoice

InvoiceItems Table
LineID
InvoiceID (so you can link to the InvoiceTable)
ItemID
CostAtSale
NumItems
.... Other things you need to know about the line item

Items Table
ItemID
ItemDescription
CurrentCost


The sample Northwind database is a fairly good example of this set up. It
is more complete than the above structure, but you should be able to use it
as a guide to setting up a system.

"Cathryn H" <CathrynH@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:65AB9412-3656-48DD-872B-CC990A438995@xxxxxxxxxxxxxxxx
Everything is duplicated. It is supposed to be a simple invoicing system
but
having input three pieces of work to be invoiced, invoices 1 and 3 whcih
happen to be for the same client are duplicated and it is showing 5
records.
The query feeds to a form which is printed to issue to the client for
payment
and this also has five entries (two each of invoice 1 and 3).

I am sure it is in the way I have set it up, but I can't see what it is
that
I havedone wrone!

"John Spencer" wrote:

Do you mean there are duplcate records in the table(s) or do you mean
that
you are seeing multiples in a query or in a form based on the query?

"Cathryn H" <Cathryn H@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:9BBB4AFE-6708-4F76-B722-FD6F3F444D3F@xxxxxxxxxxxxxxxx
I have a relatively simple invoice database set up. I only have three
invoices in it so far so my problem isn't yet huge! However, since I
added
the third one, I have developed duplicate duplicate entries.
Interestingly,
this is only for one client. This client has two invoices, both of
which
are
now showing twice. I have tried unsuccessfully to find help on this in
the
Office Assistant and feel sure there is a simple answer - can anyone
suggest
what I have done wrong?





.

Relevant Pages

  • Re: Configureable Query or otherwise
    ... qrycustomerOutsideTerms, "sending" to your query its argument, the client ... but listing the client only once. ... know if it is possible to build either querries or reports on a customer ... and ArTable shows all invoices with client number name and age that the ...
    (microsoft.public.access.queries)
  • Re: Business objects, subset of collection
    ... SQL databases sucks for searching large data sets, ... TPC implementations rely heavily on stored procedures. ... Application modules that are executed on the client side but are stored on the server side. ... Lets say you want to find all unpaid invoices. ...
    (comp.object)
  • VBA to allow configured querry.
    ... So I have experience in programming in Excel, ... know if it is possible to build either querries or reports on a customer ... information on accounts receivable (ie. client name, client number, invoice, ... and ArTable shows all invoices with client number name and age that the age ...
    (microsoft.public.access.formscoding)
  • Configureable Query or otherwise
    ... So I have experience in programming in Excel, ... know if it is possible to build either querries or reports on a customer ... information on accounts receivable (ie. client name, client number, invoice, ... and ArTable shows all invoices with client number name and age that the age ...
    (microsoft.public.access.queries)
  • Re: Getting Totals From Two Different Tables In A Query
    ... > All records from the invoice query, ... >This handles the case where a client has invoices but no payments. ... > FROM Payment ...
    (comp.databases.ms-access)
Quantcast