I have an irritatingly small querie that I'm struggling to write...
I have two columns of data in a table. The data contains letters, numbers
and underscores and also varies in length. The columns are of equal length.
All I want to do is count the number of unique pairs in this ...

I use a database to manage the items used in a project.
I use an Items table with the fields of ItemCode, Category, Model, Location,
UsePeriod, VendorID and Cost and a related Vendors table with the relevant
fields.

I'd like to run a query where I count the number of a certain disease within
a time period.  When I add to the query design disease, disease (count), and
date received (to select a particular date) I end up getting a count of each
disease per each date.  I want a complete count ...

Hi,  I am sure I learned how to do this at one point way back when but, I
can't remember how.  I have two different sets of data:
UWI is made up of the fields: LE, LSD, SEC, TWP, RGE, MER and should look
like:

I have a table that has a field for a begin date & a field for an end date.  
A person may check into the shelter on 6/15 and leave on 7/15, for example.  
The problem is I need to figure out how many days we supplied overnight
housing for people for the month of JUNE only.  Can I ...

I need to round numbers in Access to the nearest integer, where I'd round up
if .5 or greater else round down.  For example, need to round 33.5 to 34 and
33.2 to 33.  I do not want to simply change the properties of the field...I
want the actual rounded number to populate the ...

I am trying to get a Crosstab query to work properly.  I can data to show but
it is sorting
Apr-04  Apr-05 Aug-04 Dec-04 Dec-05
I realize that when I formatted the date in the test001 query that it

I un-picked show columns.  Then saved.  Columns are still there -- they show
in the table view -- but I can not see them in design view.  Maybe have a 0
width.  I want them back, with some width.  I am then going to put them back
to 'show'.  I have tried dragging columns to the ...

Can anyone tell me what is wrong with The following Query?
I have two Queries one is base on another.
"Inventory Transactions Query" & "QOH Query"
Inventory Transactions sums all data [UnitsReceived],[UnitsUsed] & [QOH]

I need to calculate how many cases have been open for 11 months. How can i do
that in a querie.

I have an update query that is supposed to update one local table from another
local table:
UPDATE  
 tblDmdYearlyReviewByMonthSummary RIGHT JOIN

I am creating a query to look up ID numbers.  I want the user to enter a
portion of text found in the field ProjectName and then return those
ProjectIDs that have the entered text.  I cannot seem to get it to run
properly.  In the criteria line I enter:

Simplist query imaginable.  1 table, select three fields from that
table.  No criteria, no joins, no nothing.  One of the fields is a long
integer field, but only contains numbers up to three digits.
I run this query, and it returns zero for every single record.  this is

I have a DB that was created by another user that I am trying to fix.  
Ultimately, I need to produce a report showing monthly and fiscal year
totals.  Currently, the report is showing the monthly totals, but I have no
idea how to define the FY.  Our fiscal year is 1 April. 2005 ...

How can I print all data that contains a required single word not the whole
field.
We want to extract the whole data that contains our required word, the
FILTER option can be used but it fiters the data by Whole Field but not by