Solved Missing record in query

[Gasman]

Hi all,
Not sure what is going one here.
I have a query qryFoodPerDay which I just use to review how much I have had of a particular food.
As it is just for me, I use an Input Box and enter the FoodID required.

So tonight I picked 191 foodID.
If you look in the table tblDaily there is a factor of 2 (meaning I have had 2 of them) on this day.
Yet when I run the query there is no entry for today.

There is no date filter in the query.
So what I am I missing, that it does not show the food 191 used today.?

 

[Edgar_]

It shows up for me.

 

[Gasman]

Now that is wierd?

OK, I see what is happening.
Sorry. I was looking at the bottom of the query output as the entries would be in date order with no sorting.
Why it appears at the top I have no idea?

Thank you for pointing that out. I was looking in completely the wrong area.