Search results

Hello everyone I am just trying to write a query by a code of table i would like to pick up any record with id number betwee 1-99 and 200-299 i try typing them in manually but access wouldn't cope any idea of how i can achieve it please Many Many Thanks Si

Hi everyone I have a part of the form with the following fields Title Name Address1 Address2 Area ... Address2(street) field is a drop downbox, once selected the area text field will be automatically shown what I got in AfterUpdate event on Street is as below Me.txtArea =...

Hey there there is a function that I wanted to do on my form but can't think of a way what I want to do is to show up a flag after 14 days and 28 days of a date with missed appointment being ticked say there are two fields in the section AppointmentDate Missed Will I be able to do this in...

Hi everyone, I am having a bit of problem here, I have a sub form which listed all the calculated equipment cost For this I created a query to sum up all the cost field in the sub form I want to show the sum of those field on the Main form? As the control source of the main form is a table...

Happy New Year Everybody Can Anyone help me with this please I have a Employee Table with the following columns EmpID Name Address Telephone PostCode Spending What I want to do is to update the spending column, for eg. I have the following data in spending 1233 1555 1665 I want to set the...

Happy New Year Everybody Can Anyone help me with this please I have a Employee Table with the following columns EmpID Name Address Telephone PostCode Spending What I want to do is to update the spending column, for eg. I have the following data in spending 1233 1555 1665 I want to set the...

I am having a large table like below Employee_Record Log FirstName Surname Gender DOB LogIntoBuilding LogOutBuilding What I want to do is to creat a Employee table like below ID FirstName Surname Gender DOB which will be separated out from Employee_Record table while automatically creating a...