Search results

Once again you have saved my bacon, I really couldnt understand how access could not have any round Feature... I think the Tutorial on using Excel functions in access is a little beyond me for now but i got the Built in round Feature to work no problems and does what i need ..... number\1...

Thanks Guys.. It does indeed Work Fine... Another problem Solved... :D

Cheers Guys, Just when you think your getting the hang of Access , along comes a problem and you find there is still Loads and loads of stuff you dont know about...thats what i love about access... I`ll Try and get my head round this ........ wish me luck !! Once again cheers !!:)

AMAZING.. I spend all afternoon pulling my hair out and then i post for help and then within 2 Mins Later i Remember how to do it ......... Go Figure lol anyway if any other newbies need the answer here it is.. Like "*" & [Enter Model] & "*" DOH!!:rolleyes:

I once wrote a database in Access for work that allowed you to Do a parameter search based on Model using a wildcard that allowed for any part of a model number to be keyed in and the query would pull out all the Matches.. for example i would run the query and the parameter box would pop up...

HI dcx, Thanks for the Reply... actually the part im stuck on is the part you skipped lol :p How do i Find out which records do not already Exist? i cant seam to figure this one out.. Im pretty handy at writing Queries.. but have not come across any way to cross reference the New Linked Excel...

we get model/Price updates in the form of Excel files, I have set up a database from these Excel files to make updating prices much easier.. I link the New Excel files in the new table and then run a simple update query to match the models and update the the new prices... But also on these excel...