Results 1 to 3 of 3

Thread: Apologies- Very generic question

  1. #1
    Leroy_Brown
    Guest

    Apologies- Very generic question

    Hi there.......I realise nobody can answer this without seeing the project but if anybody has a thought of where I can look that would be awesome. I have a large dB in Access 97 and i generate multiple reports from it. I have a criteria form where the user chooses a field from a cbox as criteria. The report generates perfectly for all choices except one! I am pulling my hair out trying to find out why. The data types and properties seem to match:

    ex.
    This one works

    fieldOne: EK Descreption: EAST KOOTENEY

    This one does not:

    fieldOne: M Descreption: MARATIME

  2. #2
    Fanatic Member ExcalibursZone's Avatar
    Join Date
    Feb 2000
    Location
    Western NY State
    Posts
    908
    Do the Descriptions have to be spelled properly? If so, try MARITIME
    -Excalibur

  3. #3
    Leroy_Brown
    Guest

    SPELLING BEE

    haha....spelling was never my strong point. However that wasn't the problem. I just traced it back. The query references a table that has incomplete data at the moment. I should have known!!! Sorry to waste everyones time.

Posting Permissions

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



Click Here to Expand Forum to Full Width