Daveisalwayshere
Registered User.
- Local time
- Today, 13:30
- Joined
- Mar 14, 2014
- Messages
- 31
Hi guys,
I have a query called scaffoldTotalCostQuery that has all the costs associated with a scaffold tag Grouped by scaffold tag number. I am trying to add a new field in this query by adding a second query(called MiscScaffoldCostQ) to this. which also has costs associated with the scaffold tag this query acts the same everything is summed then grouped by scaffold tag number.
the problem I have is that there is always tag numbers in the ScaffoldTotalCostQuery however if there is no misc costs to a scaffold tag then in the MiscScaffoldCostQ there wont be a record so when i try to add the MiscScaffoldCostQ to the ScaffoldTotalCostQuery it removes all the records in the ScaffoldTotalCostQuery that doesn't have a record in the MiscScaffoldCostQ
Right now to get around this i have added a "default" button in my forms that applies a $0.00 to misc costs for each scaffold Tag. but i was wondering if there was a better way of doing this.
I have a query called scaffoldTotalCostQuery that has all the costs associated with a scaffold tag Grouped by scaffold tag number. I am trying to add a new field in this query by adding a second query(called MiscScaffoldCostQ) to this. which also has costs associated with the scaffold tag this query acts the same everything is summed then grouped by scaffold tag number.
the problem I have is that there is always tag numbers in the ScaffoldTotalCostQuery however if there is no misc costs to a scaffold tag then in the MiscScaffoldCostQ there wont be a record so when i try to add the MiscScaffoldCostQ to the ScaffoldTotalCostQuery it removes all the records in the ScaffoldTotalCostQuery that doesn't have a record in the MiscScaffoldCostQ
Right now to get around this i have added a "default" button in my forms that applies a $0.00 to misc costs for each scaffold Tag. but i was wondering if there was a better way of doing this.
