Question Type mismatch

balsam

New member
Local time
Today, 17:09
Joined
Jul 27, 2012
Messages
5
Hellow! I need help on type mismatch error on a database that I customized out of northwind2010. The error appears on running ParameterizedReportMonthlySales or Yearly or Quaterly forms. I checked field formats but they appear ok to me. I've attached my accdb file of access 2007
I must admit I have very little knowlege in SQL coding. I believe the problem is with the attached code


Please help!
Thanks
 

Attachments

  • balsam.zip
    balsam.zip
    777.1 KB · Views: 109
  • code.JPG
    code.JPG
    82.4 KB · Views: 119
Last edited:
Northwind is very good if your business is called Northwind.

But. Adapting Northwind to suit your business means that every time you have a problem you won't know how to fix it.

Dump Northwind - write your own DB - then be inspired by Northwind
 
Northwind is very good if your business is called Northwind.

But. Adapting Northwind to suit your business means that every time you have a problem you won't know how to fix it.

Dump Northwind - write your own DB - then be inspired by Northwind

Thanks steve, It is an inspiry of a sample file availble with ms access so I don't see a major issue. Nevertheless changes to suite my needs my start as beginners.

I still need and appreciate help in finding source and solution to this data mismatch.
 
Last edited:

Users who are viewing this thread

Back
Top Bottom