Christopherusly
Village Idiot.
- Local time
- Today, 14:46
- Joined
- Jan 16, 2005
- Messages
- 81
I have a query based on two tables.
Table one gives a list of staff time transactions i.e. hours spent on a particular job. Table two gives a list of the staff rates, so enable project costs to be calcuated - hence there is a relationship between the Staff Name fields of both tables.
IF i do not have rate for a member of staff in table 2 that appears in table 1, rather than display the record with a 0 value against it, it does not display the record at all.
Q: is there anyway to get round this ... ? without having to check the table 1 each time for matching it against table 2.
thanks guys.
Table one gives a list of staff time transactions i.e. hours spent on a particular job. Table two gives a list of the staff rates, so enable project costs to be calcuated - hence there is a relationship between the Staff Name fields of both tables.
IF i do not have rate for a member of staff in table 2 that appears in table 1, rather than display the record with a 0 value against it, it does not display the record at all.
Q: is there anyway to get round this ... ? without having to check the table 1 each time for matching it against table 2.
thanks guys.