Search results

I need some help figuring out how to make this query work. Essentially I have a table [Activity] with the feild "RecordedConcentration" with a numeric value. I have a second table [Assumptions] that defines the "Catagory" (for a given area) based on "Concentration". What I want to do is for...

I have a form that I am using to collect information about complaints we receive from the public. Once we receive the complaints it is my job to dispatch one of our feild teams to respond to the complaint. What i would like to do is have a button at the bottom of the entry form that will send...

I am trying to create a form to log complaints from the public. We frequently receive complaints from the same people over and over. Instead of duplicating data about the complainer I have decided to make a table for just complainer contact info and a table for complaint details tied to each...

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

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

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

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

I want to create a complex for (not just text boxes) with combo boxes and the like that I can export to excel or a e-mail and have field teams fill out and send back. When I try to export to excel it just copys the data and no combo boxes or formating. And in an e-mail it seems all you can do is...

I am trying to get the information in one feild to complile based on the information in 3 other feilds. Basicly, I have a SegmentID feild tat I want the data to be created from the County, Division, and section values. So if County=FLES, Division=1, and Section=-001 Then SegmentID=FLES1-001...

Is there a way to make the values displayed in a combo box change depending on the value in another combo box? I have seperate columns for county and city and after you select the county I want it to only dislay cities in the selected county. Thanks for the help.

I am just figuring out how to use Access 2007. I am constucting a database to track productivity of a large number of feild teams. Each team turns in a a report every day detailing their progress. What I need to be able to do is record all of the information for each of the individual teams and...