Search results

Thanks for that. Are there specific Locations you install Machines in a Property?

Can you give us a list of Machine Types you install ?

Hi Can you explain the use of "tblPayRangeAssignment" ?

What are the various "Types" of Properties that you install Machines in?

Can you upload a copy of your database?

Upload the database so we can see what you mean.

Your sample database has a few problems in table design. 1. Product Table Product_Actual_ID PK set as Text - It is recommended that the PK be set as an Autonumber - LongInteger Datatype Category field set as a Lookup - You should not use Lookup Fields in Tables 2. StockIn Table StockIn field...

Hi Pat Yes. Also the fact that fields in tables which were supposed to be numeric were in fact text due to Import from an Excel file.

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