October 22, 2008 at 11:27 am
On the Report I need to have columns below:
Date A B C D E F G H I J K L
1. Row is dependent on whatever date user entered when creating a report.
2. Will be selecting value for A, B, C, D, E from Table X
--static data (cannot edit)
3. Need to join four tables T1, T2, T3, T4 to get the value for K, L
--static data (cannot edit)
4. Values for F, G, H, I, J are coming from user's manual data entry on the same report page above. These values are editable. If it is a new insert it will insert the value for F, G, H, I, J to table T5 and T6. If it is a update than it must update the value on correct row within table T5 and T6.
My current apporach by creating several local temp tables and joining is not producing the desired result.
Please advise me of best approach or few queries to handle the problem above. Thank you.
October 22, 2008 at 12:37 pm
Your best approach would begin with posting sample table structure / data and showing us what you're trying to do(by posting your code), and explaining why it's not working and what it should be doing. See the link in my signature for the best way to do this.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply