Recent content by Manaz

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