Recent content by yaaara

  1. Y

    Help Required on Query Building in VBA

    Hi and thanks for looking at this thread... Unfortunately, the data in the Excel File is "As-is" and has not been manipulated and is the final output of my program (The one which I am actually using.. Only the data in blank fields have been removed...) I understand that it may be difficult to...
  2. Y

    Help Required on Query Building in VBA

    Hello, I have created a sample output for you to take a look.. Hope this would give you a better idea..
  3. Y

    Help Required on Query Building in VBA

    Sorry Dk, but this doesn't help.. Attached is a sample data which I need to be worked on... As can be seen, there are multiple lob's, categories and ltstatus' All the unique ltstatus' need to be converted in different columns as the sum of actions and sum of duration for each unique date...
  4. Y

    Help Required on Query Building in VBA

    Hi and thanks for the replies, I can't use the query builder as the columns I need to create originate from unique records within a table field (the ltstatus field) and so I won't be able to accomplish what i want.. I'm not sure if I'm able to explain it properly but I've tried in the first...
  5. Y

    Help Required on Query Building in VBA

    PS: Please if someone can resolve it today, I'd be highly grateful...
  6. Y

    Help Required on Query Building in VBA

    Hello, I hope someone can help me in resolving the following in access 2003: I have a table with the following fields: emp_id,emp_name,repdate,actions,duration,lob,categ ory,ltstatus emp_id is not unique and there appears to be no primary key for this table. the actions field stores the...
Top Bottom