extra text showing up in my query

  • Thread starter Thread starter flash2911
  • Start date Start date
F

flash2911

I was wondering if some one would know why I have the text from my
second conditionshow in my first condition when I run a query
Time spend on Project:
IIf(DateDiff("n",[workedstart],[workedend])/60<1,DateDiff("n",[workedstart],[workedend])
&" Minutes",DateDiff("n",[workedstart],[workedend])/60) &" Hours"
When I run the query, fields meeting the first condition come out
wierd, they show the not just the first string but also the second
string
does anybody know who to fix this problem or is the an Access bug?
 
How do you mean you're getting both strings? Are there spaces or commas or
anything between them?

Where is that IIf statement: in a query, or as the control source for a text
box? If it's in the query, have you got any other code that affects the text
box, say in the form's Current event?
 
Back
Top