M
mvpejp
Hi all, I really really hope there is someone that can help. In access I
have two tables: Accounts -- Calls.
Within Accounts the fields are: ID, BizName, Address, City, Phone, Contact
Within Calls the fields are: ID, Type of Call (chosen from
selectable), calldate, and outcome
I have created a Form named "frmMain" which is linked to the Accounts table.
On this form in enter my data for each account. What I would like to do is
to be able to log every phone call made to an account in the Calls table.
1) How do you recommend I do this (subform? if so how is this done)
I also want to be able to analyze my data on all calls made. Ultimately I
would build three queries, "qrytotal" (total calls made), "qryoutcome" (of
all calls what were the outcome totals", "qrycalltype" (of all calls what
were the totals of the types of calls).
I would like to take this data from the queries and export it into an excel
sheet on my desktop which we will call "atest.xls".
2) Could someone please recommend to me the best way for me to extract this
data into my excel sheet.
Thank you in advance for your assistance.
have two tables: Accounts -- Calls.
Within Accounts the fields are: ID, BizName, Address, City, Phone, Contact
Within Calls the fields are: ID, Type of Call (chosen from
selectable), calldate, and outcome
I have created a Form named "frmMain" which is linked to the Accounts table.
On this form in enter my data for each account. What I would like to do is
to be able to log every phone call made to an account in the Calls table.
1) How do you recommend I do this (subform? if so how is this done)
I also want to be able to analyze my data on all calls made. Ultimately I
would build three queries, "qrytotal" (total calls made), "qryoutcome" (of
all calls what were the outcome totals", "qrycalltype" (of all calls what
were the totals of the types of calls).
I would like to take this data from the queries and export it into an excel
sheet on my desktop which we will call "atest.xls".
2) Could someone please recommend to me the best way for me to extract this
data into my excel sheet.
Thank you in advance for your assistance.