Joined
Last Seen
0 Reputation Points
Unknown Quality Score
No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
0 Endorsements
Ranked #107.41K
|
Hello, I am trying to figure out how best to merge these two queries together: #1 - this is pretty basic: [code=sql] SELECT DISTINCT [vtebase].[EbLastName], [vtebase].[EbFirstName], [vtecomp].[EmAnnual], Str(vtecomp.[EmAnnual] * 1.03,9,2) AS [3% Increase], Str(vtecomp.[EmAnnual] * 1.05,9,2) AS [5% Increase], Str(vtecomp.[EmAnnual] * 1.07,9,2) AS [7% Increase], [vtEqbase].[EqDateNext] AS [Next Review Date], …
|