Recent content by aparnawangu

Hi All, I want to generate a query in access where i want to calculate the percentage of conversion from the total nos. Foreg the total enquiries are 100 out of which 30 were cold so we dont require that only hot and warm enquiry conversion percentage i require. Pls help Regards Aparna

Hi Team, I have to design a report for a daycare utilization.I am attaching the format also. Pls help me out with the design. Thanks aparna

Hi Friends, I have a table called followup and i have details of enquiries in that like enquiry form no,follow-up No,follow-up date and remarks. I need that 1st followup done for how many enquiries,2nd follow-up for how many and similarly how many for 3rd followup. The query should be such...

Hi Friends, I need to create a follow-up table for daycare enquiries in access Enq_No(Auto No),Enquiry_FormNo(repetition can occur as we are doing multiple followups for a enquiry),Follow-up_Assigned ,Follow-up1_Duedate,Follow-up2_Duedate,Follow-up3_Duedate,Follow-up1 Remarks,Follow-up2...

Pls help me with the structure of followup table how it should be? as i am very new to access Regards Aparna

Hi Friends, I have a table called Follow-Up and the fields in that table are as follows: Follow-Up1,follow-Up2 & follow-Up3 Now i need a query which can determine how many total follow-up1 done,how many follow-up2 done and how many follow-up3 done in total probably for a week and month or for...

Hi Friends, I am building a query where i need to calculate Total enquiry follow-ups done by a front office executive. I have created three follow-ups till now and i have to capture that details. I am capturing following column details: Follow-up_Assigned...

Hi Team, I have a table called Follow-Up and the fields in that table are as follows: Follow-Up1,follow-Up2 & follow-Up3 Now i need a query which can determine how many total follow-up1 done,how many follow-up2 done and how many follow-up3 done in total probably for a week and month or for the...

Hi Team, I have created two tables in access named enquiry table and Follow-up status. There is one column called enquiry_form_no same in both tables. After then i created forms also called enquiry form and follow-up form.now the query is that i will enter the enquiry form number in enquiry form...

Hi Team, I have a table called Follow-Up Status and the columns in the table are Enquiry_Form No,Follow-Up_Needed,Follow-Up_Assigned_to,Follow-Up1_DueDate,Follow-Up1_Remarks Likewise Follow-Up2 and Follow-Up3. I have to create a query which should capture that how many follow-up1 are done...

We will gather info like no of enquiries for the month or week as per requirement and then we will check the admissions happened for that period so accordingly we can calculate the conversion ratio for that particular centre. I need to see the conversion ratio for all the centres from W1-w10 in...

Hi Team, I have a table called Enquiry_Form and i want to calculate the enquiry conversion ratio for 10 centres. The fields in the table are Enquiry_Form_No,Enquiry_Date and Centre_Name. For eg like 10 enquiries came for W1 centre but converted only 5 so that ratio i need. How to do that?Pls...

Hi Team, I have a table called Enquiry_Form table and i want to write a query for calculating total no of enquiries in a week. The columns in the enquiry table are Enquiry_Form_No,Enquiry_Date,Centre_Name. Pls help me in creating this query as i am very new to Access. Regards Aparna

I am not clear with the highlighted part what to write there.Pls guide me regarding that.I got the first query result but for next query how to use the result query there i am getting stuck. SELECT [Qry-DailyTotalInWeek].Centre_Name, Sum([Qry-DailyTotalInWeek].CountOfEnquiry_Form_No) AS...

Hi Team, I am ok with the queriws but can you pls let me know how to group first query result in second one. Thanks Aparna