Search results

  1. B

    How to make report autoupdate with crosstab query

    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]...
  2. B

    Complex query

    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...
  3. B

    Report value not shown according to listbox value

    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...
  4. B

    How to make cross tab query

    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...
  5. B

    Total of specific selection not showing in textbox

    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...
Back
Top Bottom