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

1 Answer

  • Level 1:

    An expert who has achieved level 1.


    An expert that hasĀ over 10 points.

    Problem Solver:

    An expert who has answered 5 questions.

  • Contributor
  • 18 Answers
Re: MS Access

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

Therefore the solution would be:

Tested using
datepart("q",dateadd("m",-3, now()))

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

Add Your Answer

0 characters

Uploading: 0%


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


3 Points

Related Questions:

1 Answer

Product key of msoffice 2007


i think you are not used to the proprietary software rules..
there are three types of softwares which are free , those that are sold for a fixed price and those are not meant for commercial use...

ms office 2007 is a proprietary software which can be bought from the microsoft for a given price...

below is the link the site from which you can buy ms office 2007

if this helps please give a vote

Mar 14, 2010 | Microsoft MS OFFICE 2007 SBE MLK (NA) SW....

1 Answer

How to export table in ms access to excel

yes you can export your access data into excel, follow steps on how to export.

1. open your access database
2. open the table data you to export
3. under table data view click tools menu
4. select analyze
5. select ms excel
6. this will open your seleted access table in excel

hope this will help you..

Dec 13, 2008 | Microsoft Access 2002 for PC

3 Answers

Connectivity between HTML page and Ms-Access

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)
<LI><%=RS("Name")%>: <A HREF="<%=RS("Link")%>">Homepage</A>

Nov 11, 2008 | Microsoft Office Standard for PC

1 Answer

Autonumber help in Ms Access 2003

You cannot store the E in the autonumber field, but you can make the data look that way. Therefore, use the following format for the Employee_Id column:

Aug 26, 2008 | Microsoft Office Access 2003 (077-02871)...

1 Answer

MS DOS Data File to Be Imported

If you have access and excel you probably have WORD.
When you go to open the .doc file select other or if the list shows word open with that if not "Browse" for word.exe to open the .doc file.

Or open word, select the icon in word for "open", or go to file, open, and select the .doc file to open.

Mar 20, 2008 | Business & Productivity Software

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

Hyperlink function in ms access

To Create a Hyperlink Field:

Display the table in Design view, create a new field to store the hyperlinks, click the new hyperlink field's Data Type box, click the list arrow, select Hyperlink, and save the table.
To Insert a Hyperlink:

Select the hyperlink field and then click the Insert Hyperlink button on the toolbar or select Insert , Hyperlink from the menu. Either select a file you want (use the Browse button to help you locate the file) or type a Web address for the hyperlink's destination and click OK.

To edit a Hyperlink: Right-click the hyperlink and select Hyperlink , Edit Hyperlink from the shortcut menu.

Is this enough?

Dec 21, 2007 | Microsoft Office Access 2003 (077-02871)...

1 Answer


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

2 Answers

Ms access

before this u should know what is databse.
ms access has various objects likw table,form,query,report etc..
table is a object which stores the actual data and form is used to enter the data in to the table and display the data from the table, while report is object which is used to desplay your data in required formate.Query is used to fetch the data from the table in customised formate.for that u should have knowledge of SQL.

Nov 14, 2007 | Business & Productivity Software

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:

179 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers


Level 3 Expert

18259 Answers

Sudeep Chatterjee
Sudeep Chatterjee

Level 3 Expert

3267 Answers

Are you a Microsoft Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides