Search results for query: *

Would you guys have a better recommendation for a system that I can use to generate this information? I am trying to provide my organzation with automated data reporting systems that require more complex reporting processes then they are used to. I have been using MS Access for years but I want...

Thanks. The : is part of the naming system :/

Still no luck... I have made a new connection, changing all -'s to _. Here is what i am using now... SELECT TA.Task_ID, TA.Status, TA.Assigned_Group, TA.Assigned_Individual, TA.Create_Date FROM ES_SR:TaskAuditHistory TA WHERE TA.Status = 'Assigned' and...

Oh, Ok. Yeah it is in the "Add Command" area of CR. This works on its own; SELECT Task-ID, Status, Assigned-Group, Assigned-Individual, Create-Date as Assigned-Date FROM ES-SR:TaskAuditHistory WHERE Status = 'Assigned' and Assigned-Group = 'Access Control'...

lbass... Yes, it works on its own, I am unsure why it doesnt work as a subquery? kskid... It is an AR Database. I have it set to remove special characters but I dont think it removes hyphens. Wouldnt quoting a field override the subtraction function and treat it as a field?

Yes, I put the sub query in a seperate command. It was accepted and allowed it to save, rather then erroring for debug.

Darn, Tried that as well; No luck ... Failed to open a rowset. Details: 420:Driver]Expectied lexical element not found: <Identifier> Its acting as if that subquery statement isnt existing. I put the subquery by it self and it ran fine; but when ever I put it into this command, I get the error...

Actually, I take that back... I changed a few of the _ to - in the command you posted, and now the error has changed; Failed to open a rowset. Details: 420:Driver]Unexpected extra token: Create-Date

Still getting that error, could it be because I am connecting through ODBC?

Ok, here is what I am trying to do. I usually use access to create subqueries that led to a master query. Each of these sub queries has information that leads to data that is used to create statistics for reviews. What I am trying to do is replicate this process in Crystal Reports. The first...