hi mr. guido,
i've edit the images and it can be viewed in the above question.
thank you in advance :)
miss D
Last Activity: Jan 11 '11, 11:33 PM
Joined: Aug 23 '10
Location:
-
How to group similar data?
Hi,
I have this report which has these fields in Excel.
How can I group the rows which has similar Mgr Email Addr? using Excel macro or VBA..
The grouping must be done this way..(it highlight the same group)
can someone help me?
thanks in advance... -
How to do Browse button to select Excel file then link it to Ms Access?
How to do Browse button to select Excel file then link it to Ms Access as external database?
can anyone help me with this
im creating an automation system in Ms Access and need to use external database in Excel to be linked to Ms Access
Thanks in advance -
Access SQL to combine two queries into one single table
I have run 2 queries in Access which has the same field names,
Qry1:
Mgr ID
Mgr Name
Qry2:
Mgr ID
Mgr Name
how do I combine these two queries into a single table?
Please help me with the code.
Thanks. -
how to create crosstab table using two queries in Access
hi,
i have posted this question here, regarding Access SQL
i believe someone here is good in SQL. anyone can help me?
http://bytes.com/topic/visual-basic/answers/894647-access-vba-how-create-crosstab-table-using-two-queries#post360 2456
thanks in advance. -
alright.
thanks for your replies :)Leave a comment:
-
for the count part, i have no problem
as i already generate the query to count number of employee that manager has.
the problem is how do I define my own column named GAR 1 until GAR 6 to feed the employees names. followed by GAR 7 untill GAR 12 for years of service for respective employees.
Can u help me?
Thanks in advance...Leave a comment:
-
not yet..
how can i do that?
can u help me with the code?
i am a newbie in vba..Leave a comment:
-
How to rewrite exported Excel file from Access query
Hi,
I have Access button with this command:
DoCmd.TransferS preadsheet acExport, acSpreadsheetTy peExcel9, "MYS", "C:\SERVICE AWARD PROGRAM\REPORTS \reports.xls", True, "MYS"
It transfer Access query named 'MYS' to an Excel file name report.xls.
Everytime I click the button, I want to rewrite existing report generated previously.
How can I do that? Right... -
Access VBA: how to create crosstab table using two queries
hi,
I have two queries, named:
1. Q1, which has columns name
Mgr ID, MGR_Name, Empl_ID, Empl_Name, Years_of_Servic e
and
2.Q2 which has
MGR_ID, EE count
both queries have 1:1 relationship for MGR_ID
Using this two queries, I'd like to output a table like this:
The empl_name with respective MGR_ID will be automatically feed to columns named GAR1... -
Thanks all!
The pop up works fine with me!Leave a comment:
No activity results to display
Leave a comment: