Question about MS Access (don't shoot!)
-
Okay, here it is: Working on a project for a client where we are reading data from a closed DB via a third-party ODBC driver and the client wants to access the reports via Access. It has been a long, long time since I have used Access, and my knowledge of it is admittedly poor. I need to be able to run a report/query/whatever that only selects records of a certain date range based on the Date column in said DB. I managed to run the reports I need via the Wizard, but still need to be able to filter based on that date. The syntax of the report designer is foregin to me (wish I could just use SQL!). I know this has got to be so simple to do, I just am not catching it. :doh: Any references, etc. are GREATLY appreciated, as well as any syntax pointers for the report desginer. Thanks to all who have any information as this is a rush project and needs to be finished yesterday (of course!).
-
Okay, here it is: Working on a project for a client where we are reading data from a closed DB via a third-party ODBC driver and the client wants to access the reports via Access. It has been a long, long time since I have used Access, and my knowledge of it is admittedly poor. I need to be able to run a report/query/whatever that only selects records of a certain date range based on the Date column in said DB. I managed to run the reports I need via the Wizard, but still need to be able to filter based on that date. The syntax of the report designer is foregin to me (wish I could just use SQL!). I know this has got to be so simple to do, I just am not catching it. :doh: Any references, etc. are GREATLY appreciated, as well as any syntax pointers for the report desginer. Thanks to all who have any information as this is a rush project and needs to be finished yesterday (of course!).
I remember making some MS Access reports some time ago... I think you have something called a report filter that is basically an SQL statement, to specify the data that you want reported. Hope this helps.
-
Okay, here it is: Working on a project for a client where we are reading data from a closed DB via a third-party ODBC driver and the client wants to access the reports via Access. It has been a long, long time since I have used Access, and my knowledge of it is admittedly poor. I need to be able to run a report/query/whatever that only selects records of a certain date range based on the Date column in said DB. I managed to run the reports I need via the Wizard, but still need to be able to filter based on that date. The syntax of the report designer is foregin to me (wish I could just use SQL!). I know this has got to be so simple to do, I just am not catching it. :doh: Any references, etc. are GREATLY appreciated, as well as any syntax pointers for the report desginer. Thanks to all who have any information as this is a rush project and needs to be finished yesterday (of course!).
pjvander wrote:
I need to be able to run a report/query/whatever that only selects records of a certain date range based on the Date column in said DB. I managed to run the reports I need via the Wizard, but still need to be able to filter based on that date. The syntax of the report designer is foregin to me (wish I could just use SQL!).
If you want the filter at the report level, just add the following to the "Filter" property of the report.
ColumnDate Between [StartDate] and [EndDate]Be sure to set the value of "Filter On" to Yes As the other poster indicated the "Filter" is really a simple where clause.
I'd love to help, but unfortunatley I have prior commitments monitoring the length of my grass. :Andrew Bleakley: