Search results

Hello, I made a report with following crosstab query. TRANSFORM Workersdetail.workername AS CountOfedate SELECT Workersdetail.[attendance], Count(Workersdetail.[edate]) AS [Total Of edate] FROM Workersdetail GROUP BY Workersdetail.[Workername], Workersdetail.[attendance]...

Hello, I made a report with following crosstab query. TRANSFORM Workersdetail.workername AS CountOfedate SELECT Workersdetail.[attendance], Count(Workersdetail.[edate]) AS [Total Of edate] FROM Workersdetail GROUP BY Workersdetail.[Workername], Workersdetail.[attendance]...

Hello... I need help with regard to making query I have a table which field followup hereunder. Name | Registration date | Category Test | 01.03.13 |1 Test1 | 02.03.13 |2 Test2 | 02.03.13 |2 Test3 | 02.03.13 |1 i wanted retrieve data as follow...

Perfect!!! Made a mistake with bound columns Thanks alot with best wishes

Hi guys, I have a listbox inside name of workers which is coming from table (Workersdetail) on the otherside I have report from the same table which still showing all records of worker, this report execute through the form and by selection of listbox values. Please look into my following...

Its OK I made it. I have putted PIVOT WorkerDetail.entreetime in (0900,1000,1100). Thanks alot and have a nice weekend Ben

Hi, Indeed your every reply make my access knowledge upgrade, thanks alot for your replies. Problem is I wanted to put timings as default like heading: 0900-1000-1100-1200-1300-1400-1500-1600-1700. thats why I made table timing which contains timing 0900 to 1700. I want whatever the worker...

Hi, I would much appreciate if I could get some advise regarding following query. I am making some attendance sheet on access as follows Name !09:00!10:00!11:00!12:00!13:00!14:00!15:00 ------!-----!------!-----!------!-----!------! Test1 !Prsnt! ! ! ! ! ! test2 !Absnt! ! ! ! ! ! test3...

Thanks alot for whatever your help. Take care and have a nice day

Hi, I would much appreciate if I could get some advise regarding following query. I am making some attendance sheet on access as follows Name !09:00!10:00!11:00!12:00!13:00!14:00!15:00 ------!-----!------!-----!------!-----!------! Test1 !Prsnt! ! ! ! ! ...

Thanks a million

Well done... Thanks alot. I have just 2 last problems, Problem 1 On my form transaction there is field "Namepick" where the names coming through query "workers query" from table "workers". I also added command button with the namepick combobox, incase of name does'nt exist then...

Thanks for the reply. No, its not working, I typed this =DSum("[entree]+[sorti]","Transaction","ProductName = '"[forms]![transaction]![productname] & "'") its given me error "The expression you entered contain invalid syntax, you may have entered an operand without an operator" Please advise Ben

Hi guys Greetings from Geneva, I am new in MS Access and I have a situation, seeking your kind help. I have 2 table as follow. Productmaster -Productname -Opening date Transaction -Productname (linked with master productname) -qtyin -qtyout I am working on Form transaction1 linked with...