Re: Query going wrong

I do appologize for not being very detailed, I haven't used Access in a
while so I am still trying to remember what I am doing. Here is the SQL
statement from the Query.

SELECT Customers.CompanyName, [Mowing Query].MowingTimeTotal, [Fall Clean Up
Query].FallCleanUpDate, [Fall Clean Up Query].FallCleanUpTimeTotal, [Fall
Clean Up Query].FallCleanUpDebrisRemoval
FROM ((((((((((([Aeration Query] INNER JOIN Customers ON [Aeration
Query].CustomerID = Customers.CustomerID) INNER JOIN [Mowing Query] ON
Customers.CustomerID = [Mowing Query].CustomerID) INNER JOIN [Fall Clean Up
Query] ON Customers.CustomerID = [Fall Clean Up Query].CustomerID) INNER JOIN
[Fertilization Query] ON Customers.CustomerID = [Fertilization
Query].CustomerID) INNER JOIN [Pruning Query] ON Customers.CustomerID =
[Pruning Query].CustomerID) INNER JOIN [Bed Weeding Query] ON
Customers.CustomerID = [Bed Weeding Query].CustomerID) INNER JOIN [Coring
Query] ON Customers.CustomerID = [Coring Query].CustomerID) INNER JOIN
[Spring Clean Up Query] ON Customers.CustomerID = [Spring Clean Up
Query].CustomerID) INNER JOIN [Weed Control Query] ON Customers.CustomerID =
[Weed Control Query].CustomerID) INNER JOIN [Tree and Shrub Care Query] ON
Customers.CustomerID = [Tree and Shrub Care Query].CustomerID) INNER JOIN
[Overseeding Query] ON Customers.CustomerID = [Overseeding Query].CustomerID)
INNER JOIN [Edging Query] ON Customers.CustomerID = [Edging Query].CustomerID
ORDER BY Customers.CompanyName;

I am not a big programmer so I have no clue what it means when it's in SQL
format.

Thanks again for the help.

Andrew
"John Spencer (MVP)" wrote:

> Wild guess! Do you have more than one table in the query? Have you joined the
> tables together with a JOIN LINE?
>
> You haven't given a lot of details about your query. Please post the SQL of
> your query (Open in design view, change view to SQL, Copy the text and paste it
> into the body of a message.
>
>
>
> Adiemus wrote:
> >
> > I am working on a customer inventory for services that we have preformed for
> > our customers over the year.
> >
> > The problem I am having is that when I enter in the information for one
> >
> > When I goto the Report Query Report it prints all the same information for
> > each person, it should only print the information for 1 client and that is
> > Andrew Jones, the rest should be blank and have no information.
> >
> > Then when I am in a query where one customer has had the same service
> > preformed 4 different times throughout the year instead of listing it once,
> > it lists it 4 times and because we do services a few times it multiplies it
> > even more for each one, which I understand because each one is a different
> > type of service.
> >
> > I guess I can understand why there are 36 results for 1 customer because of
> > all the information but what I don't understand is why it applies it to every
> > single customer when only one of them has the information.
> >
> > The other problem that happens is if it doesn't apply it to all the
> > customers it gives it to one customer then prints the same report 36 times
> > for the 1 customer.
> >
> > I have tried everything I can think of to try and fix this problem and I am
> > about at my wits end with it, so any help is appreciated.
> >
> > Thanks
>
.

Relevant Pages

  • Re: Help ... Creating an invoice
    ... So what you will want is a query that will return the required information ... for a report to use. ... for just the records for that customer. ... > if I want that order to be placed on the invoice? ...
    (microsoft.public.access.forms)
  • Re: Help ... Creating an invoice
    ... That query should use the customerID value to filter> for just the records for that customer. ... >> if I want that order to be placed on the invoice? ... My original answer was that you would> automatically generate a report including all orders for that customer. ...
    (microsoft.public.access.forms)
  • Re: [PHP] OOP slow -- am I an idiot?
    ... OOP has overhead. ... That saves you putting wasteful SQL queries in your ... If you need to do a complex query with a couple of joins and such, ... I want to create a "customer" class which fetches its attributes from a ...
    (php.general)
  • Re: Report / Sub-Report Problerm
    ... the customer account in the mainform, so equipment that does not match the ... It might be easier to do this with just one report instead of a report and ... Create a query using just tblCustomers and tblProductGenerics. ... this combination of customer and product exists in the tblCustomerEquipment ...
    (microsoft.public.access.reports)
  • Re: move data from list box or combo box to another list
    ... employees is because each employee gets paid commission on the service they ... The customer and dates are ... Lets address your problem with your report which seems to be your main ... Oh yeah and also you should/could have a filter in your query so that your ...
    (microsoft.public.access.forms)