Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Pulling data from MS Access and a field type is number, possible

Status
Not open for further replies.

ynott

Technical User
Sep 26, 2000
49
US
I have a MS Access document and there is one field that has a number value as opposed to text. I can't change the field to test because I need the value to base part of the report. When I include this field called "count" into my report, I get the following error message:


Data type mismatch in criteria expression. then
Error detected by database DLL and then a blank screen.

What can I do to solve this problem. Again, I must use number in the MS Access document.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top