Search results

thanks for the help :) i have sorted the problem; i was entering the In formular in the wrong field, it needed to go in the criteria field. Thanks Again

sorry im not sure what you mean by SQL? I am using microsoft access, im not quite up to play with all the terminology.

thanks, i get an invalid syntax error: "You may have entered a comma without a preceeding value or identifier" do you know what this means?

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

thanks for the reply but i have just solved it. I feel like an idiot but i was missing the space between the 'retro' and 'fit'

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

im using a button which, when clicked is saving the file in a selected format, However i have just solved the problem, thanks for the quick relpy

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

hey guys thanks for your help, i got rid of the passwords in then end, not sure how i managed it, but i got there any way Thanks

im trying to have it so all you have to do is choose the store from a list and the query will display all the repairs completed at that store with costs and total costs

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

yes i am lost :) Can you go through how i would do this or is it too lengthy? Just to note: When i open access from the start menu and create a new database(or open and existing one) i get a window with my name in it asking for my password, the password i set up for this does not work and i...

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

hmm, i think i have but it is still the same, i must be doing something wrong. For now i might run with the PDF Jman is talking about Jman I have sent you a PM with my email Thanks guys

im not quite sure what you mean....yes i have been going throught the special shortcut. I have set up two users one as staff who area member of the 'full data users' and on as myself and i am a member of the 'admins' (they both have passwords when the data base is opened)

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

Thanks very much for your help. I have been doing alot of reading and am beggining to understand what you mean. Your help is most appreciated :) One further question... If i wanted to group the repairs on each of the doors into mechanical fault repair, electrical fault repair, damage repair...