Join problem??? (attached file)

Steff_DK

Registered User.
Local time
Today, 19:33
Joined
Feb 12, 2005
Messages
110
Hi all :)
I'm trying to build a duty roster to get rid of my Excel spreadsheets.

Check the attached file and open the form.
The Query populating the listview doesn't perform the way it should.

What am I doing wrong?

Try selecting TPO or MC on the form, and the query will return "0"s even if there are no records with that label.
Selecting FA (the only query that should actually contain records) and it produces an error :confused:

Any help is higly appreciated! ;)
 

Attachments

Users who are viewing this thread

Back
Top Bottom