Cross tab queries are best for for this kind of reports- just an opinion. Great video Richard.
@599CD
3 жыл бұрын
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.
@jungjungdelosreyes4147
3 жыл бұрын
Nice new video. Thanks.
@599CD
3 жыл бұрын
Thanks for watching!
@theecobazar6359
3 жыл бұрын
Nice Video Sir.......Thanks Sir
@599CD
3 жыл бұрын
Most welcome
@q2l867
3 жыл бұрын
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
@599CD
3 жыл бұрын
I literally have thousands of hours of videos to help you on my web site: 599cd.com/Access
@alicataratas
3 жыл бұрын
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
@599CD
3 жыл бұрын
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
@alicataratas
3 жыл бұрын
@@599CD thank you
@JoshieDad
3 жыл бұрын
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]
@599CD
3 жыл бұрын
I've got a whole seminar devoted to Fiscal Year calculations. They're not as easy as you'd think: 599cd.com/FiscalYear
@ZulNorizan
3 жыл бұрын
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
@599CD
3 жыл бұрын
Oooh... that's a good one. I'll add it to the TechHelp list. :)
@akocton73
2 жыл бұрын
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
@599CD
2 жыл бұрын
A link to the Extended Cut is in the description below the video. kzitem.info/news/bejne/1IZ81KWFp4xqkpg
@xiixiixo
2 жыл бұрын
I need to create a report with MTD information on the same report as YTD information. Is this possible?
@599CD
2 жыл бұрын
I think so... 599cd.com/YearToDate
@ehteshamshah
3 жыл бұрын
Sir Will u help us how to send Balances to our customers via Text Messages on their Cell Phones
@599CD
3 жыл бұрын
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
Пікірлер: 25