Search results

I have a form, which will use various sub forms and comboboxes. The database I am creating is to track non-conformances across the business. The combo dropdowns will be different depending upon the department selected (Engineering, Manufacture, Installations, Service). Is there a way so that if...

I am having real problems with a cascading combo box, which I cannot get right. There is a subform in my main form which lists and records the products on each job. This subform shows in datasheet view. Each line records the product, size extras and type. It is the type that should be a...

I am trying to create a calculated field in my form. The calculation I am attempting to create is the cost of installation labour. In my table1 (the table where the calculation will occur) I have a date field, installation hours and the unbound calculated field. There is a separate table...

I am not sure if this best belongs in the Report or Query forum. I have been asked to create a report which details line by line (each line a contract number) the products sold in a given timeframe against that contract. Most of the report has been easy to set up, but I do not know how to do...

I have a form, which contains both sub forms and sub-subforms. Everything is working correctly - except for one annoying (and potentially dangerous) thing. When a new record is started, the data is logically entered into the main form first, and then each sub form thereafter. However, What I...

I could use some advice on how best to structure a query. I have the following fields: Contract, Activity Date, Product1, Quantity1, Product2, Quantity2, Product3, Quantity3, Product4, Quantity4, Product5, Quantity5 At the data entry stage Products1-5 are entered from a combo box, which...

It has been a while since I last set up a new database and I am having trouble with a main aspect of the table design. My database is to keep a log of all projects within the company. The area I am having trouble with is how best to set out key data within the table(s). The following fields...

Still having grand total problems in my report footer! I have followed Microsoft's instructions under support.microsoft.com/?kbid=208835 At lease I am getting a result, rather than an error, but I do not understand the result. As the article explains, I am sending the sum results of the...

To try to get over some of my previous problems, I have tried using a Union Query - I understand this might help me get the results I need. Below is my SQL, which is meant to combine the results of the 10 individual queries. Have I misunderstood something, or not done something right? I am...

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.

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

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

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

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

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

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