"Enter parameter value" error when exporting to Excel (but not if to other formats)

Hi all,

I use Access 2007 and have come across this error a number of times.
I have two tables (customer information) which should contain -
ideally - the same data.
I create a query to compare them based on customer code. The fields
are something like:
Customer code
Balance - Table 1
Balance - Table 2
Difference (the difference of the 2 fields above)
and so on.

The query runs fine, so I guess there is no error in the expressions.
However, if I try to export to Excel, I get the message "Enter
parameter value", as though Access did not understand one of the
values in the expressions; however, the query did run fine. Also, if I
export to csv, I don't get this message.

Any idea? I am an Access novice, but this really makes no sense to me :
(

.

Relevant Pages

  • Re: Creating auto loan database
    ... Do for all queries involved in the "outstanding balance" ... I am assuming that this query will return a ... depend upon the presence of at least one payment by the customer? ... Sum(CustomerLoanPayments.PrincipalPaid) AS ...
    (microsoft.public.access.forms)
  • Re: Trouble with sendkeys - Alternative?
    ... One customer can be involved in many sales (but not ... You can then create a query based on your three tables. ... If you want to include the sum of the "Value" columns in a crosstab query, ... Graham Mandeno ...
    (microsoft.public.access.formscoding)
  • Re: Crosstab query by quarter nightmare
    ... The Cartesian query gives every combination of customer and savings in the ... I am getting the same count for each savings. ... So you are recording when a customer came on board. ... So the whole crosstab relies ...
    (microsoft.public.access.queries)
  • Re: [PHP] OOP slow -- am I an idiot?
    ... OOP has overhead. ... That saves you putting wasteful SQL queries in your ... If you need to do a complex query with a couple of joins and such, ... I want to create a "customer" class which fetches its attributes from a ...
    (php.general)
  • Re: Many-to-Many relationship Query
    ... the key value is a text string and not a number. ... FROM Employee INNER JOIN (Customer INNER JOIN ... The following function reads this Query and produces a list of employee names similar to what you asked for. ... EmpByCustAS Employees ...
    (microsoft.public.access.queries)