record missing from query report

[antonyx]

i have made a query.. when executed it returns 4 results..
when i view the report however (made using the wizard based on that query) only 3 results are displayed..

i then add a record to the database... the query returns 5 results.. and again the report only displays 4 results...

i believe that the first record entered into the database is missing from the report.. but it is present in the query.. could i have accidentally deleted the first record from the report when i was altering the layout in design view??

anyone come across this before?

is there a general rule with reports based on queries that only display results with certain criteria or something??

 

[antonyx]

ok, i tried using the report wizard to create a new report.. and the first record was still missing from the report..even tho it was present in the query..

this tells me that i havent accidentally delted the record when i edited the report design...

it must be something else... anyone?

 

[antonyx]

could this have occured because i altered another aspect of the database.. eg.. a table field or a form input.. or a relationship.. something like that during the design and display of the query/report results (which has consequently removed a record from my report display)...

if i make sure that every aspect of the database design is completed.. and then create my queries/reports.. should this error not occur?

the only thing that is baffling me is that when i run the query.. the correct result is outputted.. its just the report doesnt match up..

 

[Pauldohert]

Try uploading the db so someone can have a look for you.

 

[antonyx]

As we know, there are known knowns; there are things we know we know. We also know there are known unknowns; that is to say we know there are some things we do not know. But there are also unknown unknowns - the ones we don't know we don't know.

hahahaha, that is bloody hilarious, wot a twat rumsfeld is, or the person who wrote it anyway..

ok ill have a fiddle with it and if it still plays up ill upload it.. cheers

 

[antonyx]

ok, for experts this may seem obvious but for the lesser minds like me and others let me explain wot happened..

basically i had a query that linked three tables.. a job table (job id) a customer table (customer id) and a customerjob table (customer id and job id).. and these three tables were linked in the query design.

when each job was allocated one customer then the report displayed the details fine.. i then purposely allocated the same job to another customer.. and this is why the record didnt display..

you have to make sure that if you have a one 2 one relationship (like in my situation where each job has one customer) when entering data, you make sure that you only allocate one thing per other thing.. or you will have these problems.

 

[antonyx]

ok.. basically i have made sure there are no dodgy entries. and the database is still doing the same thing..
my query returns 4 results.. and the report returns 3 results..
i dont know why.. if anyone can look at the database and tell me why then thanks.

it is not an overly complicated database or query mite i add..

the query is 'query 1' and the report is the only one there.

thanks in advance if anyone can tell me why its doing this.

http://www.ukjunglist.co.uk/db.mdb

 

[Rickster57]

That's because in your report you are grouping by Booking Date and you have two dates that are identical. You have your data in the Header of the report.
Keep your booking date field in the Header and then copy all the fields in your Report header into the detail section of your report and you will see all 4 records

 

[antonyx]

thanx.. thats done the job.

kiss kiss.. lol.. joke

 

[Rickster57]

Db

Hope this helps. See attached