Search results

The reason for the number of queries feeding the main query is that I cannot think of another way of getting the results in a single query. Each sub query has the following data: Contract number, planned visit 1, actual visit 1, date (between 2 dates), Fix (number/digit code). The constant will...

Can I create a query from multiple queries? I have tried to do this, but come up with blank results. In the design view I have 2 tables providing source fields, and 4 queries.

Any thoughts anyone?

Ok, I have a partial solution! Using sub forms I have managed to get exactly the data I need in the Detail section. I cannot get the calculations for the Report Footer section though. Using the Expression Builder I have tried making the control source =Sum([Reports]![RSub1stFix]![1st Fix Men...

I thought I had created the report that I need to save me hours of manual calculation! However, it is bringing in some irrelevant data, which is corrupting the results I need. The attached file is a screenshot of the report in question. Each columnular section details the number of men sent to...

I thought it might not be as simple as I had hoped. Thanks for the help anyhow! ;)

I see what you are saying. However, the calculations required are in the report's footer - they are totals/percentage calculations based upon other calculations in the footer. e.g. TxtBox1: Totals of column A TxtBox2: Totals of column B TxtBox3: Totals of column C TxtBox4: TxtBox1 + TxtBox2...

Can a chart be created from a field within a report? The fields in question contain calculations based on data from a query. When trying to create a chart, Access will only let me see tables and queries. How can this be done?

I have come across the below advice on how to use a form to select a date range for a report. It is very simply described and might be of use to others! --------------------------- Step 1 Create a query to feed data to the report. Add any necessary parameters (like the "between [start_date]...

Ok, I have gone down the sub report route and am getting the desired results. Much simpler for me to do! There is an issue though with the date restriction. I have both the report and sub report set up so that a start date and end date are required, so restricting the results to a certain time...

Changed. It was actually the name of the field in the report only. The table behind it had a different name. Still no results with the dlookup expression.

Bob, Have I understood right? This is what I have entered: =DLookUp("[C/Q Number]","qryFixCount","[Date] Between #" & [Date] & "# And #" & [Date] & "#") [C/Q Number] is the field within query 2. qryFixCount is the name of query 2. [Date] is the name of the date field that is being restricted...

All I need from the second query is the count of the number of items listed in one of the columns. The results need to be limited to being between the two dates required for the rest of the report. Can DLookup handle this, if so how would I go about it? I have never used DLoopup! Thanks.

Can 2 queries be used to populate a report? I have a report that is totally finished, except for one field. The one field needs to be populated with data from a separate query, which in turn takes its data from a linked table from another database. Try what I may, this field will not take the...

The datasheet for Access 2007 states the maximum no of fields is 255. 2003 will certainly not have any more than this.

All sorted! The correct expression is: =IIf([Visit Date]>#30/04/2007#,NZ([Project Eng Hrs]*58.74)+NZ([Install Hrs]*21.84)+NZ([Mat £]),NZ([Project Eng Hrs]*48.85)+NZ([Install Hrs]*19.49)+NZ([Mat £])) So simple and so frustrating:D Michael thank you for your guidance. It is what eventually got...

I have tried replicating the formula but am still getting nowhere fast. The control source expression for the form (one of the fields in question) is: =IIf([Vist / Raised Date]>#30/04/2007#,NZ([Project Eng Hrs]*58.74)+NZ([Install Hrs]*21.84)+NZ([Mat £]),NZ([Project Eng Hrs]*48.85)+NZ([Install...

I have worked out that the report shows the data for the record of the page of the form that is selected and gives this as the report results for all records. If I am on record 10 in the form that figures for that record will show as the report results. If in record 46 those will be the report...

I have partially resolved the problem. I had linked the wrong query to the report :o :mad: . The material costs (taken from report) are coming through ok, but anything from the form fields is showing the results of a single record - even if the record is not within the timescale of the report...

Thanks Michael, I am now getting figures, but just 0 through all columns! The data from the form is not coming through.