Type mismatch in description

[Guest]

I keep getting an error come up when I run a query saying type mismatch in
descirption - what does this mean?

 

[BruceM]

It could happen if you are trying to do something like multiply a number by
a text value. What exactly is producing the error?

 

[Guest]

All I am doing is running a query with a auto field, name and about 4 tick
boxes. Info coming from 2 tables, there are no calculations or anything on
there.....

 

[BruceM]

What is the exact error message? Is the table related to another table? If
so, how?

It would probably help if you post the query's SQL. Open the query, and
click View > SQL. Copy what you see and past it into your reply.

 

[Guest]

Exact error msg is "type mismatch in description". There are 2 linked tables
related by an auto number, first and last names.

This is the SQL stuff:
SELECT Attendees.GuestID, Attendees.FirstName, Attendees.LastName,
Attendees.Confirmed, [Specific details].Abseil, [Specific
details].[Zip-wire], [Specific details].Both
FROM Attendees INNER JOIN [Specific details] ON (Attendees.LastName =
[Specific details].[Last Name]) AND (Attendees.FirstName = [Specific
details].[First Name]) AND (Attendees.FirstName = [Specific details].[First
Name]) AND (Attendees.GuestID = [Specific details].[Guest ID]);

 

[BruceM]

I had not seen that error message before, so I did a groups search and could
find no references to it outside of this thread. Please verify the exact
error message.

Are Attendees.GuestID and [Specific Details].[Guest ID] both autonumber
fields? If so, change the field's data type in Specific Details to Number
(long integer).

It's difficult to understand what you intend to accomplish. What is the
query's purpose? Are you using GuestID as the primary key in Attendees, or
are you using GuestID, FirstName, and LastName as a compound (multi-field)
primary key? If the former, there is probably no reason to store the
FirstName and LastName values in Specific Details. I notice that
(Attendees.FirstName = [Specific details].[First Name]) appears twice. I'm
not sure just what problems that may cause, but it can' t be helpful.

Exact error msg is "type mismatch in description". There are 2 linked
tables
related by an auto number, first and last names.

This is the SQL stuff:
SELECT Attendees.GuestID, Attendees.FirstName, Attendees.LastName,
Attendees.Confirmed, [Specific details].Abseil, [Specific
details].[Zip-wire], [Specific details].Both
FROM Attendees INNER JOIN [Specific details] ON (Attendees.LastName =
[Specific details].[Last Name]) AND (Attendees.FirstName = [Specific
details].[First Name]) AND (Attendees.FirstName = [Specific
details].[First
Name]) AND (Attendees.GuestID = [Specific details].[Guest ID]);

What is the exact error message? Is the table related to another table?
If
so, how?

It would probably help if you post the query's SQL. Open the query, and
click View > SQL. Copy what you see and past it into your reply.

message

 

[Douglas J. Steele]

I'm wondering whether one of the tables might have Lookup fields in it, so
that, for instance, one of Attendees.LastName and [Specific details].[Last
Name] is returning text, which the other is returning a number.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

I had not seen that error message before, so I did a groups search and
could find no references to it outside of this thread. Please verify the
exact error message.

Are Attendees.GuestID and [Specific Details].[Guest ID] both autonumber
fields? If so, change the field's data type in Specific Details to Number
(long integer).

It's difficult to understand what you intend to accomplish. What is the
query's purpose? Are you using GuestID as the primary key in Attendees,
or are you using GuestID, FirstName, and LastName as a compound
(multi-field) primary key? If the former, there is probably no reason to
store the FirstName and LastName values in Specific Details. I notice
that (Attendees.FirstName = [Specific details].[First Name]) appears
twice. I'm not sure just what problems that may cause, but it can' t be
helpful.

Exact error msg is "type mismatch in description". There are 2 linked
tables
related by an auto number, first and last names.

This is the SQL stuff:
SELECT Attendees.GuestID, Attendees.FirstName, Attendees.LastName,
Attendees.Confirmed, [Specific details].Abseil, [Specific
details].[Zip-wire], [Specific details].Both
FROM Attendees INNER JOIN [Specific details] ON (Attendees.LastName =
[Specific details].[Last Name]) AND (Attendees.FirstName = [Specific
details].[First Name]) AND (Attendees.FirstName = [Specific
details].[First
Name]) AND (Attendees.GuestID = [Specific details].[Guest ID]);

What is the exact error message? Is the table related to another table?
If
so, how?

It would probably help if you post the query's SQL. Open the query, and
click View > SQL. Copy what you see and past it into your reply.

message
All I am doing is running a query with a auto field, name and about 4
tick
boxes. Info coming from 2 tables, there are no calculations or
anything
on
there.....

:

It could happen if you are trying to do something like multiply a
number
by
a text value. What exactly is producing the error?

message
I keep getting an error come up when I run a query saying type
mismatch
in
descirption - what does this mean?