Search results

I want to add some security to my database, with three users:- (1) Full access with read/write/update/delete access with the ability to modify designs, queries, relationships etc. etc. (2) Normal Access - able to use forms to read/write/edit/append/update data in tables as well as run queries...

How do I set an empty field as curreny with 2 decimal places within a make table or update query. This is the query I have at the moment: SELECT Order.[Order Number], Order.[Contract Number], Order.[Company Name], Order.[Contact Name], Order.[Date Required], Order.[Net Amount], "" AS...

I am currently developing a database to record a number of orders, delivery tickets and invoices which come into a company. To perform calculations etc. tables are deleted, appended and primery key violations occur etc. This is exactly what I want to happen as it ensures all dtaa remains...