I am using access 2003. When attempting to use the wizard to create a new query or report, having identified the table/ query, the fields of the said table/query do not display. I am obviously missing a component file. Can anyone advise me?
Until recently I have had no problem using wizards to create queries etc. Now when i attempt to use a wizard and identify a table as the source, the data in the table is not presented for my choice of fields. help!
I have a table in Access 2003 which has a field "First Name" and a field "Surname". I wish to create a new field in the same table, "Full Name", which combines the other two.
How might I do this?
I am building a query in Access 2003. I have two tables, A and B. Table A contains a list of schools. Table B contains a list of educational courses and one field is a lookup field which looks up the name of the schools in Table A to show what courses are being run at every school. In my query...