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: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
A 6ya expert can help you resolve that 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.
The service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
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:

5 Answers

Need guidance to restore mdb file from Access


Here is a link http://www.en.accessrecovery.org and http://www.compactaccessdatabase.net on the same particular problem that I resolved effectively using this tool. This tool is smartly programmed and allow to restore database from a corrupt database table without hassle.

Apr 11, 2014 | Computers & Internet

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

Different between MS EXCEL & ACCESS


Hi. MS Excel is for spreadsheet. Very useful when creating accounting documents. MS Access is for database. Very useful when collecting data.

Please visit these links to learn more about the 2 applications:
http://www.blurtit.com/q373300.html

http://office.microsoft.com/en-us/access-help/using-access-or-excel-to-manage-your-data-HA001042918.aspx

http://www.thetechfaq.com/2010/03/14/microsoftaccess-and-excel-comparison/

Sep 03, 2010 | Microsoft Windows XP Media Center Edition...

2 Answers

What is vlookup in ms excel


It is a function in excel that will look up to a value or data located in different sheet or in different cells. It is very helpful function to look for a bunch of data and compair and extract the exact information. syntax: =vlookup(lookup_value,table_array, col_index_num,[range_lookup])

Aug 27, 2010 | Computers & Internet

3 Answers

Connectivity between HTML page and Ms-Access


<HTML>
<BODY>
<%
Set MyConn = Server.CreateObject("ADODB.Connection")
MdbFilePath = Server.MapPath("sample.mdb")
MyConn.Open "Driver={Microsoft Access Driver (*.mdb)}; DBQ=" & MdbFilePath & ";"
SQL_query = "SELECT * FROM Friends"
Set RS = MyConn.Execute(SQL_query)
WHILE NOT RS.EOF
%>
<LI><%=RS("Name")%>: <A HREF="<%=RS("Link")%>">Homepage</A>
<%
RS.MoveNext
WEND
%>
</BODY>
</HTML>

Nov 11, 2008 | Microsoft Office Standard for PC

1 Answer

Converting word formatted data in CStriing to MS publisher


Why not use Word Automation? You instantiate an object with a reference to Application.Word, load your document, then use the built in functions to extract the text from the document and paste it into the MSP document.

Jun 30, 2008 | Microsoft Computers & Internet

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)...

1 Answer

Importing data from fox pro


try to use odbc and create link in ms. access.
or you can extract it to csv file and then import it to access.

Jan 28, 2008 | Computers & Internet

1 Answer

MS ACCESS


What are the uses of MS Access??
What are the disadvantages and advantages of MS Access?
What are the MS Access Data Base Objects?
What are the different kinds of toolbars in MS Access and there functions?

Nov 19, 2007 | Microsoft Office Professional 2007 Full...

3 Answers

Viewing ms Sql Server database on Access


Are you familiar with "Linking" tables in Access? In Access: File --> Get External Data --> Link Tables. This will bring up a dialog box which allows you to browse to your SQL server and select the table you want.

Aug 23, 2007 | Microsoft SQL Server Standard Edition for...

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

Related Topics:

182 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2980 Answers

Piyal Perera
Piyal Perera

Level 3 Expert

528 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18424 Answers

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

Answer questions

Manuals & User Guides

Loading...