Search results

Hi Pat I have spoken with the OP and explained to him that all his calculations should be carried out in a query rather than in the Report it self. His problems have now been resolved.

Hi Are you able to upload a copy of the database with no confidential data?

Hi Barbara Are you able to upload a copy of your database so we can see if we get the same error's?

Glad it works for you. There are other ways of displaying the Data which might suit.

Did my example help?

Hi Albert Did my example help?

Hi Here with the db attached

I would suggest that it is easier to use a Main Form with Related Subforms to Manage this process. See attached screenshot.

Hi DakotaRidge Just out of interest as I do not know how, in the attached database supplied by BlueSprice, how would you calculate the number of Employees whose Certification = CSP ?

Can you upload a copy of the database?

See attached

You would normally do the calculations in the subform as shown in the attached screenshot. My apologies the Labels in the subform should be as follows:-

You appear to have a Control on the MAIN Form named "DiscountAmount" as well as a Control on the Subform named "Discount". Do you want to calculate the Discount in the Subform and then display this on the Main Form as well?

Hi Anelgp Very neat. Added to my things to keep. Many thanks

Many thanks theDbGuy. I see that you added the extra field with the Filepath. Works a treat. many thanks again

Hi Everyone I apologise as I have never worked with Logos previously. I have a table named "tblFSESub" with 2 fields. Field 1 is "FSE" and Field 2 is "Logo" In the field "Logo" I have entered the path to the Logos as shown. I am then trying to generate a Report so that when a Specific FSE is...

Hi Larry It is not Garments but Wardrobe Furniture that is being covered.

Attached screenshot is 3 Levels of Subform The 2 coloured controls above the Label for Level 2 Item Details are Form references to link Subform to Subform as suggested by Welshgasman

6 or even 10 subforms would be a lot of setting up.

Just out of interest, why are you not using Bound Main Form to Subform to display Product Detail in the Main Form with related Product Details in a Subform?