(Noob alert) How do I see all orders in February?

[Charlie Kilo]

Hi everybody.

Apologies for this very basic question. I have made a database with the tables CUSTOMERS (parent) and ORDERS (child).

Each time a customer orders a product I add a new related record to the ORDERS table via a portal. The ORDERS table contains a date field, COMPLETED_DATE, in which I enter the date an order was completed.

Now I need to invoice for all the work I did in February. What I would like to see is a list of all the orders completed during February, sorted by customer.

Do I use a Report for this? Or are they just for printing? Again apologies for asking such a basic question.

Kind regards,

Frosty.

[Vaughan]

If it's an invoicing system you'll need more tables than Customers and Orders. You'll need a Products table and a "line items" table to resolve the many-to-many relationship between Orders (aka Invoices) and Products.

[Charlie Kilo]

Hey Vaughan,

Yeah, I have some other tables. Thanks. :

Best regards,

Frosty.