Results 1 to 9 of 9
  1. #1
    3 Star Lounger
    Join Date
    May 2001
    Location
    Mount Vernon, Washington, USA
    Posts
    305
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Mismatch Error (2000)

    When I go to run a report I keep getting "Type Mismatch in expression" Also, when filling in my Purchase Orders the Order Date keeps defaulting to the current date, I looked in the Form Design and there is no default there???
    lynndelap

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Mismatch Error (2000)

    1. Can you open the record source of the report directly? Do you get the Type Mismatch error then?
    If not, do you have calculated controls on the report? That is, controls whose control source starts with =. Check those carefully for confusion between (for example) text and numbers.
    Do you open the report with a where-condition?

    2. Does the underlying table have a default value for Order Date?

  3. #3
    3 Star Lounger
    Join Date
    May 2001
    Location
    Mount Vernon, Washington, USA
    Posts
    305
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Mismatch Error (2000)

    I do not like Access as it seems very confusing and I have to admit I do not even understand what you are referring to ex. underlying table - the table has no default. I will try and look at what you are saying and get back to you. thanks. <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>
    lynndelap

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Mismatch Error (2000)

    By "underlying table" I mean that the record source of the form can be a table or a query, but ultimately the data come from a table (or tables). There could be a Default Value set for Order Date in the form, but you say that isn't the case, or in the table that contains Order Date. And finally, there could be VBA code behind the form that sets a value for Order Date.

  5. #5
    3 Star Lounger
    Join Date
    May 2001
    Location
    Mount Vernon, Washington, USA
    Posts
    305
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Mismatch Error (2000)

    Now I went back into my data base and the fields are missing their information = "item amount" "total" are all missing the data. Uggh I do not like access, I need something simple! any suggestions??? <img src=/S/crazy.gif border=0 alt=crazy width=15 height=15>
    lynndelap

  6. #6
    Silver Lounger
    Join Date
    Jun 2002
    Location
    Cheadle, Staffordshire
    Posts
    2,177
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Mismatch Error (2000)

    Mismatch error usually means exactly what it says. Something obviously is "Mismatched", Theres something either wrong in the query, table, report or calculation.
    Access works around tables. These tables hold the information the user has either entered, or just wants to retrieve.

    A form is built with an underlying table or query.
    A query is a kind of table which has derived from another table or several tables.
    They are a good way to create calculations, migrate data etc etc.

    A report is pretty much the same as a form, it has an underlyinf record source ie, Table or Query.

    A form or a report can also hold "Unbound Fields"

    A "Bound Field" is directly linked to it's own table, where an "Unbound Field" is not.
    The user can enter his/her own calculation in the Unbound Field ie, =Sum([Field1])+([Field2]) calculating the total amount of two bound fields.

    Possibly in your report calculation, an expression has been enterred into an Unbound to which the calculation cannot perform.

    Example: 2 + 2 = 4 (This is ok)
    Example: Two + 2 = Mismatch !!!

    The fields can be Numerical or Text.
    For instance, You would think a telephone with it's prefix code is better numerical, Wrong, it's best handled as a text value because of the Space between the code and the number.

    I'm not sure if this helps you but possibly gives you an insight on the workings of tables,queries and calculations.
    Access is really quite easy (he says) to familiarise with. After time and practice, things start to make sense.
    You can really become addicted to it's functuality and the possibilities are endless.

    Hang on in there, it'll become easier as you practice more.

  7. #7
    3 Star Lounger
    Join Date
    May 2001
    Location
    Mount Vernon, Washington, USA
    Posts
    305
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Mismatch Error (2000)

    Thank you. Do you recommend starting with one of their wizards or building from scratch? I used a wizard. Any idea on why my "item cost" figures would suddenly disappear in my Purchase Order form? I'll keep plugging away, but may start over from scratch.
    lynndelap

  8. #8
    Silver Lounger
    Join Date
    Jun 2002
    Location
    Cheadle, Staffordshire
    Posts
    2,177
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Mismatch Error (2000)

    If you can read a little about how Access works, there are some pretty good beginner books about. The basics are pretty much simple, ie Table, Form. Query,Report.
    Wizards are a good starting point, they'll help you to learn about the workings of Access. Don't be afraid to try them out.
    You can cut bits out of your existing Database and post it here on the site. It must be under 100kb zipped. This way we could explain where your problem lies.

    If you need more help, you need to try and be more specific.

    As I said, Access is extremely flexible.

    Good luck in your learning.

  9. #9
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Mismatch Error (2000)

    Using wizards is fine as a starting point, but to build effective databases, you need to know something about relational database design, not just how to build a form, report, or query. If you can find a copy of the O'Reilly book, Access Database Design &Programming, by Steven Roman, that will give you the basic outline of relational concepts and is also a quick reference for Access syntax.
    Charlotte

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •