Query exits app??

[rry2k]

I have a query that has a mind of it's own. Luckily I made a copy. The problem is: When I try to execute the query from a form or even in the database window all it does is exit the application. I can't even view it in design mode it does the same thing. I've included the code but it has absoulutely nothing to do with an exit.

SELECT DISTINCTROW [Time Card Hours].*, Projects.ProjectName, [Time Card Hours].[BillingRate]*[BillableHours] AS [Hourly Billings]
FROM Projects INNER JOIN ([Time Cards] INNER JOIN [Time Card Hours] ON [Time Cards].TimeCardID = [Time Card Hours].TimeCardID) ON Projects.ProjectID = [Time Card Hours].ProjectID
WHERE ((([Time Cards].TimeCardID)=[Forms]![TimeCardsNew]![TimeCardID]) AND ((DateDiff(&quot;y&quot;,[dateworked],Now()))<8));

Thanks..Russ

 

[smedvid]

Without getting into the specifics, I would try the following:

1. Try to execute query on another PC.
2. Rebuild the query step by step. First drop the Where clause. Perhaps you have inadvertly created a cartesian join (many to many) relationship.
3. Compact the database to insure everything is in sync. You could have a damaged item within the database also.

htwh... Steve Medvid
&quot;IT Consultant & Web Master&quot;

http://users.erols.com/medvid/

 

[rry2k]

Thanks Steve,

I created a query with out the where and it was fine. When I added it crashed. Given the fact that this query works in the old version I assume that something got damaged. I copied my revisions from the new version back into the old and now everything is smooth. Would a cartesion join possibly just run out of memory and exit?