Solved: "Type Mismatch in Expression" - Access Query Problem

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

minkabelle

Thread Starter
Joined
Dec 3, 2004
Messages
139
Hi all,

I just created an Access database and I'm having trouble running the query. I keep receiving the error message "Type Mismatch in Expression". I have triple checked all of my underlying fields and they all match so what am I doing wrong? I can't upload the file as I'm at work and don't have access to my FTP so if you are able to assist me with hosting this file, it'd be greatly appreciated. (Note: all names & addresses included in the database are fictitious).

T.I.A! :)
 

OBP

Joined
Mar 8, 2005
Messages
19,895
minkabelle, this forum has it's own "uploader", but the database does need to be zipped.
It is very difficult to identify what is wrong without it.
Are there any Criteria set?
Are there any expression fields doing calculations?
Are there any Groups?
 
Joined
Jul 29, 2001
Messages
21,334
Your sales table had the forien keys from the other three tables set to the data type text. Set them to numbers and it should be fine.
 
Joined
Jul 29, 2001
Messages
21,334
The simple things are sometimes the hardest to find. It happens to everyone, and you are a geek not a git..:)
 

minkabelle

Thread Starter
Joined
Dec 3, 2004
Messages
139
I have another issue with this same database now. I'm trying to run a query to include the Product Name but when I run it it only puts the Product Number. The Product Name column is there but it's always empty after running the query. Any ideas?

I'm going to be using the data in the query in a form letter.
 

minkabelle

Thread Starter
Joined
Dec 3, 2004
Messages
139
OMG. It's official. I'm *AM* a git. I worked it out not 5 seconds after posting this. :eek:
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Members online

Top