Expr 1001 in Field List

  • Thread starter Thread starter JamesJ
  • Start date Start date
J

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
 
JamesJ wrote in message said:
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
Click to expand...

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.
 
Thanks much. I must have stared at that sql 'til I got a headache
and never noticed.

Thanks again,
James
 
Back
Top