how did create query on the microsoft access about this question

[Guest]

We need the Code from Queries or Forms or Reports or Modules in Microsoft
Access 2003 to distinguish between last record of the last month and least
record number in the following month.
Then compare both of the records and then give as the least (less) figure
from both numbers.

 

[John W. Vinson]

We need the Code from Queries or Forms or Reports or Modules in Microsoft
Access 2003 to distinguish between last record of the last month and least
record number in the following month.
Then compare both of the records and then give as the least (less) figure
from both numbers.

Well, Access tables don't HAVE "record numbers". Do you mean a an Autonumber
value? What's the structure of your table: I presume you have a date-time
field, but what other fields do you need in the query, and what are their
datatypes?

John W. Vinson [MVP]