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!

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

ACC-XP Data tpe mismatch in criteria expression

Status
Not open for further replies.
AlanKW

AlanKW

Technical User
Jun 20, 2002
161
US
I have a report that's based on a query. In the query before the report query, I calculate an age in a column I call StudyAge. The queries work fine.

However in the report, as soon as I add that field, it errors out with the message above. I've removed any sort of formatting in the proprties of the textbox to no avail.

Am I missing something?
 
Status
Not open for further replies.

Similar threads

JimStrand
  • Locked
  • Question
Expression Limit on Sum IIf In Method ? Used in Report Calculation
Replies
1
Views
569
dhookom
dhookom
TrekBiker
  • Locked
  • Question
Print multiple copies of report data 1
Replies
5
Views
553
dhookom
dhookom
SamuelR
  • Locked
  • Question
Dlookup in a report
Replies
13
Views
684
dhookom
dhookom
renigar
  • Locked
  • Question
Access 365 Report use nickname if exist instead of 1st name
Replies
4
Views
3K
renigar
renigar
ptrifile
  • Locked
  • Question
Sum with multiple criteria
Replies
2
Views
342
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top