LibreOffice Base (29) Count and Group

preview_player
Показать описание
Function in design view -- How to count up the number of records on a table or for a result set -- We can also group by a field (like department) and count or summarize a numeric field by group.

The downloads to go with this series can be found here:
Рекомендации по теме
Комментарии
Автор

thank you for your videos! there are extremely helpful! greets from austria

denisdeen
Автор

First thank you for your informative video lessons.
I am needing to do a very common task that I can't as of yet find a way to do. That is time calculatoins. Where I have start and end time. And figure the pay total on that time.
I have not finished all of your videos and am hoping that it will be addressed.

qaz
Автор

Hi again, Good Sir! Thanks for the installment. It looks as if Google are tinkering again....

SOBIESKI_freedom
Автор

Great video! The Function drop down menu for the second column does not show any function options in the drop down. Cannot group or use any other functions for that matter. On Mac OS.

maryc.
Автор

Great video! Do you have a video on using two fields to calculate another? Have a column, average_difference, in the result query that shows: hourly pay - average.

mhernandez
Автор

2:04 It only returns me 7. And I haven't touch the data base.

ryehn
Автор

What if I, additionally, need more columns? For example SELECT *, COUNT(*) AS num FROM TBL GROUP BY column; What can I do in that case? I can't move the count() to a subquery since it returns more than one value... Thanks.

chazy
Автор

For some reason when I use Functions to calculate figures it automatically removes decimal places. I cannot use it for dollar figures! Each field which contains a dollar figure is set to DECIMAL in the TABLE. Specifies 2 decimal places and in format example, it shows the format properly. It works fine until I use Functions like SUM, GROUP and COUNT. Instead of showing the entire dollar amount it just shows a whole number. Any ideas?

bdragon
Автор

sir, i love all of ur tutorials thnks, is there possible in base to remove duplicate, i have googled but there is solution i found, kindly make us tutorial for the removing duplicates in base

TheBabuthebabu
welcome to shbcf.ru