Search results

No. Report is the only thing open in Access.

No. The quotation marks were just there to separate the expression from the rest of the text. The rest was entered as the control source but brings up #Name? The name of the form fields is correct. It is entered using the expression builder, double clicking on FORMS in the left column, finding...

In my report I am trying to get the results from a calculation field within a form. The control source in the form is not an individual field, but a field added by me with the sum "=[fieldA]*25.98". i.e. in the form the field calculates a figure. When trying to build the report I have made the...

Perfect. Thank you!

Can anyone figure out what is wrong with the below expression? =IIf([Vist / Raised Date]>"30/04/2007",[Project Eng Hrs]*58.74+[Install Hrs]*21.84+[Mat £],[Project Eng Hrs]*48.85+[Install Hrs]*19.49+[Mat £]) The field should return me the sum of the project engineer's labour, installation...

Hi, I have incorrect results in one of my reports. In the report footer I have the running sum results of a calculation in the Detail section of the report. This works fine in all but one column. The problem column provides the results of [Column B] - [Column A]. The footer calculation should...

I have a query that also outputs the data to a report. Both have the following fields/columns: Project manager; Contract number; End user; Site Name; Activity Date. The data that is out put for both query and report is correct, except for the duplication. The duplication occurs because for each...

I am having real trouble with a very basic adding scenario. In my report footer I have a field [Total Men 1st Fix] to total up the results of the columns in the detail section and a second field [Total Cost 1st Fix] that calculates a currency value based on the results of [Total Men 1st Fix]...

5 project engineers is correct. Their names are all records within the ProjE field I have probably explained it badly. In the main detail section of the report each and every job is listed with the project engineer's name, job number, client name, client site. This is laid out in a tabular...

This should be a simple problem to solve, but not for me! I am trying to get a simple 2 field result in the Report Footer. The 2 fields are "ProjE" and "Total Open Projects". All that I want is a list of the 5 Project Engineers and a count of the number of projects associated with their name...

I have a report that shows me the difference in planned against actual manning. It draws its data from a query. The fields in both report and query are (except for fields beginning "Additional Men..." which are not in the query): C/Q Number; 1st Fix Men Plan; 1st Fix Men ACT; Additional Men Rqd...

RG, You may not have seen the above post as it only just went in. Yes I tried it and it worked perfectly. Thank you so much!!! :D

Thanks again Bob. Rural the rewrite solved the problem instantly! Thank you all.

Bob, How would I go about that? Is there a specific bit of coding that needs to be used? I am very new to programing languages and am having real guess-and-hope for the best attempts at modifying code that others have written!

Thanks MStef, finally worked out my error. I had not made the 2 entries, just for the field and not the form.

I have some VBA code in the On NotInList event for my main form. It works fine except for one bit. If a new account manager is entered into the form's field, the frmAccount Manager is opened to enter the new name into the tblAccount Manager. The code should be checking to see if a name already...

I know there are a number of other threads on this topic on here, but having looked at them all, I cannot make my "Date Last Amended" field autoupdate when a change is made within a record. The table field is tblDate_Last_Amended; the form field is frmDate_Last_Amended. I have tried a number...

Anyone, any ideas?

Thanks I will give it a go - might be beyond my basic knowledge of Access, so might come back for more advice!

Is it possible to automatically filter a sub form using the main form's primary key as the filtering criteria? I have a simple 3 column sub form, which displays the results of a query. The middle column is a list of client reference numbers, which are also the same as the primary keys. The sub...