Recent content by Sudha

I am sorry, by "total" i meant the totals toolbar button

Hi, I have a query which uses the "Total" in its row. using that i find the sum of cetain fields. now if there are no records to return for the query I would like to get a blank record to be returned. I know when "total" is used it doesn't return blank record. how can I get it done? Sudha

hi all, Thank you very much. I used the dlookup and it is working fine. thanks again.

Hi, I have a query which needs to find the value of GeneratorKVA. I have two other fields in the query, total elec load in kVA and required kVA. Required kVA is calculated as Required kVA:[total elec load in kVA]/.8 if Required kVA = 0, then Generator kVA=0 if Required kVA>0 and <=20 then...

Hi, How do I round values to the next multiple of 5, but if the value is a multiple of 5 then it should return the same value.

Hi, I have a form for a table which is used for data entry. the default value for some of the fields on the form are set to ="" because highlighting the"0.00'' every time and entering values were difficult for the user . now if the user doesn't enter any value in these columns I need to get zero...

Hi, I have a form for a table which is used for data entry. the default value for some of the fields on the form are set to ="" because highlighting the"0.00'' every time and entering values were difficult for the user . now if the user doesn't enter any value in these columns I need to get zero...

Hi, I have a form for a table which is used for data entry. the default value for some of the fields on the form are set to ="" because highlighting the"0.00'' every time and entering values was difficult for the user . now if the user doesn't enter any value in these columns I need to get zero...

Thank you!

Hi, I have a form where the user uses a combo box to make a selection and the corresponding details are displayed. While creating the combo box I chose the third option i.e "find a record on my form based on the value I selected in my combo box''. I am using this form for an Edit button. here...

Thank you.

Hi, I have a form with a combo box where the user selects the required Project. I have a Report button on the form. how do I get the report based on the selection in the combo box. currently my report shows all the Projects. I want a report only for the project which is selected.

Hi, I have a table with room details, i.e length and width for various room like UPS room, equipment room, guard room etc. I have a form for this table where the user has to fill in the length and width. Each time I open the form to add a new record, the first record is displayed. I want a blank...

Hi, I have a switchboard with the first button for open form in add mode. I want the switchboard form to close also when the button is pressed. How do i do it?

Thank you very much.