First time here? Check out the FAQ!
x

How can we access all the records from database chronologically?

–1 vote
asked by (110 points) about Microsoft Office Access
edited by

How can we access all the records from database chronologically? I need the records for a particular date and a syntax for accessing the data between two particular dates of birth (from and to).

1 Answer

0 votes
answered by (193k points)

In order to access the records for a particular date, you will need to use the following syntax:

SELECT * FROM TableName
WHERE Date="dd/mm/yyyy";

In order to access the data between two particular dates of birth, you can use one of the following statements:

SELECT * FROM TableName
WHERE Date BETWEEN "dd/mm/yyyy" AND "dd/mm/yyyy";

or

SELECT * FROM TableName
WHERE Date >= "dd/mm/yyyy" AND  Date <= "dd/mm/yyyy";

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
Anti-spam verification:
To avoid this verification in future, please log in or register
...