S
Susie
I have serveral tables
1: Invoice table
Fields, Inv. #, Date Truck,Type,Contract,zone, over-zone,
2. Truck List Table
Fields: Truck, Type, State
3. Master Rate Table
Fields: Contract,Zone,Type,Zone Rate,Drv.Rate,Over-zone Rate
I am trying to make a Querie to bring all of this together,
Tables in Query: Invoice Table,Truck List Table and Master Rate Table
I do find with just show the fields. But i need several caculate fields When
i ask it to Expr1: IIf([Invoice]![Zone]=[Master Rate List]![Zones] And
[Master Rate List]![Type]=[Invoice]![Type] And [Invoice]![Contract]=[Master
Rate List]![Contract],[Master Rate List]![Zone Rate],0)
it will work. but then i need it to do this also
IIf([Invoice]![Over-Zone]=[Master Rate List]![Zones] And [Master Rate
List]![Type]=[Invoice]![Type] And [Invoice]![Contract]=[Master Rate
List]![Contract],[Master Rate List]![Zone Rate],0)
-- this is to show me what the over-zone rate is. both field become blank.
i tryed to so a relationship between the table zone to master table zone that
works but when i try to show that table over-zone is also linked to the
master table zone. it gives me an error. can you link two fields in the same
table to one field in another? I have tryed to make a knew table for just
over-zone rates zone,type contracts,zone rates, driver rates, but when i
bring that table in to do the cauclation i need it will show the records
twice once with just zone rate and once with the over-zone rate. is there a
way to tell it i want to show the zone rate in the same recored.. I any of
you can help that would be great. or if you know of someone that does this
kind of a thing it would be great i can not find anyone in this area that
works with the 2007. We are in the merced, ca area.
SusieQ
1: Invoice table
Fields, Inv. #, Date Truck,Type,Contract,zone, over-zone,
2. Truck List Table
Fields: Truck, Type, State
3. Master Rate Table
Fields: Contract,Zone,Type,Zone Rate,Drv.Rate,Over-zone Rate
I am trying to make a Querie to bring all of this together,
Tables in Query: Invoice Table,Truck List Table and Master Rate Table
I do find with just show the fields. But i need several caculate fields When
i ask it to Expr1: IIf([Invoice]![Zone]=[Master Rate List]![Zones] And
[Master Rate List]![Type]=[Invoice]![Type] And [Invoice]![Contract]=[Master
Rate List]![Contract],[Master Rate List]![Zone Rate],0)
it will work. but then i need it to do this also
IIf([Invoice]![Over-Zone]=[Master Rate List]![Zones] And [Master Rate
List]![Type]=[Invoice]![Type] And [Invoice]![Contract]=[Master Rate
List]![Contract],[Master Rate List]![Zone Rate],0)
-- this is to show me what the over-zone rate is. both field become blank.
i tryed to so a relationship between the table zone to master table zone that
works but when i try to show that table over-zone is also linked to the
master table zone. it gives me an error. can you link two fields in the same
table to one field in another? I have tryed to make a knew table for just
over-zone rates zone,type contracts,zone rates, driver rates, but when i
bring that table in to do the cauclation i need it will show the records
twice once with just zone rate and once with the over-zone rate. is there a
way to tell it i want to show the zone rate in the same recored.. I any of
you can help that would be great. or if you know of someone that does this
kind of a thing it would be great i can not find anyone in this area that
works with the 2007. We are in the merced, ca area.
SusieQ