Field missing from query/combo box

The following is an example of one of the selections from my combo box:
SES 2  :  6/18/2001 ? 6/29/2001
The problem is, the second date does not appear on the user?s PC.  The selection above appears as:
SES 2  :  6/18/2001 ?
The corresponding expression in the query looks like this:
Session: "SES  " & [SessionNumber] & "  :  " & [SessionBegDate] & "  -  " & [SessionEndDate]
I am in the process of testing this new software, so any changes I make on my office PC replace the ?old? version on the user?s PC each time a change is made.  The user?s PC is running from the same platform that mine is, and we are both using Access 2000.  

Can anyone tell me what is causing this problem?
tfygoldAsked:
Who is Participating?
 
nico5038Commented:
Looks like the A2000 concatenation bug after a numeric(date) field.

Try:
Session: "SES  " & Cstr([SessionNumber]) & "  :  " & Cstr([SessionBegDate]) & "  -  " & Cstr([SessionEndDate])

Nic;o)
0
 
englishmanCommented:
Too many question marks in your code?!
0
 
tfygoldAuthor Commented:
Thanks, englishman, for volunteering as editor of my comment.  Sorry - no points for you.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.