Search results

Hi, I'm not that great with Access but would like to ask for some advice. I have 3 tables all linked with an ID number (one to many) I create a query which I want to display the notes field from each of the 3 tables for each personID.. The problem is that say in one of the tables the person...

Hi me again I have a form which is populated with data on a student. Problem is I want to add a textbox which displays the students surname, but that surname is located in another table called students. I tried selecting the table and field in the data source for the textbox, but I just get a...

Hi I'm trying to search for a surname on a form from a table called students. I want the result to goto the record on the form. The tablename is Students and the field I want to search is called Surname I wrote this code: Dim Search As String Search = InputBox("Please enter the Surname"...

Hi there, I'm trying to write a query that will display "NA" if there is no End Time but if there is an end time then display it as normal. The problem I'm having is that if there is no End Time then I get an #ERROR appear in the record. Here is the query: Expr1...