Search results

thanks for your reply but unfortunatly this isn't working. Do you have any other ideas?

I have a table that has the fields Scheme no, Title, Area, Pole No, Rate No, Description, Quantity. Each Scheme No has a number of Poles attached to it, and subsequently each Pole has a number of different rates attached (eg of table shown below) On the corresponding form I have ID No, Title...

I need to be able to use a combo box on a form to filter the records shown. The fields on the table are as follows: ID No, Ref No, Start Date, Comp date, Price etc. I have set the form up to run off a query that shows all records with a certain ID No. Each ID No has a number of reference...

I need to be able to monitor when staff are On Site, when they are on holiday, or sick or in training and a number of other criteria. The thing is due to the high amount of staff here and the nature of the job there will be an absence of some type or another every single day

Basically there is a field for each date. In that field is the status of each employee (ie On Site, Holiday, Sick etc). I need the user to be able to type in a date (ie search for the corresponding field) which would then display the total the amount of staff for that day that are On Site...

At the moment I have a table for personal details with a unique staff ID and then other tables for each month which has fields for the unique ID and then fields for each day of the month. If I didn't have different tables for each month then there would be massive amounts of fields within the...

I understand where your coming from sergeant. I need to be searching on a daily, weekly and monthly basis so are you saying I should have a field for every day of the year in the same table, I am wanting to run this until the end of 2007 so that would mean a lot of fields in one table

I have set up an attendance database with tables for each month. Each of these tables has its corresponding form. I want to be able to add a command button onto the forms to add a new record. Obviously this is easily done using the wizard but my problem is I want it to be added over a number of...

I have a number of tables all with there corresponding forms. I am needing to have a command button on the form for the user to easily add a new record. Obviously this is easy by just using the wizard but my problem is that I need the record to be added over all the tables. This is an...

I have designed an attendance database, with fields for personal details and fields for the days of each month. I need to have a query that will ask for a certain date(i.e. find the specific field) and then search on specific criteria (i.e. ON SITE) to see which staff are available. What is...

Thanks a lot guys everything is sorted now!

The question is how can I use excel functions in access. For example I use the excel formula =IF(C1="Finished",A1,"") to show if C1 is marked as finished this cell would contain the data in cell A1 Any ideas how I can do this

I need to be able to use some functions available in excel in an access 2000 database. These include SUM and IF functions. If any one can help me figure out how to do this any help help wouold be greatly appreciated