Search results

I have a two tables related to each other; table A contains information about stores that my company services, and in this table there are 3 different types of stores: A,B and C table B contains information about the invoices for each of those stores. I have a query which retrieves...

I have a report which has a calculation for five different costs: mechanical, service, damage, elecrical, retro fit, and one for the total of the five. each expression looks like this (but with its relevant heading in the place of 'Mechanical'): =Sum([SumOfMechanical]) i need to find the...

Hi I am trying to run a report off of a query which contains 37 fields. When i run the report wizzard it says that there are too many fields. Is there a limit on the number of fields a report can have? and is there any way around this? Just to note i have one report running off of a...

I have a query which returns records in 5 different fault categories; mechanical, service, electrical, damage and retrofit. The values the query return are based on another query and are a sum of the amount of money spent in each category. I have put a sum fuction in the 'field' box like this...

Hi i have a report that displays the total cost of repairs for individual automatic doors. The total cost is retrieved through a sumation query and displayed via the report. The repair costs are broken down into five categories; mechanical, service, damage, electrical and retro fit I am...

Hi I have a report running in my database and i have created a form which includes a button to send the report to file, i want to send it in HTML format but when i save it, the file is unrecognised by my computer. To make things stranger i can open the report (from reports menu), go to the...

I have a data base with three tables regarding: shops (table one), their doors (table two) (automatic doors), and the repairs done on each of the doors (table three) There are over two hundred stores in the data base and I have to write a summation query for the repair costs for each store...

I have been following a text book to try and secure a database, i set up the Work Group Info File, allocated a password, now even when i want to start a completley new database i have to enter a password......... AND when i set up the password i must have enetered it wrong now i am completely...

Hi I have just put together a small database, and have used the user-level security wizzard to set up groups so i can restrict access to the database. I have also been through all the user and group permissions and tried to set the security up so that the data entry staff can enter data but...

Hi I am currently setting up a data base for my work and was wondering if there is any way to do the following calculation: I have a database of automatic doors that are contantly being repaired and i want to keep a record of the accumulated costs involved with this. I have set up a form...