Question about Microsoft Office Standard for PC

1 Answer

MS Access Can someone please help with extracting the financial quater for a given data using datepart() function. As is datpart()function defaults the quater to begin from January to December. I need to work out the Financial quater any ideas/help will be welcome

Posted by on

Ad

1 Answer

  • Level 1:

    An expert who has achieved level 1.

    Corporal:

    An expert that hasĀ over 10 points.

    Problem Solver:

    An expert who has answered 5 questions.

  • Contributor
  • 18 Answers

Not sure what the financial quarter is exactly, but Wiki suggests that this is:

Therefore the solution would be:
datepart("q",dateadd("m",-3,DateValueVariable))

Tested using
datepart("q",dateadd("m",-3, now()))
datepart("q",dateadd("m",-3,"1/12/8"))

If the finanical quarters are different just add or sub more from the -3 i.e. if April is Q1 then +3 instead

Posted on Jul 25, 2008

Ad

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE:

Hi there,
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this issue over the phone in a minute or two.

Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.

Here's a link to this great service

Good luck!

Posted on Jan 02, 2017

Ad

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

How do I recapture data from broken Seagate Barracuda which will not function as a C drive in a PC?


extracting data is a very difficult and most times costly chances are unless your data has a very high monetary value to you its probably best just to let it go and next time make sure that you have it backed up somewhere buying a small external or secondary internal drive can be quite inexpensive many times a small internal hd can be purchased for approximately 30$ or an external for about the same price this will allow you to save all your important documents to a second area making you far less likely to lose it ... the fact is is that data recovery for a novice computer user is nearly impossible it includes taking parts of the hd apart buying new (exactly the same) replacement parts which can be difficult and somewhat expensive ... as for hiring someone else to do it most companies charge 1000's of dollars to recover data ... sorry for the bad news but its just not financially viable for a novice to recover data from a hd that cannot be seen by a computer

Mar 16, 2013 | Seagate BARRACUDA Computers & Internet

1 Answer

Alignment of data in tables


When I started learning about these statements I had to understand the different types of the financial statements and what are their uses. There are many tools to calculate various elements like "current/fixed assets", "current/long-term liabilities and "net profit".
There are many websites which provide e-book so you can learn more about items in financial statement.

Mar 08, 2013 | Corel WordPerfect Computers & Internet

2 Answers

I cant sync music onto my Samsung YP-Z5 using itunes and it's the only music source i have


Hi mozartmycat...
You can only use I tunes with Apple Ipod because it uses an ACC format the Samsung uses an MP3, WMA format.
You need to download Samsung Media Studio or Emodio
Please take time to rate me

Samsung Media Studio Download site:
http://www.samsung.com/ca/function/search/espsearchResult.do?keywords=samsung+media+studio&input_keyword=samsung+media+studio

Some info on Emodio
http://www.samsung.com/ca/function/search/espsearchResult.do?keywords=emodio&input_keyword=emodio

Jul 31, 2011 | Samsung YP-Z5 MP3 Player

1 Answer

Hi, I am using LG kp110 Handset, and I want to connect internte through pc, please suggest me is there any software is there or directly connecting data cable????? Thanks for your support in...


Hello thanks for using FixYa
By LG PC suit you can connect internet through pc.You can easily download LG PC suit free After open it the link where you have to click just see the image given below.

Downloading will start after clicking.Download it then extract the files & install it on your PC


angel_bird_8.jpg
After Downloading connect your cell with PC via data cable, PC suit detect your cell and by the given option in PC suit you can connect the internet.

Further help I am here to help. Best of luck
Thanks and Keep using Fixya

Mar 14, 2011 | LG CU500 Cellular Phone

1 Answer

Micron Client Pro Model DX 715 NLX P111450 Running Windows 2000 Pro I'm afraid I'm completely screwed on this, but hoping someone can help. Computer given to friend and she became locked out of windows...


the thing there is to reformat the pc. but if your just want to get some data, try to slave the hard drive on other computer with win 2k or xp. so that you can get your files.

Mar 04, 2010 | Computers & Internet

