Data REport

[Johann]

Another problem. When the date and time are saved in the access. It is only ######## -_-

[HansV]

What happens if you make the LastModified column in the passenger table wider?

[Johann]

Yeah. There it is. Problem is. When I changed the connection of the data report, the Fname doesn't show. -_-

[HansV]

Did you include FName etc. in passengerquery?

[Johann]

Yes. and put the (SELECT Max(LastModified) FROM passenger) in its criteria

[Johann]

Under the properties of Passenger in Data Report

Database Object = View
Object Name = PassengerQ (name of the query)

Am I Correct?

[Johann]

Hey?

[HansV]

I'm not a robot - I can't be online 24 hours a day!

Yes, that looks correct.

[Johann]

I'm sorry. Buty you're the only reliable and the only one who replies in my every post. :)). Sorry

[Johann]

The records in the table are not visible in the table of the query. I think that is the problem. That's why the output is blank

[HansV]

The code to fill the LastModified field will only work for new records created from now on. It will be empty for records created before you added the code.
If you create a new record using your form, that record should be returned by the query.

[Johann]

Have tried several times. but still empty. T_T

[HansV]

Please open the query in design view (in Access), then switch to SQL view.
Copy the SQL text of the query, and paste it into a reply here.

[Johann]

SELECT passenger.Fname, passenger.Lname, passenger.Mname, passenger.Senior, passenger.Adults, passenger.Kids, passenger.Address, passenger.Contact, passenger.LastModified, passenger.Balance
FROM passenger
WHERE (((passenger.Fname)=(SELECT Max(LastModified) FROM passenger)) AND ((passenger.Lname)=(SELECT Max(LastModified) FROM passenger)) AND ((passenger.Mname)=(SELECT Max(LastModified) FROM passenger)) AND ((passenger.Senior)=(SELECT Max(LastModified) FROM passenger)) AND ((passenger.Adults)=(SELECT Max(LastModified) FROM passenger)) AND ((passenger.Kids)=(SELECT Max(LastModified) FROM passenger)) AND ((passenger.Address)=(SELECT Max(LastModified) FROM passenger)) AND ((passenger.Contact)=(SELECT Max(LastModified) FROM passenger)) AND ((passenger.LastModified)=(SELECT Max(LastModified) FROM passenger)) AND ((passenger.Balance)=(SELECT Max(LastModified) FROM passenger)));

[HansV]

Thanks! The condition should be ONLY on the LastModified field:

SELECT passenger.Fname, passenger.Lname, passenger.Mname, passenger.Senior, passenger.Adults, passenger.Kids, passenger.Address, passenger.Contact, passenger.LastModified, passenger.Balance
FROM passenger
WHERE (((passenger.LastModified)=(SELECT Max(LastModified) FROM passenger)));

You can also use

SELECT passenger.*
FROM passenger
WHERE (((passenger.LastModified)=(SELECT Max(LastModified) FROM passenger)));

[Johann]

My Goodness! Thank you! =D. It worked! So gratefule. Thank you very very very much. :D

[HansV]

You're welcome! Good luck with the continuation of your project.