No data in field causing error message 1

[gravesc99]

I have inherited a database...

One of the reports will not run because the underlying table does not have data in a particular month. For example, I have a table indicating all purchases for 10/2003 to date. Since this customer did not come on board until 3/04, there is no data in 10/2003 - 03/2004 fields. as a result, the reports are not picking up any data and the graphs are not being generated.

The exact error message is: The Microsoft Jet database engine does not recognize '[2005 Crosstab New].[7]'as a valid field name or expression. (It also occurs on [3] which represents March 2004 in a similar query that builds the same report.)

Any help or guidance is greatly appreciated.

On another note - is there someone who can advise the pros/cons of Oracle vs. Access? My database is HUGE and probably corrupt at the moment, so we are limping through this month's reports and hope to rebuild...would rather do it once...

 

[KenReay]

Hi

1. Not possible to give a definitive answer without more information, perhaps making your query have an outer join instead of an inner join would fix it

2. Access vs Oracle - no real comparison, Access an inexpensive desktop product, Oracle is an top end client server product. There is no question Oracle (or SQL Server) are "Better" than Access (or Jet to be more precise), but it is horses for courses, it depends what you want to do, there are still many situations where bearing in mind cost of the products, Access/jet is still the best choice.

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[gravesc99]

Thankfully, the Oracle is already purchased and contains our data. They are actually downloading FROM Oracle into Access. Doesn't make sense given the volume.

With regard to the join - that didn't work. It seems to be some issue with the building of the crosstab, but I'm trying to figure out what that is. Thanks for the response, though.

 

[PHV]

They are actually downloading FROM Oracle into Access
Why not using linked tables ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244