Recent content by mike60smart

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