I am trying to keep track of my invoices and need to create an access database. The idea is quite simple though i cannot get this to work.
All the orders come in at different times in the week though the order can be from the same person (i.e. they could order on monday and then order on thursday)
This is straight forward one form that does this for me
Next at the end of every week i need to do a query/report that sorts all the orders taken and groups them by customer name and this is then the invoice (the report is easy though i need to put an invoice number on it this is the wierd part)
At the end of the month i need to accumulate all the invoices for each customer and put them on a statement (invoices from the past 30/31 days)
I have been trying this for ages and cannot get this to work. Does anyone have any ideas or any sample databases to start me off
Have you considered coming at this from a different angle?
Start with 3 tables:
tblInvoices (with fields InvoiceID, CustomerID, DateInvoiceCreated, DateInvoiceSent)tblCustomers (with fields CustomerID,
Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat. The purpose of this eBook is to educate the reader about ransomware attacks.
When developing Access applications, often we need to know whether an object exists. This article presents a quick and reliable routine to determine if an object exists without that object being opened.
If you wanted to inspect/ite…
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted. Others take a little more time and effort and often providing a sample database is very helpf…
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…