Sure... if you've got a third bit of data. If you just want sales by month, then a normal query will suffice. If you want sales by month BY REP then yeah, a crosstab makes sense.
Hello I live in the UK and I am new to databases I have an exam in January the 14th which is ICT level 3 BTEC unit 2 creating system to manage informations I am having a private tutor to help me with it but do you have any materials or videos that I could use because I struggle with calculated quieres, forms and reports
Hi Richard, this was a great video! I learnt a lot! However, how do I use fiscal year instead of the traditional calendar year?? I tried using an IIF([OMonth]
Hi richard, i love this aggregate query. I'm building a kinda same query like you show. But for case, i have a month that sometimes doesn't have any sales at all. From your aggregate query how can i make the query show month that doesnt have any sales as 0 or null value? So the table will have a proper 12 months listed from Jan to Dec
hi mr richard If we have several invoices for a single client, each invoice with a different value, there is a way, WHEN THE CUSTOMER PAYS US A TOTAL SUM, TO AUTOMATICALLY DISTRIBUTE between the invoices and the rest of the value is deducted from the remaining invoices
Sure. I'd suggest applying as much as possible to the OLDEST invoice, and then the next oldest, etc. I cover disbursing partial payments in my Access Developer 7 course: 599cd.com/acd7
Hi Richard , how to watch your extended cut year end report, im interested in this but checking it to members only idont see the video? waiting for you response
Nope. LOL. I can show you how to email it, and you can use an email-to-SMS gateway, but I've never done any work with sending direct to text message. I understand a lot of providers now have APIs that you can use, but I have yet to work with one. 599cd.com/EmailSeminar