Search results

I have a table that I have been using for data collection for a job. However, as the job moves into it's next phase the data collection requirements have changed a bit. Some of the data I had been collecting I no longer need to collect and there is some new types of data I will need as well. I...

That works great! Thank you very much!

Ok here is a dummy database set up similar to mine to illistrate the problem I am having. Keep in mind in my database both of the Tables have many other fields, but I only included the ones relevant to query at hand. Also, FYI this database has been used for quite some time and is populated with...

Here is my problem. I am trying to make a query that will produce a table with a count of projects in different stages. I have 3 groups A,B, and C. Each one of those groups has a number of projects that can be in stages 1, 2, 3, or 4. Each project has a series of check boxes illustrating when a...

That is how I built all of my expressions when I created the FrontTable report. Do I need to change how they are written now that I have put the FrontTable report as a subreport into my main report? Why does it display correctly in report view but not when printed? Do the 4 subreports that feed...

Excellent that worked. thank you. However it has now exposed another issue. It looks good when I am viwing the report but when I switch to print preview and print it some of the values that are displayed as zeros say #Error. Why would it look fine in report view but then show an error when printed?

Needed a standard looking table at the top of a main report. It combines a bunch of information from different queries and combines it. I created 4 reports and then broke the information I needed down, into the individual cells of the table I needed to display, in text boxes in the report...

I never did figure out what the root of this problem was, but I solved it by calculating the STRprogress percent within the report rather than pulling it out of the query. Thanks for the help.

I am trying to calculate a total percent of 2 subreports in my main report for a given area. I have a formula that works well if both sureports hold a value. =Val([DailyManSum].[Report]![EscManPrcnt]+[DailyMechSum].[Report]![EscMechPrcnt])/2 The problem arises When one of the feilds...

I know this is an older thread but i have a question. I have a report in which I am trying to build a table in the main form with textboxes populated with info from the subforms. Using expressions like the one in the example, it is working out well, except - in the final form I only want the...

Ok I created 2 seperate queries, on to total up menual and one for mechanical, and tey work well. I created the below query for summing up totals per county. I only used info from the manual query to start with and it worked great - see below. Then when I simply add the mechanical query to...

Here is a screenshot of the simplified query to try and make my previous rant make more sense.

What if the tables are not directly related? Basicly what I am trying to do is this: I have 4 tables, one that identifies counties by 4 letter code (CountyID) and associates it with the actual county name. The second containcs a list of all the segments in all the couties. For Gulf county the...

When I do that, either way, and then try to run the query it give me an error that says: "The SQL statement could not be executed because it contains ambiguous outer joins. To force one of the joins to be performed first, create a seperate query that performs the first join and then include that...

Thats what I was thinking but in the query it is formatted as a double and works fine, while in the report there is no place to choose between integer or double. Under format ihave it selected as a percentage. I think I may just have t add an unbound box into the report and do the calculation in...

Don;t imagine it would but I am only dealing with 5 counties, so that is not really a concern for me. I can now arrange it in a report loike it looks in the query but I have more catagories of summed data that I want to display. THus if I keep it displaying as it is in the query it doe not fit...

Is there a way to create excel style reports in a report? I would like to make a table from the information in a query. I have the query sorted by county with all the other information summed or averaged after it. So there is a line item for each county. But in the report I would like it...

In my database I collect information from manual teams and mechanical teams seperately. Each report the amount of material produced and location as well as various other information unique to each team. I am trying to make a single query that will give me the total material produced from both...

I have a report setup up that is pulling data from 2 queries. The first query (SegProgress) calculates the percentage complete of the work segments. Groups of segments belong to STR's, so the second query (STRProgress) is used to calculate the percentage complete of each STR. I have it grouped...

Thanks for the info. I figured that may be the case. I think I will build the form in excel and have it dump all the info into a tab that mirrors the data table in access. Then it should be simple enough to just import it.