Hi I need to know what I need to do to make my query do something like this: IIf(! = !, (append only the fields and to current record), (append all fields...

Hi I have a parameter query.. by city name.. i want to display according to the city and its population by year.. So i would like to display the city names...

Hi, okay so I have two tables, one has a phone number field, where the other has more accurate information but no phone numbers. When I run a duplicates...

Hi, I have a table with 20 Yes/No fields which is populated. I have created a query which sums each field and populates a report. The problem is it counts...

Hi All- I have been looking for a simple way to take the results of a parameter query which are displayed in a form, and view/print them in a report via a...

I have a database that contains a list of vehicles, vin numbers, amounts owed. Different employees save a copy of the Master database to their files and use...

Is it possible for a report to pull information from 2 different query's. One query is by date and the other is not. Thanks for any help Roger

I would like to print labels from a list of address on a form using check boxes, the check boxes must clear them selves after the labels have been printed. I...

Hi, I have a report runs off a query and a form for users to enter the criteria into pull this report - so far everything is working good. I have 2...

I have the following data sr no1. no2. no.3 no.4 no.5 no.6 1 1 8 11 25 30 32 2 4 8 19 28 30 45 3 7 14 20 ...

Hi I have two customer tables, the first is much older but more complete, however the newer one has more up to date email addresses and fax numbers. I want...

Dear All, My organisation has recently upgraded from Access97 to Access2002 and many of the reports I built in Access97 no longer work. The error message...

I'm trying to make a query that totals bi-monthly rather then monthly, can't quite get it. Any help would be greatly appreciated. This is want I'm playing...

I now need to use my form to show only certain records from my table. (duh) I don't know how to a: question the user for input for the query. and b: input the...

In Access2002, I have a form with a listbox, where a user can select multiple line items. I'd like to pass all of the selections into a query, so that the...

I am not sure how to word this question but I made a query from lists whose values are selected from a combo box. The query has the text values from the combo...

Don't know if this is a query querie or or report querie but here goes: I created a summary query from a table that has 4 fields. The data source on three of...

I have a query that results in 3 records. When I run a report based on the exact same query it only show 1 records. Any idea why this may be happening???

The query i created has 3 fields that have criteria on them. I want the query to return all results that do not have all three of those fields as null. ...

I hope someone can tell me what I'm missing here... I have the following query: SELECT ZipData.EventID, ZipData.ZipCode, ZipData.Count FROM Events INNER JOIN...