Hi all. I have an Access 2003 form based on a query (myQuery) that has the following fields:
A quotenumber will have 5 carriers of which one is awarded (Awarded = 1) the others who are not have Awarded = 0.
I currently have a form that displays the records based on the query (myQuery), the form header has a DLookup formula which only displays the awarded carrier (=DLOOKUP("Carrier","myQuery","Awarded = 1")
But in the detail section when I do (=DLOOKUP("Carrier","myQuery","Awarded = 0") it only shows one carrier 4 times (one for each unawarded carrier). How can I make the other 4 unawarded carriers appear in the detail section? By the way the default view for the form is "Continuous Forms".
Thank you in advance!