Recent content by Judd123

Hi i am trying to make an update query that will put peoples "first_name" and "surname" (in teh same table but seperate columns) into one column to give me "first_name,"surname" as one. I have been told to use an update query but i cant make sense of all the help on the internetAnyone with any...

Thanks for the reply, The reason I am doing this way is because i have already made a form and in that form i have a button that relies on "Cadet_Name" which will then open a new form with a "Cadets" details and information Is there no way of building an even in the table that will automatically...

Hi, I have got data in an excel spreadsheet and i have imported it into a table i have in my database. The data i have imported has peoples "First Name" and "Surname". So they are both in my database in 2 separate columns, however i need them to combine into one column "Cadet Name" e.g., Judd...

Thats Brilliant,Thank you very much for your timemuch appreciated.Chris

Hi, thank you for the reply,If i used Switch () in VBA, what do i put in the brackets as the "ParamArray" would it be the "Cadre_Score" from my test scores table? bit vague i know.. sorryThanks.Chris

Hi,Im trying to make a database for a client and i am stuck on how to convert scores for a test to pass, merit etc to be viewed in a report, I thought it might have to be done by making a query then make a report from that query.Any help would be much appreciatedThanks

Thank you both for your sugestions, i will try them both and see if i can get any further in my projectMuch appreciatedChris

Hi,Im trying to make a database using the Tab Control. Each tab has data from a different table and they are all linked by Cadet_ID. After I make a combo box which "find a record on my form based on the value I selected in my combo box" (Name).It works when there is the data from one table but...