Recent content by piovesan

Thanks lbass. I think I was trying too many different scenarios and just totally missed adding the new formula into the selection. Everything was working for me except the "All Area Projects" selection so I added that and now it all works fine!! Whew.... step away from the computer :-)

{APDEFN.APTYPE} in ["PLANNING", "PLANNING 2"] and ( ( {?Planner}<>"ALL" and ( ( {?Planner}="NONE ASSIGNED" and ( isnull({APEMP.EMPID})or trim({APEMP.EMPID})="" ) ) or {APEMP.EMPID}={?Planner} ) ) or {?Planner}="ALL" ) and ( ( {?PlanArea}<>"ALL" and ( ( {?PlanArea}="NO PLAN AREA" and (...

Thank you lbass! You have done it again! This works. Now my only problem is the additional request I just got for this report. They want to ALSO be able to query on Plan Area. This is another table related to the Project table in a One:Many relationship. It is in the same situation as the...

Hi lbass. Yes, I have a left outer join from the project table to the employee table. OK I seemed to have gotten it to work when I select the NONE ASSIGNED parameter. But not when I select the "ALL" parameter, I only get the none assigned. I think I must have something wrong with my...

Hi all. Here is one I can't figure out. The facts: I have a table of projects with details about the projects. (Table name is PROJ) RELATED to that table, is another table that identifies the employee responsible for the project (EMPLTABLE.EMPID) The tables are related through the PROJID key...

Oh I think I got it. I removed the Sum({@nulldecision}, {table.applicationID)=0 from the group selection and built a parameter called Decisions. Then in the record selection I put: (if {?Decisions} = "No Decision" then {@nulldecision} = 0 else if {?Decisions} = "Has Decision" then...

That's great lbass and it works, but how can I make that a parameter? The user wants to be able to select a parameter to sometimes look at only those without the decision, and sometimes wants to look at those With the decision... and sometimes all of them.

Hi. My report lists a bunch of applications and each application should have one, or many, decisions. The user wants to be able to list the applications that do NOT have any decisions. What I was thinking of doing, was creating a running total of the decisions (therefore I get the ones...

sorry.. the spacing was all messed up in that message so attached is a bit better to see the fieldshttp://files.engineering.com/getfile.aspx?folder=268820f5-7837-4cee-ac95-356ca1f2d78a&file=Supress.xlsx

I have one table called TableA that has the following fields: UniqueID ParentID All are text fields I am creating a report that pulls in the same table twice into the database so that I can link as follows: TableA has a left outer join from UniqueID to TableA_1.ParentID The data could be like...

Hi; I have a report that uses a union query. The report displays a list of properties and indicates the vendors code. The properties are one table (Table1), the vendors are another one to many related table (Client). This works fine. However, if the property was consolidated or subdivided...

I don't see an "attachment" data type... I see a "hyperlink" data type....

Hi there! Thanks for replying!! I am using MS Access 2010.... and I am not aware of any "new" way of doing this.... can someone walk me though it? Thanks!

As far as I can tell, there is nothing else running...

thread702-289543 Hi there... I was following along the much loved thread indicated above and it was working fine for me but I ended up getting the same run-time error 2220 that "realflava" indicated on 12-Apr-04 6:25 Realflava seemed to have found what the issue was, but I can't seem to...