Search results

Hello all, I need a new pair of eyes to check the syntax error I am getting "Missing operator in query expression 'MemberID=' Member Name: DLookUp("MemberName","MemberTBL","MemberID=" & [TestingProjectWPTable Query].[MemberID]) I need to get the Text field value to display, Thanks Taruna

MemberID is not a part of the formula, I displayed that for explanation. I want to include DocumentTypeID in the formula CCur(Nz(Sum([CurrentBudget]/[SumofMemberShare]*[MemberShare]),0)) so if DocumentTypeID is 1 then I want SumofMemberShare 9.5 to be used. Currently it is replicating by...

Sorry its is work related and I am not allowed.

I have it clear in my head and honestly I am struggling to put in words, I had shown a table above explaining that but seems the visual is not clear. I want the formula to use the The sum of share for that DocumentTypeID e.g. (using data from above table) DocumentType ID is 1 then it should...

The code that I have given, is where I want to add DocumentTypeId but I need to know how. When the code is executed the sumofmembershare for that DocumentTypeId should be used to calculate.

Hello All, Really appreciate some guidance on this and thanks in advance ! I have a table that has following fields Table A ProjectID, DocumentTypeId, MemberID, MemberShare Table B ProjectID, CurrentBudget Query 1 ProjectID, SumofMemberShare, DocumentTypeId, MemberID I have formula in a...

I tried the above and the value does not display PIVOT [TestProjectCostFieldsJPPQRY].[MemberName] & ", Share " & [TestProjectCostFieldsJPPQRY].[MemberShare] ($ value displayed)

I tried this Headers appear but values do not appear in query. But when I add this PIVOT [TestProjectCostFieldsJPPQRY].[MemberName] & ", Share " & [TestProjectCostFieldsJPPQRY].[MemberShare] this way values and header appear ; But with this option in the report the fields that are empty show...

But I will have duplicate ProjectID

Thanks for the response, I am a beginner in access so what you see I do not yet. Both tables are setup in this way as there are stages in the process that I need to follow and I was trying to make it work that way, from what you are saying I need to add 2 more fields Name and Revision# ?

Hello Mentors, I want to understand the logic of how I can get this working. I have two tables JPPNewProjectTBL and ProjectCostTBL. I need some fields appended in the Project Cost table but there are multiple criteria's. Fields are ProjectID MemberID DocumentTypeID JPPMemberStatus. Criteria's...

Oh thankyou very much !

Hello Experts, I am wondering why this is not working, I want to append only if criteria # is 2 but when I run the query it displays record with criteria 9 to be appended..:unsure:

TRANSFORM Sum([SumOfCurrentBudget]/[SumOfMemberShare]*[MemberShare]) AS MemberCost SELECT [TestingProjectWPTable Query].ProjectID, [TestingProjectWPTable Query].DocumentType, [TestingProjectWPTable Query].WPName, [TestingProjectWPTable Query].SumOfCurrentBudget, Avg([TestingProjectWPTable...

Hello TheDBGuy, Appreciate your response, I did start the new thread. I responded on this above as it was similar to my issue. I am not sure about the In() Clause as you suggested, I am still newbie., help please!

Hello All, I have a Crosstab Query I need to display All Members even if there is no value associated and it should display $0.00 Currently it is showing 2 but if I add them under the Property Column heading I thought it will display, which it did but then I do not get anu cost breakdown in...

Initially I had tried and everything was working fine, later it went all crazy, I had to redo the database as there were issues. Now this is working same formula. thanks for the response.

Hi I am a beginner with access, I was working on the Crosstab query and I had the similar issue. As you suggested I did Add under Property sheet the Column headings, how do I define it under the Design View for Column Heading. ? My calculations do not work when I do it the above way their is no...

I had tried that but not working same error

Same Error, Thanks for response, appreciate you removing time.