I
Ian
I have a table names services with the fields ClientID, ContractName,
ContractNotes
I would like to be able to compare the notes from two different contracts
(year to year comparison). I'd like the user to be prompted to [Enter Name
Contract 1] and [Enter Name Contract 2] and have the results show:
Contract 1 Contract 2
ClientID Notes1 Notes2
ClientID Notes1 Notes2
ClientID Notes1 Notes2
etc etc etc
Can someone tell me how to do this. I think it's a crosstab or union but I
don't I can't it to work. Thanks. Ian.
ContractNotes
I would like to be able to compare the notes from two different contracts
(year to year comparison). I'd like the user to be prompted to [Enter Name
Contract 1] and [Enter Name Contract 2] and have the results show:
Contract 1 Contract 2
ClientID Notes1 Notes2
ClientID Notes1 Notes2
ClientID Notes1 Notes2
etc etc etc
Can someone tell me how to do this. I think it's a crosstab or union but I
don't I can't it to work. Thanks. Ian.