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...

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...

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

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...

Hi Team, I have created utilization table where i have calculated columns like Total Availability of student seats in a preschool and for that i have used Capacity and strength column.So availability will be Strength-Capacity. Capacity is constant but strength will change every week. Like wise i...

Hi Team, I have a form containing two columns named strength and Capacity and i have a third column named Conversion RFation which will calculate the percentage for Capacity utilization and the formula i have put there is: [Strength]/[Capacity]*100 but above formula showing #Name? error.Pls...

Hi Team, Currently i am working on a student database in access.I have a requirement where i have to write a query with combination of two columns in access and that too one number field and one text field. Eg:One column contains student id like 1,2,3,4,5 etc and second column contains centre...

Hi Team, I have a textbox and combobox in my access form.I want that textbox should be hidden bydefault on opening the form. When i select a particular item from Combobox then only it should be visible. otherwise not.Pls help me out. Thanks Aparna

Hi Team, I am creating an enquiry form in access. For enquiry followup i need two columns enquiry followup date and enquiry followup remarks these two columns i need 3 times in form. One time followup1 then second time followup2 and third time followup3. i need a button actually after clicking...

Hi All, I am creating a form in Access in which i am inserting two comboboxes named cboCentre and cboCorporate and they are dependent comboboxes like corporate value will be dependent on centre selection. Problem is that i am not having any field incommon in these two tables. centre having...