1 Answer

Convert QB POS to QB Premier Accountant


a) If you previously syncronized POS 2008 with the financial product, then no, you cannot syncronize the data again, unless you tag each transaction (for the whole years) as "unsent".

b) If you have never syncronized POS 2008 with any QuickBooks Financial product, then yes, you can syncronize/download the data into QB 2009 Accountant Edition.

Before you do either: Make sure you do not already have 2008 data in your file.

Jan 14, 2010 | Intuit QuickBooks Premier Accountant...

1 Answer

Simpletech 500 GB Hard Drive not working


The red light is an indicator of drive failure. The fall it took, especially if the drive was on at the time, could easily cause the drive to break something internally so that it will not function. I found SimpleTech drives to fail pretty easily, even when you're not dropping them. That's been my experience, anyway.

Data recovery is a very expensive proposition. If the hard drive doesn't respond to the interface as normal, they have to be pulled apart and data extracted from the internal platters. This isn't something you can do without a full safe room (dust-free, wearing special suits and all) because any dust can ruin the platter. Since it's so involved, it's usually really, really expensive. Generally, most people don't bother when it reaches that point unless it's business files (like all of your financial data, for instance).

However, if it's something you really need that bad, DriveSavers is one of the best:
http://www.drivesaversdatarecovery.com/

Jun 21, 2009 | SimpleTech SimpleDrive Pininfarina 500GB...

1 Answer

Creating Running Sum with Grouping Query


Looks like your GROUP BY subclause says to group by Force_no but also the yyyy and m datepart values for Subs_Dt as separate items. [Also since you are returning "Force_no AS FN", you need to refer to it as 'FN' and not 'Force_no' in the other subclauses of the statement. Same is true for your partial-date references as well in the SELECT subclause] So the query will return the grouping not by Force_no (should be FN) and some partial date but instead by Force_no (shoukd be FN), the year, and then the month.

The fix would be to group by a concatenation of the year and month and to change the references to the fields to be what you renamed them as in your SELECT subclause using "...AS...", for example:

SELECT GIS_Subs.Force_No AS FN, DatePart("yyyy",GIS_Subs!Subs_Dt) AS AYear, DatePart("m",GIS_Subs!Subs_Dt) AS AMonth, DSum("Subs_Amt","GIS_Subs","DatePart('m', [Subs_Dt])<=" & [AMonth] & " And DatePart('yyyy', [Subs_Dt])<=" & [AYear] & "") AS RunTot
FROM GIS_Subs
GROUP BY FN, AYear & "-" & AMonth
ORDER BY AYear, AMonth;

So now you have only 2 GROUP BY parameters instead of three and the grouped results won't be done by FN, then year, then month, but by FN and year-month. [As for the "-" in GROUP BY subclause, you can use any character you want as the separator; I just picked "-" since it is so typical.]

The DSum function in the SELECT subclause may also need some rework; also, possibly you will need to return [Subs_Dt] in the clause as well so DSum() has it to work with. Also check to be sure that reference to [Subs_Dt] is being recognized OK without using the "table!field" form of reference. I dunno if you need it given I don't know your whole table-field definition and so can't say if there would be a naming conflict someplace.

If you are still having trouble, try starting over and building this query piece by piece, one field, one condition, one subclause, at a time until you get to where it breaks for you. That'll be the "threshold of failure" you are looking for that should point you further in the right direction.

I hope this works for you. Let me know how it goes!

Feb 23, 2008 | Microsoft Office Access 2003 (077-02871)...

3 Answers

Help intalling USB DATA CABLE DRIVER Sanyo Katana 6600


You can get all the software and drivers you need here. http://global.mobileaction.com/download/download1.jsp?phoneBrand=17&modelID=603&go=+Go+

Jun 18, 2007 | Sanyo Katana SCP-6600 Cellular Phone

Not finding what you are looking for?
Microsoft Office Standard for PC Logo

Related Topics:

185 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

Ekse

Level 3 Expert

13434 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18429 Answers

Alun Cox

Level 3 Expert

2679 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...