Re: Help with Crosstab Report

Found the problem
"Al Newbie" <nospamthanks@xxxxxxxxxxx> wrote in message
news:edFeM1zPFHA.1884@xxxxxxxxxxxxxxxxxxxxxxx
> The table that this query is run on gets populated using ADO - I have
> noticed that the Customer field is being padded with a space at the
> beginning of the field
>
> I have tried using LTrim(rsSales.fields("Customer") as part of the insert
> statement but this doesn't make any difference
>
> How can I get rid of these spaces?
>
>
> "Al Newbie" <nospamthanks@xxxxxxxxxxx> wrote in message
> news:%23Wc54lzPFHA.3292@xxxxxxxxxxxxxxxxxxxxxxx
>> Access 2003 - 2000 format mdb
>> I have the following
>>
>> TRANSFORM Sum(tblSalesYTD.TotalSales) AS SumOfTotalSales
>> SELECT tblSalesYTD.Customer, tblSalesYTD.CustName, tblSalesYTD.Area,
>> tblSalesYTD.ADesc, tblSalesYTD.Salesperson, tblSalesYTD.Branch,
>> Sum(tblSalesYTD.TotalSales) AS TotSales
>> FROM tblSalesYTD
>> WHERE (((tblSalesYTD.Customer)="ACNO"))
>> GROUP BY tblSalesYTD.Customer, tblSalesYTD.CustName, tblSalesYTD.Area,
>> tblSalesYTD.ADesc, tblSalesYTD.Salesperson, tblSalesYTD.Branch
>> PIVOT tblSalesYTD.TrnMonth In
>> ("1","2","3","4","5","6","7","8","9","10","11","12");
>>
>> If I remove the WHERE clause then the query returns the expected results
>> but if I try to limit it to a particualr customer no results get returned
>>
>> What am I doing wrong?
>>
>>
>
>


.

Relevant Pages

  • Re: Help with Crosstab Report
    ... The table that this query is run on gets populated using ADO - I have ... noticed that the Customer field is being padded with a space at the ... > If I remove the WHERE clause then the query returns the expected results ...
    (microsoft.public.access.reports)
  • Re: Calculating percentages from COUNT?
    ... I don't really understand you (please forgive my newbie stumblings) ... Do you mean do the total count in another query and then use that field in my original query? ... grouping by the customer field and counting the customerID field. ... Use a subquery to calculate the total count. ...
    (microsoft.public.access.queries)
  • RE: IIF STATEMENT
    ... just filter them out in your query. ... checkbox and IS NULL/IS NOT NULL for nulls in your WHERE clause. ... > have a customer field, and a check box indicating if a payment is promised. ... company A has promised to pay $100 on 06/01/05 and company B ...
    (microsoft.public.access.queries)
  • Show First 10 Characters
    ... I would like to show the first 5 characters of my customer field in my ... query, can anyone help ... ie Customer: Joe Bloggs ...
    (microsoft.public.access.queries)
  • Show First 6 Characters
    ... I would like to show the first 6 characters of my customer field in my ... query, can anyone help ... ie Customer: Joe Bloggs ...
    (microsoft.public.access.queries)