Search results

will that apply to all query ? Thanks I fixed it

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

This above snap is how I added in the Where condition but below error received

Sorry about the half info, It gives an exclamation sign

Hello Gasman, it did not work

When I am adding the above under criteria the combobox list month name disappear. If I add as where condition in the MACRO Report for all months and all clients is generated.

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

Thanks, I will take this approach.

Surely will do !

Hello DBguy, Perfect !Thanks a million it worked !

Could it be and issue if I am inserting these forms in in a Tab control ?

I have attached the Tables and Form, The billing Form Text 238 label has the formula.

There are other tables associated with forms e.g. dropdown selections, if I do not add those will it be ok?

Tried that way, still Name error :unsure:

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

The fields that I was fixing was to get the default value from another form, during that testing, I had deleted that data and just missed checking that first. Apologies for the trouble.

CJ- The Form title is Member Project Form and it displays Billing for each Member. I found the issue, there was no data in the table, I had deleted it and just missed checking that first. Apologies for the trouble.

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

Apologies, I should have mentioned, my bad. I had tried that way but it did work but as I have 2 query in the crosstab and one query has work packages (WP) that apply to all members and one field WiKCredit for specific MemberID and I want to display the Member Name for that. If I do it the...