How to Create Summary using Select Query in Ms Access | Edcelle John Gulfan

This video helps you to handle large volume of records.
👍 Please Like comment and share to support this channel
th-cam.com/users/c...
Keywords:
example of select query in ms-access,
select query in ms-access,
ms access sql query examples
types of queries in ms access with examples
how to create query in ms access,
what is query in ms access,
how to create a query in access with criteria,
types of query in ms access,
How do I select a query in MS Access?
How do you write a select query?
What is select in MS Access?
What are the 3 types of select query?
How to create select query in microsoft access,
Query in Ms access,
Query tutorial in ms access
How to find the first record in microsoft access,
How to find the last record in microsoft access,
microsoft access toturing,
microsoft access tutorial,
microsoft access tutorial for beginners,
#microsoftaccess #microsoftaccesstutorial
#Query

[@marycruz2628]

MARAMING SALAMT! SIR

[@EdcelleJohnGulfan]

Welcome. I hope nakatulong sayo.

[@marycruz2628]

@@EdcelleJohnGulfan sir pano pala kapag ung table ko is hindi ganon sa inyo na nakahiwalay ung tatlo bale kasi ang nilagay ko sa table "Type" lang andun na ung tatlo. Pano po un?

[@EdcelleJohnGulfan]

@@marycruz2628 tulad ng nasa picture mo? Split natin pero walang split function sa query. Vba code gamitin natin.

[@marycruz2628]

@@EdcelleJohnGulfan Pwede maisama sa tutorial sir? Maraming Salamt

[@EdcelleJohnGulfan]

@@marycruz2628 ahhh nakita ko email mo. Bali crosstab query gamitin. Hindi split. Next time gawan ko ng tutorial yam.

[@johndelacruz9561]

Hello sir. ask ko lang po paano i-separate ang yes/no in two fields sa query para ma-count ko separately kung ilan ang Yes at ilan ang No sa mga items na nadeliver. Maraming salamat po.

[@EdcelleJohnGulfan]

Try this.. and use COUNT FUNCTION for the value. th-cam.com/video/N1AqUow40_0/w-d-xo.html

[@johndelacruz9561]

@@EdcelleJohnGulfan Maraming salamat po.