Create Queries with Calculated Fields and Aggregate Functions

  Рет қаралды 604,198

Six Minutes. Smarter.

Six Minutes. Smarter.

Күн бұрын

Пікірлер: 89
@SixMinutesSmarter
@SixMinutesSmarter 11 жыл бұрын
I teach Office applications and Web Development at a community college in Oregon. I'm self-taught in Office apps. Had to learn on the job after college when I worked for an insurance company (I've got a Business/Finance background). Later, in '97, I started learning HTML to make web pages. Thanks for watching.
@t0rtill0s
@t0rtill0s 6 жыл бұрын
Ralph Phillips thanks for you post, this is considered learning on the Job for me.. awesome videos!
@Jdawg2theMaxx
@Jdawg2theMaxx 5 жыл бұрын
Thank You So Much!!! Been stuck on a problem like this for hours with no idea how to do it! You helped me get through it in less than 10 minutes.
@jamesedwardsjr3466
@jamesedwardsjr3466 9 жыл бұрын
Thank you Ralph for the video tutorial; you helped jump start the learning curve in writing expressions; and the zoom function tip improves visibility to write out the syntax. I look forward to watching more of your videos pertaining to access and working with SQL's.
@TheBrilliantPhoenix
@TheBrilliantPhoenix 7 жыл бұрын
Ralph has a very good voice for instruction! Unfortunately, the Office version is several generations past, and Access has changed significantly in the meantime.
@SixMinutesSmarter
@SixMinutesSmarter 11 жыл бұрын
It's amazing how many cool ideas you'll have when you're supposed to be clearing your mind.
@ricksegalCanada
@ricksegalCanada 6 жыл бұрын
This was super helpful and, after six years, relevant and very much appreciated! Thank you
@DaveBernstein2023
@DaveBernstein2023 4 жыл бұрын
i have been searching for the solution to the same problem for months and now this guy save me
@danishharoon
@danishharoon 6 жыл бұрын
Thank u have my IGCSE finals tommorow alot of help
@kerrieleong4801
@kerrieleong4801 3 жыл бұрын
Thank you Ralph. Very interesting tutorial.
@yebelaygetnet5990
@yebelaygetnet5990 4 жыл бұрын
nice video .......be continue !!!1
@mybitch2700
@mybitch2700 9 жыл бұрын
Awesome thanks! This will most likely help me get through my Admin Prelim tomorrow, haha! ;)))
@nasirayub951
@nasirayub951 5 жыл бұрын
Dad Ralph Phillips, because you are like my dad .thanks you are helpful
@smmng
@smmng 12 жыл бұрын
I am very new to access and in the process of making a database - thanks - helped a lot
@ahmedaamri1290
@ahmedaamri1290 6 жыл бұрын
ألفين وتماميه
@yash1152
@yash1152 4 жыл бұрын
i think this will help me too.... (was preparing query for marks wise distribution of topics, grouped according to unit they belong to).
@thelemleys
@thelemleys 3 жыл бұрын
Thank you Ralf This very helpful 🙏🙏
@r_b5951
@r_b5951 11 жыл бұрын
Great set of Access tutorials. Thanks Ralph!
@sinisterem
@sinisterem 5 жыл бұрын
Hi, useful video. I have a bit of a noob-question: how do I create a field that calculates the sum total of a column? Goal is to have query from wich I can create a two column report: colomn a: expanses, column b: amount. And one field with the sum total of all the expenses.
@InfinityShakes
@InfinityShakes 9 жыл бұрын
Thank you. Helped me with my assignment for class.
@salmashaik5676
@salmashaik5676 5 жыл бұрын
thank you mate u helped me with my exams
@slyowusu99
@slyowusu99 8 жыл бұрын
question. what is the best way to create an Annual leave booking simple DB on Access 2003? For a few staff members to ensure we all do not take leave at the same time. thanks
@lamunugloria4653
@lamunugloria4653 8 жыл бұрын
Thanks a lot, when do formulas come in use and which ones are the only recommended signs / or formula ones to be used?
@nicoled9765
@nicoled9765 7 жыл бұрын
Can you suggest on how I would create a querie and report in Access of all employee work schedules for the week? I was hoping to make the report look like a table with the days of the week across the top/columns and hour increments along the left side/rows and all the employees scheduled for those times and days are in the table's center. Thank you!
@nidalalahmad3421
@nidalalahmad3421 8 жыл бұрын
Hello Ralph, how can I create a query show a record depending on max value in this record? I mean show the max value and other fields in the same record.
@stewmaker8685
@stewmaker8685 3 жыл бұрын
HELLO , is there a formula for determining if gender of a list of names that has the Mr. and mrs. initials. so that the outcome will be either M or F according to the initials on the names
@elissarrez3462
@elissarrez3462 8 жыл бұрын
Hello , I have question : I am creating a Query, and I precised each client if he is a "M" or "Mlle" or "Mme". How can i count how many M's ; Mme's and Mlle's i have ? Thank you !
@tutsecret499
@tutsecret499 7 жыл бұрын
I want to count or sum of lab test 1 neg, 2 pos. So the column that has the tests shows all the results. What's the formula? =Sum[Test1]? I want to count all the 2positive, and the 1 neg. So How do I set up? =Sum[test1], 2. Thanks.
@behindthescene2727
@behindthescene2727 3 жыл бұрын
will watch later
@michaelle3743
@michaelle3743 8 жыл бұрын
Problem: Add criteria to this query to return only the records where the value in the Credits field is less than 90 and the value in the Classification field is Jr or Sr. Is the answer: "Jr" in criteria, "Sr" in or, >90 in Credits Criteria ? I keep getting the wrong answer on my test.
@momalade8626
@momalade8626 9 жыл бұрын
Thank you so very much. Just what I was looking for. You are awesome!!!!
@modd1970
@modd1970 11 жыл бұрын
Thank you Ralph for the video. If I have a customer with multiple purchases, how can I display the latest purchase ( only ) in a query ? Thanks ..
3 жыл бұрын
I love your presentation here sir, I have a problem with this calculation, to calculate unit price sale with the quantity and have my total balance please help
@GO-gh2cp
@GO-gh2cp 5 жыл бұрын
very usefull ! thanks !!! 👍
@goodgirlteccie19
@goodgirlteccie19 9 жыл бұрын
How do I display values of a field in a query? I tested and i never got that one because it didnt make sense to me
@mohammadsamikhan5300
@mohammadsamikhan5300 4 жыл бұрын
Good
@franciscoxcamposp9984
@franciscoxcamposp9984 5 жыл бұрын
Hi there! Could help me with an specific exercise? Please, thanks so much
@jamesedwardsjr3466
@jamesedwardsjr3466 9 жыл бұрын
Any ideas on how I can go about writing an expression in the query to add the total Charge amount based on the date for the month? Below is a snapshot of the the three columns available, and the Monthly ChargeAmount to be added. ClientID | TransactionDate | ChargeAmount | Monthly ChargeAmount
@tutsecret499
@tutsecret499 7 жыл бұрын
So what's the formula to count all xrays with the data Yes(did xray), No(did not). So it would be Sum or count =sum([XRay]), Yes or True. I am lost.
@emilynhg9959
@emilynhg9959 5 жыл бұрын
do you have a executable query for this tables?
@dukestt
@dukestt 11 жыл бұрын
never stop the learning...
@PMJS15
@PMJS15 8 жыл бұрын
So i need to create new field with a new name that will calculate and display the donation amount and it saying i need to make a function that shows it adds 50%
@ravikishorergajavalli
@ravikishorergajavalli 8 жыл бұрын
Thanks Ralph Phillips
@GabrielHernandez-il1uf
@GabrielHernandez-il1uf 4 жыл бұрын
Hero
@OTLEminem
@OTLEminem 10 жыл бұрын
what the calculation if I want to have the balance more than 0 and less than 1000?
@guitartrip1
@guitartrip1 10 жыл бұрын
great video. I have been spending days on how to get a percentage of customers that are past due. Would you know how to get percentages on the query?
@reannan1462
@reannan1462 10 жыл бұрын
Export it to Excel and calculate the percentage there???
@FingCm
@FingCm 11 жыл бұрын
thanks Ralph this really helped me
@marvinadhikari9751
@marvinadhikari9751 6 жыл бұрын
That is informative, but what if I want to know total debt outstanding? Or, sum of column total?
@_anon464
@_anon464 6 жыл бұрын
+Marvin I wasn't following this that closely but if I'm understanding your question correctly, I think you'd just have the "debt" column only and change it's totals line to "Sum".
@AdamFente
@AdamFente 8 жыл бұрын
Thanks dude this helped out a lot
@josephburt-millerjr4934
@josephburt-millerjr4934 10 жыл бұрын
This is what I'm trying to do: I need to run a report based on proficiency dates for 120 days out, 30 days out and LATE. The proficiency dates are needed to my service 60 days prior to the proficiency date, so the 120,30,and Late would be calculated from the proficiency date. so basically if a prof. date is 1 Oct then they are due to my service 1 Aug and need to start showing up on a report 1 Apr, 1 Jul, and 1 Aug. Once they have been received for the current calendar year I would need them to go to the next Calendar year. So received for 2014 doesn't show back up on the report until 2015. So far I've created a table within Access 2013 from an Excel spreadsheet. it includes first name, last name, middle, proficiency date, and occupation number. So I'm thinking my next step is to create a query based on the proficiency date, but I'm not sure how to get those results to show within that table, or should I have to display in a new table? Would I have to create a separate query for 120, 30, and late? This table currently has over 450 entries and would need the ability to add/remove records when necessary
@robynpearson5440
@robynpearson5440 7 жыл бұрын
hi i need to find out how do i create a query which i have to displybasically the make and model of cars which are purchased before a certain date please help
@MichaelSmith-ox2sw
@MichaelSmith-ox2sw 7 жыл бұрын
Assuming you have a single table (called tblCar) with the fields: Make, Model and PurchaseDate, you could write a basic SQL statement like: "SELECT Make, Model FROM tblCar WHERE PurchaseDate < #01/10/2017# ORDER BY Make, Model ASC;" This will return all Makes and Models that were purchased before January 10, 2017.
@ArifRahman-ex2vx
@ArifRahman-ex2vx 7 жыл бұрын
Sir I need a total accounting as a beginner student in access.
@ekkhitty4175
@ekkhitty4175 7 жыл бұрын
Can i have a LINK you used to create this data base from scratch
@marvin-sw9rv
@marvin-sw9rv 6 ай бұрын
how do filter field in tables
@iBasskung
@iBasskung 11 жыл бұрын
Thank you so much.
@Riders9191
@Riders9191 8 жыл бұрын
Thanks Mann..
@ArifRahman-ex2vx
@ArifRahman-ex2vx 7 жыл бұрын
Thank you sir
@mzz7768
@mzz7768 9 жыл бұрын
Thanks
@ThisMightBeBenjaminYoung
@ThisMightBeBenjaminYoung 4 жыл бұрын
how was yoga class?
@SixMinutesSmarter
@SixMinutesSmarter 4 жыл бұрын
Very good.
@kimbby
@kimbby 10 жыл бұрын
thank you so much
@anilvaljibhanushali5353
@anilvaljibhanushali5353 9 жыл бұрын
No Words For You, Thanks _______________1000000000000000.....n times
@filipnovak1751
@filipnovak1751 11 жыл бұрын
Where did you learn all this stuff? I mean Access, Excel, and all programming languages? Do you work with them in your job?
@mabalamakhakhe42
@mabalamakhakhe42 4 жыл бұрын
Hope you enjoyed yoga
@SixMinutesSmarter
@SixMinutesSmarter 4 жыл бұрын
Always
@michaelliolios1679
@michaelliolios1679 5 жыл бұрын
bro dont be missing yoga
@TheNerdsFromHell
@TheNerdsFromHell 8 жыл бұрын
HOW THE FLY FUCK DO YOU CREATE A GOD DAMN TOTAL BY ADDING A PREVIOUS TOTAL! I need this for weekly hours and I have not idea how to use access
@MichaelSmith-ox2sw
@MichaelSmith-ox2sw 7 жыл бұрын
That is what the Sum function was used for. It iterates through the data and adds the values recursively.
@JIMN26
@JIMN26 4 жыл бұрын
Wow, what a bunch of irresponsible clients! Was this during the housing crisis?!
@Urketadic
@Urketadic 9 жыл бұрын
Yoga class huh
@alahatim
@alahatim 9 жыл бұрын
Really? Yoga reminder pops up during video recording. Pleb.
@cushcush100
@cushcush100 7 жыл бұрын
Holy fuck,... blurry!
@patstechwritingtips8418
@patstechwritingtips8418 10 жыл бұрын
Yoga? Seriously?
@johnclifford1920
@johnclifford1920 5 жыл бұрын
Thanks for the help but please try to smack your lips less
@SixMinutesSmarter
@SixMinutesSmarter 5 жыл бұрын
Got it. :) That was for the ASMR fans.
@yash1152
@yash1152 4 жыл бұрын
@@SixMinutesSmarter Hey, can we group, but also show sub-items, like a tree-view where u expand things by clicking the arrow or anything like that?? Any hybrid way involving export to word or something maybe, but which is still more efficient than the crude way (i.e. manually doing it).
@stevenstocki3122
@stevenstocki3122 7 жыл бұрын
Yoga dude ? Really ?
@marissa954
@marissa954 6 жыл бұрын
i knew it i'll see a comment about it lmao
@d.w.1805
@d.w.1805 6 жыл бұрын
grow up
MS Access - Queries Part 6: Calculated Fields
9:34
Mr Long Education - IT & CAT
Рет қаралды 69 М.
啊?就这么水灵灵的穿上了?
00:18
一航1
Рет қаралды 100 МЛН
REAL 3D brush can draw grass Life Hack #shorts #lifehacks
00:42
MrMaximus
Рет қаралды 12 МЛН
the balloon deflated while it was flying #tiktok
00:19
Анастасия Тарасова
Рет қаралды 34 МЛН
Create a Crosstab Query in Access
7:59
Six Minutes. Smarter.
Рет қаралды 173 М.
Calculated Fields in Access queries - Tutorial
16:47
codekabinett.com/en
Рет қаралды 62 М.
Access 2010: Auto populate fields using a combo box in forms.
11:57
Allen Jarrett
Рет қаралды 558 М.
MS Access - Queries Part 1: Basic queries
19:10
Mr Long Education - IT & CAT
Рет қаралды 136 М.
Microsoft Access Multi-Field Search Form 2.0 New and Improved Features!
50:26
Computer Learning Zone
Рет қаралды 117 М.
How to use Microsoft Access - Beginner Tutorial
31:07
Kevin Stratvert
Рет қаралды 3,2 МЛН
啊?就这么水灵灵的穿上了?
00:18
一航1
Рет қаралды 100 МЛН