ET: Crosstab Forms and Reports, by Dale Fye - Access ET

Crosstab Forms and Reports Dale Fye ( Dev-Soln.com ) 16 October 2020 AccessUserGroups.org ET (Eastern Time) chapter lead by Dale Fye 3rd Friday at 9am ET -- join us! 0:16 Why use Crosstabs? 0:45 Crosstab Issues 3:42 demo 3:48 Access database 4:14 employee sales for 3-month period 4:35 what the employee sales table looks like 4:57 use menu to generate crosstab query 5:09 crosstab query design 5:48 if you have more than 255 columns, get error 6:04 limit columns 6:20 make a datasheet form 7:12 downside 7:45 logic to make a datasheet for crosstab queries 8:30 controls are unbound 8:42 execute code to bind controls when load 9:20 hide controls since might not have that many fields 9:44 loop through recordset, set caption, visible, control source 10:20 when loaded, datasheet rapidly adjusts the columns 11:00 sometimes have control where record doesn't have value for field using as column header 11:24 hide that control 11:47 set focus to first element 11:55 Freeze Column 12:05 when scoll left and right, name column stays in place 12:17 right-click menu for column 13:35 freeze multiple columns 14:08 takes a lot of work to build the datasheet form 14:46 popup form to generate data 15:09 subform on mainform with display options 16:03 continuous form 17:21 left/right buttons to jump one week at a time 17:31 jump to end or back to beginning 17:37 make a query the source object for a subform 18:54 advanced crosstab 21:09 assign function to double-click event of control 22:21 change from Sum, make it Count 24:20 gaps in data 24:50 Tally table of numbers 26:46 query for dates using DateAdd 29:08 Holiday table 30:02 create 100 days of dates using a query 30:18 cartesian join 31:17 use query to fill in gaps for the dates 33:38 use Sum, Count or Average 34:35 function for first day of the week to group by week 35:04 Format to group by year and month 36:45 change source object 38:38 Report 41:14 code in the Open event 43:04 an option is to use DateDiff so fieldnames don't change 45:18 make query with fixed start date SUBSCRIBE for MORE videos! ► https://bit.ly/AUGYoutube REGISTER here ► https://bit.ly/AUGSQL to our virtual chapter! ✓ Join our online Access User Groups with free membership. Monthly webinars on the latest topics: MS Access, MS Access with SQL Server, etc. ► Facebook ◄   / accessusergroups     / msaccesslatinoamerica     / accessespana     / augpowerapps     / auglunchtime     / augeasterntime     / accesswithsqlserver   ► Twitter ◄   / accessusergroup     / augespana     / msaccesslatino