Parameter Query with a Combo Box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've created a report based on a parameter query, getting options from a
combo box (so users don't have to type in very long options, but I'm getting
a help message saying: "The expression you entered has a function name that
Microsoft Access can't find."

What am I doing wrong and how can I fix this?

Many thanks
 
muzzmonster said:
I've created a report based on a parameter query, getting options from a
combo box (so users don't have to type in very long options, but I'm getting
a help message saying: "The expression you entered has a function name that
Microsoft Access can't find."

What am I doing wrong and how can I fix this?

Many thanks
Click to expand...

I suggest you re-post your question, but include a copy of the SQL of
the Query that gave you the help message.

You can dig into this yourself, perhaps, by making a copy of your Query
and simplifying the copy (by deleting fields, criteria, &c.) until it no
longer produces an error message. The point at which that happens will
give you a clue about what is wrong.

-- Vincent Johns <[email protected]>
Please feel free to quote anything I say here.
 
Back
Top