G
Guest
In a query is it possible to not input any data into a field wich is the link
to another table. For example. In my query i have adn employee ref (Ee) and
by inputing a reference into this cell is pcks up the employee name from
another table. There are 10 employee ref's on the query so sometime i don't
need all the cells if there are only 5 employee for example, so i wish to
leave them blank and when i try to do this it give an error message, is it
possible to leave these blank with no error. The message is that there is no
matchin data in the Microsoft Jet engine for the feld which has no data.
to another table. For example. In my query i have adn employee ref (Ee) and
by inputing a reference into this cell is pcks up the employee name from
another table. There are 10 employee ref's on the query so sometime i don't
need all the cells if there are only 5 employee for example, so i wish to
leave them blank and when i try to do this it give an error message, is it
possible to leave these blank with no error. The message is that there is no
matchin data in the Microsoft Jet engine for the feld which has no data.