Recent content by nickysquawkes

Thanks cuttsy for the advice. Actually managed to solve it myself by adding an is null statement in the query criteria.

I have a form that allows users to search the database for records based on there criteria. The form allows the user to search, through combo boxes, by variables. The first is MAT, the second is Relocation Area. The search works fine when the user selects options form the combo boxes...

I have already tried that. The problem with an udpate query is that you can only do blocks of items. E.G. People named "smith" change their pay to XXX. We have 900 people each with an id number and each with a different salary. If that makes sense. Unless I'm missing something?

I have a database with details about employees in it. There is a field with yearly salary in it and another with an ID number. Recently these slaaries have been increased by a non-standard amount. I have another table with the emplyee ID number and their new salary. I need to update the...

Thanks Brian. That has sorted it. There is method to the madness believe it or not

The other table holds details of that location. But it needs to be held in a separate sheet because the location details are linked to an Excel spreadsheet, which is updated on a regular basis

Hi - I have what maybe a relatively easy problem to solve. I have a list of locations each with a unique id. I also have another table with location details in it. There is a relationship setup between the two tables. However in the first table I have some locations that do not have a match in...

Hi - I have what maybe a relatively easy problem to solve. I have a list of locations each with a unique id. I also have another table with location details in it. There is a relationship setup between the two tables. However in the first table I have some locations that do not have a match...

Thanks anyway Ken. Can anyone else help?

This is the message I get.

Yes it does. It is the many side and the 1 side of relationships

Thanks Ken thats what I thought. Excuse my ignorance, but what does FK stand for?

I have a database with a table linked to an Excel spreasheet. I am trying to create an append query to load data from the linked table into a candidate table. Each record in the candidate table has a candidate number which is automatically generated and is the primary key. When I run the...