Search results

Hello All, I have 2 single Query and one combined query. Query 1 record are displayed when i run it and so are Query 2 records displayed. When I combine both (query 1 an 2) Query 3 for the report, one record of query 1 does not appear, how ever it does appear in Query 1. SQL QRY 1...

Hello Experts, Not sure if this is possible. I need to open a report with 2 conditions. I have a Form that has a combo box (BarMonCombo) with all Months listed. Then I have a button which has the client name, when user selects month and client name the report for the selected month for that...

I have two forms 1st Form displays a payment schedule which has a column with field Funding Amount and in the footer Total Project Amount. 2nd Form displays a invoice schedule which has a column with field invoiced amount and in the footer total invoiced. Is it possible to check if both footer...

Hello Experts, Can someone guide me I have a form Default View setup as continuous form but it displays only one record. Previously it was showing all records, I was fixing some fields and now I do not see all records. I have another form same setup and its working fine. Not sure what is incorrect.

Hello All, I have a Form with 3 combo boxes. The option selected is referenced in the query I am adding under criteria Like [Forms]![TestReportWPForm]![CmbPrgArea] to pull data based on the selection in the form. When I add the query name in the record source form, the Combo box disappears. I...

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

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...

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...

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:

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...

Hello Experts! I am beginner level and any guidance will be a blessing! Just cannot figure out what went wrong as initially the form was working. The Query is returning the correct Number the issue is displaying in the Form. I have a footer Total value that comes from a query. I tried DSum and...