Search results

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?

Can you map out an example in Excel or Word ?

Can you give me an example of which values the User would be able to select for the Group Combo ?

Hi Whenever you look at a Template provided by Microsoft it always contains Field names with spaces and characters like )(*&^%$£"!/?, which should not be used. Also, a lot of fields use Hard Coded values when these hard coded values should be listed in a sperate table. Best to use the Template...