Search results

im doing a garden centre. And i don't know what else to put in. my database comprises of very little at the moment. and im worried that it won't be sufficeint to hand in. i have TABLE Employer Employee Employee Roster Members Borrow Borrowed Items Item Queries main booking link Ascending...

i have this form. that has a combo box. when you click on it a list comes down with all the names of people and their id. i need to be able to select their details. i have done this before but i have forgotten please could somebody help.

when i was trying to work out how to use a query and there wasn't a value (nz function) that means you need to use the nz function.

when i was trying to work out how to use a query and there wasn't a value (nz function) that means you need to use the nz function.

could anyone help me i need to find out what i need ot put in a rental service project. Because im doing a garden centre that loans out tools. for my as project. so i need to know what to put in it.

I Know who you are!

todays date would be date() put =date() in the default value

its ok i know how to do it now.

I Was Wondering. how do i work out the age of someone with using their date of birth?

thanks

does anyone know if there is a database example that would allow me to compare with my database? im doing a garden centre that loans out items. i need to see if i have missed anything out!

I'm doing a garden centre that loans out equipment. i was wondering if there was a database that i could compare with mine?

ok im really stuck now. i have found out about this nz function from the access help. it says something about Nz(varX). where do i enter this then? do i create a new field in my qry? please help. if possible could you tell me how

Me and my teacher figured out a way of calculating number of hours from hours worked. but when i try to calculate all hours worked it doesn't add up because i have got null values. my qry. employee id max hours a week (what they want to work) monday start monday finish monday total (monday...

what would i start off with? i have enterd the data into a table. all of this is in a table at the moment. monday start monday finish monday hours and at the end i have hours worked. how could i calculate hours worked? could you tell me how to do it please. im in desperate need of help.

i need to have a roster for my staff. i have included the fields. employee id max hours week monday morning Monday evening Tues morn tues night wed morn wed night thurs morn thurs night friday morn friday night sat morn sat night hours a week how could i calculate how many hours somebody...

how can i get the amount of days that have passed. i have a database and i need to know how many does something has been booked out for. any help please?

i'm the best

Also I Would like to include a field that tells me how many days it has been expired for. if anyone knows how to do this then please let me know

it would be brilliant if it could be for today. thanks for the help