Search results

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

I tried but not happening:banghead: Pls pls help me step by step I will give u the column names of my table Table name is Enquiry_Form Columns are Enquiry_Form_No,Enquiry_Date,Centre_Name. Centre_Name is a lookup table connected to Centre table. My query is I need total enquiries (weekly...

Sorry but i am very new to access.Can u pls explain in a simpler manner. Thanks Aparna

Hi Team, I want to generate a report for enquiries for a daycare centre. I want to capture total enquiries count and percentage per centre. Centres are like W1,W2,W3.......W10. I want separate count for all the centres. Pls suggest how to do this. Thanks in advance Aparna

Hi Team, I have a query regarding Date validation in access. I have a field called Enquiry date and the criteria is that the user should be able to select dates past 15 days only beyond that the system should not allow dates to be selected. Further the user should not be able to select the date...

Hi Team, I have a Query table containing columns Centre,Capacity of a Centre that is a fixed value,Strength of a centre that will change every week,Then i require sum of Capacity and strength column. Now i need to calculate Availabity per centre of seats and Conversion ratio:banghead:Here only...