Make-Table query not creating table

[enak]

I have a make-table query that was working and all of a sudden it is not working. There have been no changes to the query or code that runs the query (as far as I know). Here is the Query:

SELECT qryCalFilter.Date AS EventDate, IIf(Not IsNull([time]),Format([time],'h:nn ampm'),' ')
AS EventTime, [eventtype] & IIf([eventtype]= 'deposition', ' (Deponent: ' & [deponent] & ')', '')
AS Event, Trim([casename]) & IIf(Not IsNull([additcases]),
'(Also: ' & Trim([additcases]) & ')', '') & ' - Matter: ' & [FileNumber] &
' (Opp: ' & [plaintiffscounsel] & ') ' & County & '/' & Court AS Cases,
Trim([city]) & ' - ' & [location] AS Loc, qryCalFilter.EventStatus,
qryCalFilter.Responsible, IIf([isamocolead]=-1,' * LEAD * ',' ') AS Lead,
qryCalFilter.Comments, qryCalFilter.EventID
INTO tblTEMPEventList
FROM qryCalFilter, tblPrintDates
WHERE tblCalendar.Date Between #1/1/2004# and #2/28/2005#

If I remove the line, INTO tblTEMPEventList, then the query works. I get data from the query, qryCalFilter. I don't understand why it just all of a sudden stops working.

Can you please help?

Thanks,
enak

 

[lupins46]

What does 'not working' mean? Error messages?

 

[enak]

The temp table is not being created.

When I run the query in a query window and the table exists then it is deleted. I get a message that says "Record is deleted" and then the execution stops.

HTH,
enak

 

[lupins46]

'WHERE tblCalendar.Date Between #1/1/2004# and #2/28/2005#'

where does tblcalendar get into the query?

 

[lespaul]

See Thread701-1000776 for more ....

Leslie

 

[enak]

tblCalendar comes in from the query qryCalFilter. The thread mentioned above died. That is why I started another.

I have discovered something. If I try to retrieve any records from 2004 I get the error. I can retrieve records from 2005 and the table is created.

What does this mean????

Thanks for your help so far.
enak

 

[enak]

I have found that there is a record with a memo field. This record contains "#Delete". I don't know what this is (I am not an Access developer) but I amsure that this is the problem.

I have submitted a request to delete the record from the table. Is there anything that I can do other than delete the record? I have tried to delete the comment but it does not allow it.

 

[lupins46]

I can see why the other thread ran out of steam...
There's just no avenue to pursue.

Can you create any make-table query in this database?

 

[enak]

Yes. I found that the problem was with a record that had #Delete in one of the fields. I deleted the record and verything is fine now.