sorting date from query to report

[Guest]

I run commission reports on access and when I went to do the whole year of
commission reports, the report only showed dats with single digit months
(october, november and december do not appear in the report). I did not set
this database up and I only know how to use access for the purpose of these
reports- anyone have any suggestions??

 

[John Vinson]

I run commission reports on access and when I went to do the whole year of
commission reports, the report only showed dats with single digit months
(october, november and december do not appear in the report). I did not set
this database up and I only know how to use access for the purpose of these
reports- anyone have any suggestions??

It sounds like you have an error in the report or in the query which
feeds the report. Since we cannot see the report or the query, it
leaves us little that we can do to help!

Try opening the Report in design view; view its Properties; and find
the "Record Source" property (first on the Data tab). If it's a query,
click the ... icon by it, and use View... SQL to view it in SQL mode.
Copy and paste the SQL text to a message here.

John W. Vinson[MVP]