Results 1 to 5 of 5
  1. #1
    Star Lounger
    Join Date
    Jul 2002
    Posts
    54
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Query displays garbage (Access 2000)

    <P ID="edit" class=small>(Edited by HansV on 01-Jun-03 22:40. Made subject more descriptive - "Access 2000 (access 2000)" is not very informative.)</P>I have a queary that pulls two tables together but one text box named "comments" just displays a bunch of garbage like a square? It's as if the text has just disappeared. Any ideas?
    Thanks in Advance!
    SQL regarding my question is below:
    SELECT [dt-JobTickets].ID, [dt-VIN].CustomerName, [dt-VIN].[Clients ID], [dt-JobTickets].VIN, [dt-VIN].Year, [dt-VIN].Make, [dt-JobTickets].Mileage, [dt-JobTickets].Technician, [dt-JobTickets].[14pt Oil Change], [dt-JobTickets].[14pt Oil Filter], [dt-JobTickets].[Lubricate Chassis], [dt-JobTickets].TransmissionFluid, [dt-JobTickets].PowerSteerFluid, [dt-JobTickets].RadiatorFluid, [dt-JobTickets].LightsChecked, [dt-JobTickets].FanBeltChecked, [dt-JobTickets].BrakeFluid, [dt-JobTickets].WasherFluid, [dt-JobTickets].BatteryFluid, [dt-JobTickets].WiperBlades, [dt-JobTickets].AirFilter, [dt-JobTickets].AddRadQts, [dt-JobTickets].FuelFilter, [dt-JobTickets].Comments, [dt-JobTickets].[Vehicle ID Number], [dt-JobTickets].AddOilQts, [dt-JobTickets].AirFilterType, [dt-JobTickets].AddTransQts, [dt-JobTickets].RepairTicketNbr, [dt-JobTickets].AdditionalRepair1, [dt-JobTickets].AdditionalRepair2, [dt-JobTickets].[Next Call Date]
    FROM [dt-JobTickets] RIGHT JOIN [dt-VIN] ON [dt-JobTickets].VIN = [dt-VIN].VIN
    GROUP BY [dt-JobTickets].ID, [dt-VIN].CustomerName, [dt-VIN].[Clients ID], [dt-JobTickets].VIN, [dt-VIN].Year, [dt-VIN].Make, [dt-JobTickets].Mileage, [dt-JobTickets].Technician, [dt-JobTickets].[14pt Oil Change], [dt-JobTickets].[14pt Oil Filter], [dt-JobTickets].[Lubricate Chassis], [dt-JobTickets].TransmissionFluid, [dt-JobTickets].PowerSteerFluid, [dt-JobTickets].RadiatorFluid, [dt-JobTickets].LightsChecked, [dt-JobTickets].FanBeltChecked, [dt-JobTickets].BrakeFluid, [dt-JobTickets].WasherFluid, [dt-JobTickets].BatteryFluid, [dt-JobTickets].WiperBlades, [dt-JobTickets].AirFilter, [dt-JobTickets].AddRadQts, [dt-JobTickets].FuelFilter, [dt-JobTickets].Comments, [dt-JobTickets].[Vehicle ID Number], [dt-JobTickets].AddOilQts, [dt-JobTickets].AirFilterType, [dt-JobTickets].AddTransQts, [dt-JobTickets].RepairTicketNbr, [dt-JobTickets].AdditionalRepair1, [dt-JobTickets].AdditionalRepair2, [dt-JobTickets].[Next Call Date], [dt-JobTickets].Date
    HAVING ((Not ([dt-JobTickets].ID) Is Null) AND (([dt-VIN].CustomerName)=[Forms]![f-Invoices]![UCinvoiceCustomer]) AND (([dt-JobTickets].Date)>=[Forms]![f-Invoices]![AXinvoiceDateFrom] And ([dt-JobTickets].Date)<=[Forms]![f-Invoices]![AXinvoiceDateto]))
    ORDER BY [dt-VIN].[Clients ID];

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Query displays garbage (Access 2000)

    Is Comments a Memo field? If you group a Totals query by a memo field, it will be truncated to 255 characters.

    Your query is a Totals query, but you don't use any of the aggregation functions (Sum, Average, etc.), you just group on every field. Do you have a specific reason for this? If not, uncheck the Totals option in the Query menu; if you do, and if Comments is a Memo field, try setting the Totals option for this field to First.

  3. #3
    4 Star Lounger
    Join Date
    Aug 2002
    Location
    Dallas, Texas, USA
    Posts
    594
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Query displays garbage (Access 2000)

    Squares are representative of characters other then alpha numeric stuff (like nulls).

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Query displays garbage (Access 2000)

    Actually, they're representative of non-printing characters, which includes stuff like Tabs and Line Feeds or any other non-printing character represented by an ASCII code.
    Charlotte

  5. #5
    4 Star Lounger
    Join Date
    Aug 2002
    Location
    Dallas, Texas, USA
    Posts
    594
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Query displays garbage (Access 2000)

    Hmmmm....true. I have to watch me wording around you! <img src=/S/evilgrin.gif border=0 alt=evilgrin width=15 height=15>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •