w/c by month

[Guest]

I have set a report on access 2003 works great giving my staff statistics by
month and grade. when I convert it to 1997 however it won't display saying is
'too complex' a format. If I try and set report in 1997 using wizard it does
it but then won't display it saying too complex. It puts in two 'fields' on
the query 1)W/c By Month: Format$([stats].[W/c],'mmmm yyyy') and
2)Year([stats].[W/c])*12+DatePart('m',[stats].[W/c])-1. Can anyone help?

 

[Dave]

your software dealer can help you upgrade everyone to 2003.

 

[Guest]

unfortunately I work for NHS so no chance of that have tried to persuade them.

your software dealer can help you upgrade everyone to 2003.

I have set a report on access 2003 works great giving my staff statistics by
month and grade. when I convert it to 1997 however it won't display saying is
'too complex' a format. If I try and set report in 1997 using wizard it does
it but then won't display it saying too complex. It puts in two 'fields' on
the query 1)W/c By Month: Format$([stats].[W/c],'mmmm yyyy') and
2)Year([stats].[W/c])*12+DatePart('m',[stats].[W/c])-1. Can anyone help?

 

[Arvin Meyer]

I'm not sure of your language version, but you might try replacing the
single quotes with double quotes. The forward slash (/) in the field name
can also cause a conflict. You might also try wrapping the entire DatePart
function with another set of parentheses. Other than that, the expressions
look OK on the surface.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Dave]

then try getting the developer kit (do they still do that for 2003???). at
least up to 2002 you could get the developer kit and that gave you the
access runtime so you could distribute your database to users who didn't
have access at all. they are limited in what they can do, basically to just
doing data entry and running your defined reports... they can't make new
forms or modify table structures, etc.... but it gives you a way to make use
of the latest features without having to upgrade everyone.

unfortunately I work for NHS so no chance of that have tried to persuade them.

your software dealer can help you upgrade everyone to 2003.

I have set a report on access 2003 works great giving my staff

statistics
by

month and grade. when I convert it to 1997 however it won't display

saying
is

'too complex' a format. If I try and set report in 1997 using wizard

it
does

it but then won't display it saying too complex. It puts in two

'fields'
on

the query 1)W/c By Month: Format$([stats].[W/c],'mmmm yyyy') and
2)Year([stats].[W/c])*12+DatePart('m',[stats].[W/c])-1. Can anyone

help?

 

[Douglas J. Steele]

To create an Access 2003 runtime, you need to purchase the following:

- Microsoft Access 2003
- Visual Studio Tools for Office 2003 (which includes the Access 2003
Developer Extensions)

The ADE is the product that gives you the license to deploy the 2003 runtime
components and you have to have Access 2003 installed in order to install
the ADE.

If you're using MSDN, note that while VSTO is available in all subscription
levels of MSDN, the Access Developer Extensions are not included with all
versions. ADE is only available at Universal level.

The stand-alone VSTO box includes both VSTO and the ADE.

See http://msdn.microsoft.com/vstudio/office/officetools.aspx for more
details


--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

then try getting the developer kit (do they still do that for 2003???).
at
least up to 2002 you could get the developer kit and that gave you the
access runtime so you could distribute your database to users who didn't
have access at all. they are limited in what they can do, basically to
just
doing data entry and running your defined reports... they can't make new
forms or modify table structures, etc.... but it gives you a way to make
use
of the latest features without having to upgrade everyone.

unfortunately I work for NHS so no chance of that have tried to persuade them.

your software dealer can help you upgrade everyone to 2003.

I have set a report on access 2003 works great giving my staff statistics
by
month and grade. when I convert it to 1997 however it won't display saying
is
'too complex' a format. If I try and set report in 1997 using wizard it
does
it but then won't display it saying too complex. It puts in two 'fields'
on
the query 1)W/c By Month: Format$([stats].[W/c],'mmmm yyyy') and
2)Year([stats].[W/c])*12+DatePart('m',[stats].[W/c])-1. Can anyone help?

 

[Brendan Reynolds]

I don't see anything in those expressions that would not work in Access 97.
In addition to Arvin's suggestions elsewhere in this thread, try testing
with a simple query that includes just these two expressions. Do you still
get the error?