Search results for query: *

Is there a way to do this? I see there are macros to automatically run every night, but how about to run it when a table is updated.

Any way to specify a field width of the resultant table in my Make-Table query? I want to run it repeatedly as new data arrives in another table, so editing the resultant table is a poor option. Even though "Trench" is width 12 in my original table, it becomes width 50 in my new table, where...

I have a form which is based on the following query. The two tables are related: tblContacts has the primary key ID (Autonumber) and since each contact may produce more than one commodity, tblCommodities.ID is a foreign key. SELECT DISTINCT tblContacts.ID, tblContacts.[Last Name]...

I have a query which is performing 2 calculations. The first one is a 2-part calculation called AcresDiv5. In the first part, it sums all the crop acreage on a particular site, and in the second part this sum is divided by 5. The second calculation, called SumDevices, is the sum of all...

I am trying to run a macro (attached to a command button) which will find record(s) matching a user-typed field. A problem occurs if there is more than one record matching the criteria. I want the macro to go the first record, then if run again to go to the next one, and so on. But it just...

Hi, I have a subform called "Varieties" on a main form called "All Farms". The All Farms form displays information for each farm, one at a time. The varieties subform is a continuous form showing information about all the varieties found on that farm. I have an ID field which is a PK on All...

I have 3 tables I want to use in a query: 1. Concerned Parties (includes name, phone, etc.) 2. Complaint Records (includes ID, date, name of complainant, BusinessID complained about) 3. Business Addresses (includes BusinessID, Business Address, Region) There are some complainants who make more...

I am trying to create a query which selects the record of each ID with a maximum value. I need to use 3 fields from my table: 1. ID (foreign key) 2. Variety 3. Acres I want to select the record for each ID which has the most acres of a given variety. So if my table looks like this: ID1 Blue...

First of all I have a table called Varieties. It has 4 fields: ID, Variety, Acres, Year of Planting. From this I want to make a pie chart of the total acreage of each variety, with 6 categories: 4 slices of the 4 most popular varieties, 1 for other, and 1 for unknown. Here is my query so far...

I am trying to create a query with one field called "Complaint Type". It will get data from two fields in a single table called "Complaints 2003", the fields are "Type1" and "Type2". The idea is to create a pie chart with all the complaint types summarized by type (noise, frequency, etc) without...

Hi, I have a table which has a numeric field Acreage. This field is set to Number/Single/Auto Decimal Places. Most values have no decimal places, some have 1 or 2, and a rare record has 3. However, in my report, I group some of these records and sum them, and the decimal places in the report...