Results 1 to 7 of 7
  1. #1
    Join Date
    Aug 2012
    Posts
    4

    Unanswered: Brilliant DB skips records in Reports

    Hi Everyone. I have created a flat database in Brilliant DB ver 9 Ultimate.

    The records are:
    First Name
    Last Name
    Unit No: (Where they live)
    Language (Choice of 4)
    Day of Birth
    Month of Birth
    Year of Birth
    Current Year
    Year Age (Calculated by subtrcting YoB from CY)

    As I need a list of people celebrating a birthday in a given month, my report requests the input of a particular month.

    However, if for example I input September, only 12 names appear in the report. But, in fact there should be 15.

    This problem occurs with almost all the months selected.

    Can someone please shed some light on htis propblem. I will gladly email you the database for your inspection.

    Regard
    KeithRobert

  2. #2
    Join Date
    Jul 2012
    Location
    Ireland
    Posts
    815
    Provided Answers: 17
    I'd be happy to take a look at it if you like.

    Regards
    James

  3. #3
    Join Date
    Aug 2012
    Posts
    4

    Brilliant DB skips records in Reports

    Good day James

    Many thanks for your quick respone. The database is attached.

    Regards

    Keith
    Attached Files Attached Files

  4. #4
    Join Date
    Jul 2012
    Location
    Ireland
    Posts
    815
    Provided Answers: 17
    You have ticked a box you should not have ticked.
    See attached image. I've put a red circle around what you must untick.

    The way you have it right now, you have told the program that you do not want to see more than 1 record in your query that has the same Age value.

    Regards
    James
    Attached Thumbnails Attached Thumbnails cause.jpg  

  5. #5
    Join Date
    Aug 2012
    Posts
    4
    Many thanks for the reply. Will make the change this evening after work and will let you know the result tomorrow morning.

    Regards

    Keith

  6. #6
    Join Date
    Jul 2012
    Location
    Ireland
    Posts
    815
    Provided Answers: 17
    No problem.
    Best of luck.

    Regards
    James

  7. #7
    Join Date
    Aug 2012
    Posts
    4
    Hi James

    Works like a dream. Very many thanks.

    Regards

    Keith

Posting Permissions

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