Reserved Error (-3087)

  • Thread starter Thread starter Rocky
  • Start date Start date
R

Rocky

I hve finalised my an application using Access 2007.

It was working fine. Then suddenly it came up with an error message
on Append Queries.where I sum and ave data

"Reserved Error (-3087)"

I have searched for this error, but could not find it in any of the
groups.

In the meantime I have had to first use a make table query and then
append from there. This seems to work for the meantime, but it is a
long way around.

Is there a fix for this error

Rocky
 
I hve finalised my an application using Access 2007.

It was working fine. Then suddenly it came up with an error message
on Append Queries.where I sum and ave data

"Reserved Error (-3087)"

I have searched for this error, but could not find it in any of the
groups.

In the meantime I have had to first use a make table query and then
append from there. This seems to work for the meantime, but it is a
long way around.

Is there a fix for this error

Rocky
Click to expand...

I have noted that the reserved error is used when yhe software
developer has not foreseen this particular error.

Do I therefore assume that it is a NS Access program problem and
nothing todo with my application?

The sql for one of the Append Queries giving this error reads as
follows:-

INSERT INTO Revenue ( [Month], Amount, Type, [COS%] )
SELECT Month.Month, Sum(Accounts.Amount) AS SumOfAmount, "Inv Future"
AS Type1, Avg(JobsAll.[cos %]) AS [AvgOfcos %]
FROM ([Month] INNER JOIN Accounts ON Month.MonthId = Accounts.Month)
INNER JOIN JobsAll ON Accounts.[Job No] = JobsAll.[Job No]
WHERE (((Accounts.Type)="O"))
GROUP BY Month.Month, "Inv Future", Accounts.Month
ORDER BY Accounts.Month;

Hope this helps

Rocky
 
I hve finalised my an application using Access 2007.

It was working fine. Then suddenly it came up with an error message
on Append Queries.where I sum and ave data

"Reserved Error (-3087)"

I have searched for this error, but could not find it in any of the
groups.

In the meantime I have had to first use a make table query and then
append from there. This seems to work for the meantime, but it is a
long way around.

Is there a fix for this error

Rocky
Click to expand...

I have noted that the reserved error is used when yhe software
developer has not foreseen this particular error.

Do I therefore assume that it is a NS Access program problem and
nothing todo with my application?

The sql for one of the Append Queries giving this error reads as
follows:-

INSERT INTO Revenue ( [Month], Amount, Type, [COS%] )
SELECT Month.Month, Sum(Accounts.Amount) AS SumOfAmount, "Inv Future"
AS Type1, Avg(JobsAll.[cos %]) AS [AvgOfcos %]
FROM ([Month] INNER JOIN Accounts ON Month.MonthId = Accounts.Month)
INNER JOIN JobsAll ON Accounts.[Job No] = JobsAll.[Job No]
WHERE (((Accounts.Type)="O"))
GROUP BY Month.Month, "Inv Future", Accounts.Month
ORDER BY Accounts.Month;

Hope this helps

Rocky
Click to expand...

Perhaps it means exactly what it says.

Month is a reserved Access/VBA/Jet word and should not be used as a
field name (nor in your case a Table name].
If you named all of your children Joe, would any of them know who you
were calling? <g>

For additional reserved words, see the Microsoft KnowledgeBase article
for your version of Access:

109312 'Reserved Words in Microsoft Access' for Access 97
209187 'ACC2000: Reserved Words in Microsoft Access'
286335 'ACC2002: Reserved Words in Microsoft Access'
321266 'ACC2002: Microsoft Jet 4.0 Reserved Words'

For an even more complete list of reserved words, see:
http://www.allenbrowne.com/AppIssueBadWord.html
 
Rocky said:
INSERT INTO Revenue ( [Month], Amount, Type, [COS%] )
SELECT Month.Month, Sum(Accounts.Amount) AS SumOfAmount, "Inv Future"
AS Type1, Avg(JobsAll.[cos %]) AS [AvgOfcos %]
FROM ([Month] INNER JOIN Accounts ON Month.MonthId = Accounts.Month)
INNER JOIN JobsAll ON Accounts.[Job No] = JobsAll.[Job No]
WHERE (((Accounts.Type)="O"))
GROUP BY Month.Month, "Inv Future", Accounts.Month
ORDER BY Accounts.Month;
Click to expand...

I would also avoid the use of % or any special characters other than _
underscore in field names. Don't use blanks in table or field names
too.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 
3081
Can't join more than one table with the same name <name>












- Show quoted text -
Click to expand...

Kearning all the time!!!

Thanks for the feedback. Will implement and stay away from the
reserved word list.

Rocky
 
Back
Top