Search results

tHANKYOU VERY MUCH IT WORKED

HOW DO I SEARCH ALL RECORDS, DEPENDING ON CERTAIN REQUIREMENTS E.G USING A MIXTURE OF COMBO BOX, CHECK BOX AND OPTION BUTTONS SELECT RECORDS THAT MEET ANY OF THE SELECTED ITEMS. E.G LOOKING FOR A HOUSE FOR EXAMPLE, THAT IS RED, IS BIG AND IS OLD, OR IS ANY OF THE ABOVE THE CHOICES WILL BE...

Do I need to put all the form name in the code "Main form";"second form", if so how is this done

does anyone know how to use a combo box to then go to a form. eg. combo box list has three choices cost form wages form insurance form the operator chooses one which then brings up the form

Thanks a million

Has anyone got a good stock control example database, or do microsoft have one that I coule look at.

If I put in a few subreports into a report, and they are queries. Can I add them all up in the final report.

WHY DOES IT SAY TOO MANY FIELDS DEFINED IN A TABLE WHEN I HAVENT REACHED THE MAX 225

Now how do I add them up in the report, is ti sum function, running sum?

Thanks you have saved the day my friend

chow can you put two queries into the same report, from the same table

Thanks it finally worked however I want to do it several times, can this be done and be put on the same report

Thanks it finally worked however I want to do it several times, can this be done and be put on the same report

Im still stuck Its really simple, I need the average cost for all records over 5. But cant seem to do it. E.g 10 5 10 5 10 Would give me average of 5, sorry for my inadequacy

Ive tried this and it doesnt work I need it to show me the average cost of roofs that have less than 5 years to live >(SELECT AVG([cost]) FROM [Table 2]) WHERE([life remaining]>5) [This message has been edited by fordy (edited 03-12-2002).]

Does anyone know if there is an average if function. i.e show me the average of this field if it is greater than 5 for example.The field is a in this case Ive tried this but it doesnt work =IIf([a]>5,Avg([a])) The field may have 20 records in it for example - life expectancy of roofs amd the...