Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Query
Hi All,
I am trying to get data from an accountig sql Table. I want to get all documents if the account no is 112200 in either debit or credit side. sau if document1 debit side account no is 112200 the i want to get bothe debit and credit side of that transaction thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Query
Sorry for my bad quick typing
This is what I use SELECT T1.[Posting Date], T1.[Document No_], T1.[Account No_], T2.Name, T1.Description, Round(T1.[Debit Amount],2) AS DebitAmount, Round(T1.[Credit Amount],2) AS CreditAmount, T1.[Shortcut Dimension 1 Code], T1.[Shortcut Dimension 2 Code] FROM Journal_Num AS T1 INNER JOIN T2 ON T1.[Account No_] = T2.No_ WHERE (([Account No_] Like "12345*")); But it gives me only one side. I need both side for this transaction, that is debit and credit. Since on the credit side [Account No_] will not be 12345* How I can get both debit and credit if either debit [Account No_] or credit [Account No_] is 12345* Thanks Mark J wrote: you need to post your question in greater detail and try spellcheck, it does wonders for the rest of us. "Abdul" wrote: Hi All, I am trying to get data from an accountig sql Table. I want to get all documents if the account no is 112200 in either debit or credit side. sau if document1 debit side account no is 112200 the i want to get bothe debit and credit side of that transaction thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert hard coded query criteria to Parameter Query | Excel Discussion (Misc queries) | |||
Excel 2007 / MS Query - editing existing query to another sheet | Excel Discussion (Misc queries) | |||
Anyone Else Use Database Query to Query Another Sheet in the Same Excel Workbook? | Excel Discussion (Misc queries) | |||
How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) | |||
Stop to modify the SQL query manually entered into query ! | Excel Programming |