Create Report in MSAccess

Here is the basic steps how to create report in MSACCESS and what will be sql query format.

1. Create Form and drag controls set their Name.
2. Create Query which uses form's control value as a selection criteria.
SELECT tblOrders.OrderID, tblOrders.CustomerID, tblOrders.OrderDate, tblOrders.ProductID, tblOrders.OrderQty
FROM tblOrders
WHERE (((tblOrders.OrderDate)>=[forms]![frmReports]![txtDateFrom] And (tblOrders.OrderDate)<=[forms]![frmReports]![txtDateTo]));
3. Create report using query using report wizard.

No comments:

Post a Comment