Click here to Skip to main content
15,513,762 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRe: Best way to save data in Visual basic Pin
HimanshuSha17-Dec-13 3:30
HimanshuSha17-Dec-13 3:30 
GeneralRe: Best way to save data in Visual basic Pin
Dave Kreskowiak17-Dec-13 3:49
mveDave Kreskowiak17-Dec-13 3:49 
GeneralRe: Best way to save data in Visual basic Pin
HimanshuSha17-Dec-13 22:04
HimanshuSha17-Dec-13 22:04 
GeneralRe: Best way to save data in Visual basic Pin
Dave Kreskowiak18-Dec-13 7:32
mveDave Kreskowiak18-Dec-13 7:32 
QuestionCreating an Income and Expenditure Statement. Pin
Biplob Singha Shee16-Dec-13 22:38
Biplob Singha Shee16-Dec-13 22:38 
AnswerRe: Creating an Income and Expenditure Statement. Pin
Mycroft Holmes17-Dec-13 1:09
professionalMycroft Holmes17-Dec-13 1:09 
GeneralRe: Creating an Income and Expenditure Statement. Pin
Biplob Singha Shee17-Dec-13 10:37
Biplob Singha Shee17-Dec-13 10:37 
AnswerRe: Creating an Income and Expenditure Statement. Pin
David Mujica17-Dec-13 3:08
David Mujica17-Dec-13 3:08 
How about something like Option #2, but in a Temp table.

Something like

SELECT xdate,description,income_amt Into #Temp1
Union
SELECT xdate,description,exp_amt Into #Temp1

(Apply the correct field names for your solution)

This way, you have a merged table which you can sort by date and generate your report.

My 2 cents.
Cool | :cool:
AnswerRe: Creating an Income and Expenditure Statement. Pin
kmoorevs24-Dec-13 8:18
kmoorevs24-Dec-13 8:18 
QuestionLoading data from SQL server Pin
Member 1038849415-Dec-13 13:25
Member 1038849415-Dec-13 13:25 
AnswerRe: Loading data from SQL server Pin
Member 1038849415-Dec-13 13:33
Member 1038849415-Dec-13 13:33 
GeneralRe: Loading data from SQL server Pin
Eddy Vluggen16-Dec-13 8:10
professionalEddy Vluggen16-Dec-13 8:10 
GeneralRe: Loading data from SQL server Pin
Member 1038849418-Dec-13 4:27
Member 1038849418-Dec-13 4:27 
QuestionDelete using BindingContext Pin
Member 1038849415-Dec-13 11:36
Member 1038849415-Dec-13 11:36 
AnswerRe: Delete using BindingContext Pin
Mycroft Holmes15-Dec-13 12:50
professionalMycroft Holmes15-Dec-13 12:50 
Questionview image from a picturebox loading from a database Pin
waner michaud15-Dec-13 11:15
waner michaud15-Dec-13 11:15 
AnswerRe: view image from a picturebox loading from a database Pin
Mycroft Holmes15-Dec-13 12:47
professionalMycroft Holmes15-Dec-13 12:47 
GeneralRe: view image from a picturebox loading from a database Pin
waner michaud19-Dec-13 5:36
waner michaud19-Dec-13 5:36 
QuestionCustom paper size Problem in Dot matrix printer... Pin
digitalbalu13-Dec-13 17:17
digitalbalu13-Dec-13 17:17 
QuestionLogic for Sales Return and Purchase Return Pin
Biplob Singha Shee13-Dec-13 8:10
Biplob Singha Shee13-Dec-13 8:10 
AnswerRe: Logic for Sales Return and Purchase Return Pin
Mycroft Holmes13-Dec-13 13:38
professionalMycroft Holmes13-Dec-13 13:38 
GeneralRe: Logic for Sales Return and Purchase Return Pin
Biplob Singha Shee14-Dec-13 9:56
Biplob Singha Shee14-Dec-13 9:56 
GeneralRe: Logic for Sales Return and Purchase Return Pin
Mycroft Holmes14-Dec-13 13:26
professionalMycroft Holmes14-Dec-13 13:26 
GeneralRe: Logic for Sales Return and Purchase Return Pin
Biplob Singha Shee16-Dec-13 8:46
Biplob Singha Shee16-Dec-13 8:46 
GeneralRe: Logic for Sales Return and Purchase Return Pin
Mycroft Holmes16-Dec-13 12:38
professionalMycroft Holmes16-Dec-13 12:38 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.