var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Brilliant DB skips records in Reports
Hi Everyone. I have created a flat database in Brilliant DB ver 9 Ultimate.
The records are:
Unit No: (Where they live)
Language (Choice of 4)
Day of Birth
Month of Birth
Year of Birth
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.
I'd be happy to take a look at it if you like.
Brilliant DB skips records in Reports
Good day James
Many thanks for your quick respone. The database is attached.
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.
Many thanks for the reply. Will make the change this evening after work and will let you know the result tomorrow morning.
Best of luck.
Works like a dream. Very many thanks.