Search results

Hello All! This is probably a really silly question but.... I cant seem to get my head around something. If you have a database that contains a table of costs for say materials, which are updated say yearly but you want to keep all records inputed at the previous cost without updating them...

Hello Everyone. Can anyone tell me what to do when it comes to queries. I have a table of products and these products prices can change at anytime. Basically i want the prices to stay the same for claims already raised but anything created after that point is set as the new price. To say it...

Hello everyone, I'm a bit stuck with creating a report. I only want to show the results from whats selected from the main search and the comparison from the form listbox (frmAdvancedSearch). I've attached my database if anyone can help. I have 2 searches on one form so that the user can...

Hello! I've been trying to create an Annual leave calendar database (struggling a bit) I'm try to set up a database for people who work shift and annual leave is calculated in hours? I’ve set up a database that has general data; next of kin etc., but want to add the holiday/sick days to this...