Search results

Tanya If you look on top right i put a text box there,what i need to do is look for a jobcard no.I want to go directly to the jobcar no...You will see below payments there is a jobcard no,,,i need to search for a particular jobcard no in the subform...one client can have many jobcards..I hope...

Thanks Tanya...It looks like what i want Thanks again hamish

Please can anyone help,I have attached sample database.I need to search for jobcard no.My main form is customer and one customer has many jobs i need to go to that job no,,,,,hope someone can help,,,i am new on this access...

Hi ChrisThanks for your response ,i been working on this project for a while and cant get the relasionship right,,I have attached a sample can you change it for me and i will upload it from you and check it out,,My mind just went blank

have a table with three fuel tanks,(example diesel,ULP LPR) then i have a table for the Pumps example (pump1,pump2,pump3 and so on,they extract the fuel from the tanks.The tanks have a daily open and close reading,And the pumps also have a open and close reading.I have attached a sample

Thanks for the answer,,,but how would i do that...i am still new at access.

i have a form customers,subform rates,subform rate transactions,,, In my rates transaction i dont want duplicate months eg 01/12/08,,,meaning one transaction per month I dont know if this makes sense