Search results

Hi, appreciate if anyone can help on pivot table. I'm working on employee leave schedule (sample data below) and want to present it as a spreadsheet. cheers 21 Aberdeen EmpID Date_From Date_To Lv_type 2002516 09-Jul-16 09-Jul-16 Annual Lv 2002516...

HI Paul, I need your assistance/learn to put my database in Sharepoint to achieve some success. I was using shared drive/local server and now have to use SharePoint for others in different areas to access it. Problem is users could not open the file placed in sharepoint directory/folder. Thanks

I need help in crosstab query output to generate employee leave records calendar (transpose)with below data field/type . Name Date_From Date_To Lv_type Barney 07-Nov-13 10-Nov-13 PL Sarah 11-Dec-13 12-Dec-13 AL Scott 22-Nov-13 28-Nov-13 R&R Steven 13-Dec-13 19-Dec-13 R&R Thank you

Hi Currently I'm using crosstab query with "wK" across the top Expr1: "wk" & DatePart("ww",[PC_Date]) I need help to do other queries to generate result as; 1) show week ending date 2) Fortnightly instead of weekly 3) Period reporting by select date from and date to Thank you 21Aberdeen

Thank you Alex, today I learnt something valuable from you. Cheers

Thank you Alex, Can you show me how this to be done, preferably in query design format please.

Hi I hope to get help in how to combine 3 cross tab queries values into one daily progress report, transpose format. The values from each crosstab query are 1) Spent hours 2) Qty installed 3) Earned hours. Attached are screenshots of the queries. Thank you:)

CJ, I'll stick to "wk.." column header as it is the norm. L4 description actually are event activities, each requires bigger column width. When progress at peak, it will be more than 52 columns. I'll get around with reporting in separate pages when I get there. I may use your above example...

Thanks CJ I could not get it to work.... apprecite if you can correct my actual code below (switched view from pivot table, screenshot is attached). ............................. TRANSFORM Sum([DailyTimesheet Query].Spent_Hrs) AS SumOfSpent_Hrs SELECT [DailyTimesheet Query].[L4 Description]...

Thanks CJ its marvelous. I've added more records and will continue adding daily until the project is completed. The query shows all new records as I update it. BUT my subform and report did not picked up the new input whereas the source is from query table. Did I go wrong somewhere...

CJ In cross tab query, can the column heading Pivot DatePart("ww",[MyDate]) currently showing 1, 2, 3 etc. be changed to wk1, wk2, wk3 instead. Thank you for your advise.

............................... Thank you CJ London, I appreciate your promtness. This helps me to generate graphs and relevant reports. 21Aberdeen

Hi I need help in query of daily activities spent hours 1) to be group as weekly total 2) then need to transpose it for reporting. My table fields are Date, SpentHrs and Code (activity code description). Appreciate for your help Thank you 21Aberdeen

Hi, merry christmas to all I'm based in QLD Australia, came from Singapore in 2006. I've been using Access for some yrs, wrote system applications (customised) for construction project controls and management etc. I'm still learning and hope to master the power of DBase to improve my work...