Senin, 21 Mei 2012

RE: [MS_AccessPros] Custom crosstab question

 

Jim-

It would help to see the SQL of your query to see how you can dynamically
calculate the year from today's date. Also, we need to know what comprises your
fiscal year. A calendar year?

John Viescas, author

Microsoft Office Access 2010 Inside Out

Microsoft Office Access 2007 Inside Out

Building Microsoft Access Applications

Microsoft Office Access 2003 Inside Out

SQL Queries for Mere Mortals

<http://www.viescas.com/> http://www.viescas.com/

(Paris, France)

From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of luvmymelody
Sent: Monday, May 21, 2012 8:14 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Custom crosstab question

Hello all,

When I built this report for users, all was well. It was exactly what they
wanted. Now there are some things that they are requesting that I am trying to
develop with what I have. The problem is that the original request may need to
be revised and I am not wanting to do that.

The original request was to build a report to show the differences between 2
dates across a date range to see how long it takes to post a job position and
then to fill it. There are about 13 milestones between the begin and end dates
that are also calculated.

So I created a query that has expressions to calculate the differences between
the about 13 different dates across the spectrum of different milestones of a
hiring process.

Now they want to see a breakdown of the differences for each Fiscal Year of the
difference for each date difference. So I created a query that shows this but,
it is hard coded with the FY in the query. I really do not want to manage the
fiscal years in the query every time a new fiscal year comes along.

How do I build this? Unfortunately my design is to create an expression in the
query for each difference. Below is the name of the expressions in the query to
get the differences.

Diff1
Diff2
Diff3 and so forth.

Thank You

Jim Wagner

[Non-text portions of this message have been removed]

__._,_.___
Recent Activity:
.

__,_._,___

Tidak ada komentar:

Posting Komentar