February 27, 2013 at 3:26 am
Hi,
I have a table with the below column headings.
Business UnitDocument IDDocument DateYearPeriodAccountDescrDeptProductProjectAnalysis CodeAffiliateCurrencyBase AmountUSD AmountLine DescrReferenceVendorVendor NameModuleDoc Line #AP Distrib Line #Post StatusSeq
I need to pull data with the document date, account and dept.
Where the document data would be the previous month,
there would be multiple accounts: for eg: [FTS Yearly Query].Account >= 847000 and [FTS Yearly Query].Account <=847900 or [FTS Yearly Query].Account = 821000
and multiple depts as well.
and it do not get the required data.
Could someone please help me.
February 28, 2013 at 6:23 am
renato_mech_334 (2/27/2013)
Where the document data would be the previous month,there would be multiple accounts: for eg: [FTS Yearly Query].Account >= 847000 and [FTS Yearly Query].Account <=847900 or [FTS Yearly Query].Account = 821000
and multiple depts as well.
Hi:
Your question is a little difficult to understand, unfortunately.
But, here's a quick observation I'll share -- if the example criteria you've listed is taken from the sql code, then your results won't likely be as intended. From your example, I think you might try the following with parentheses:
(
[FTS Yearly Query].Account >= 847000 and [FTS Yearly Query].Account <=847900
)
or [FTS Yearly Query].Account = 821000
--pete
February 28, 2013 at 9:37 am
Hi Pete,
Thanks for the reply.
I figured it out by using it in this format.
WHERE ([FTS Yearly Query].Dept = "3310" ) and ( ([FTS Yearly Query].Account >= 847000 and [FTS Yearly Query].Account <=847900 or [FTS Yearly Query].Account = 821000) and (Year([FTS Yearly Query].[Document Date])* 12 + DatePart("m", [FTS Yearly Query].[Document Date]) = Year(Date())* 12 + DatePart("m", Date()) - 1)
Regards,
Renato
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy