Expr 1001 in Field List

[JamesJ]

I'm showing Expr 1001 as a field in the field list for one of my forms and
I have no idea why. Here is the sql:

SELECT ReminderID, ReminderType, Reminder, ReminderDate, ReminderTime,
ReminderNotes, ReminderType
FROM tblReminderType INNER JOIN tblReminders ON
tblReminderType.ReminderTypeID = tblReminders.ReminderTypeID ORDER BY
ReminderDate;

I have an INNER JOIN on a few of my other forms but they don't show Expr
1001 as a field.

Any help will be appreciated.
James

 

[RoyVidar]

I'm showing Expr 1001 as a field in the field list for one of my forms and
I have no idea why. Here is the sql:

SELECT ReminderID, ReminderType, Reminder, ReminderDate, ReminderTime,
ReminderNotes, ReminderType
FROM tblReminderType INNER JOIN tblReminders ON
tblReminderType.ReminderTypeID = tblReminders.ReminderTypeID ORDER BY
ReminderDate;

I have an INNER JOIN on a few of my other forms but they don't show Expr 1001
as a field.

Any help will be appreciated.
James

It is probably because you have added the field ReminderType twice to
the column list. Try to remove the last one, and see what happens.

 

[JamesJ]

Thanks much. I must have stared at that sql 'til I got a headache
and never noticed.

Thanks again,
James