I have a DB with a query and the following criteria:
Like "*" & [Enter By Number or Beginning of Description: ] & "*"
This brings up a general ledger code use in our acctg dept.
now if the user types in something no way near a match, the form comes

I'm trying to calculate an average of three fields within one record, without
success.
The three fields are Score1, Score2, and Score3.
My expression is Expr1: Avg([Score1]+[Score2]+[Score3])

Hi to all,
I've created a query using UNION ALL statement in this way:
SELECT item, SImported, SExported
FROM [SELECT item,sum(import) AS SImported, null AS SExported

I would like to construct a query from a table with a debtor name field.  The
select statement needs to exclude all records that have the word Corp, CO,
Ltd, LLC, or Company in the field.  Basically I want to eliminate businesses
and leave only individuals.  I also do not want to ...

Can someone help in this issue...please
i have a table called sales with column...
Petrol |    Diesel |   Motel    |  Store  |
500   |    600    |    44       |    200   |

I have many duplicates in a table after running a duplicate querey.  I want
Access to tell me how to delete just the duplicate rows.

I have a table that lists account number and product number.  I need to
create a query that shows me all of the accounts numbers that purchase
product number 590 and 710.
I thought this would be an easy task but I am really struggling.

I am having trouble with this query, it does not show any data if the
Employee_id does not match what I have on file.  I woudl like the query to
show the data and tell me "NO match of employee Id found" Is that possible?
SELECT DISTINCTROW ALID0001.scans, ScannAction.Scanname, ...

I have a table (tasktable) of timesheet entries that includes data for
employee tasks that includes numerous fields including (taskid), (empno),
(jobno), (hours), (charges) .  I also and a table (emptable) that includes
data for each employe including (empno) and (empcat) where ...

Hi. I have a query that sums "Bucks" for each Contact.  It works fine.  Some
Contacts have Spouses that are also Contacts.  In these "family" situations I
want to add together the sum of Bucks for the family.  I can't quite figure
it out.  Here's 2 queries that I'm working with:

I have a table which contains stock numbers and URLs to photos of those stock
numbers. I need to AutoNumber the records within each stock number group.
i have this:
STOCK|URL|NUMBER

I have a query that divides two different fields.  The denomonator in one
called QuarterlyTarget and is sometimes equal to zero or blank for some
people.  When I run the report, the people who have a zero or blank target
get a #Error message which then shows up in my access ...

Please I need an answer asap.Very appreciated....
There are 2 col named TaxID and Vendor#
I want to find. Show all records where TaxId is the same and Vendor# is
diffrent.

I am trying to calculate a running sum for the following table with the 3
fields listed below:
tblFullDataTable
ID

How do I make an unsupported object into a support object when combining two
queries?