Hello can someone help me?
i have this sample table

I've used  the following to count the number of records in my table:
DCount("*","Rooms") and it works great to give me a total of all the
barracks rooms we have. Now I need to count the number of rooms that are
empty and full. Easiest way to determine is if the "Last_Name" field ...

I have a query that has 6 criteria (No mail AND group=10, no mail AND
young society=true, etc.). If someone meets more than 1 criteria, they
are listed twice. How do I eliminate this? I've just been creating the
query in design view, so I have the AND statements on the same line

'll be pleased if somebody could help me generate an expression or better
still a statement that will evaluate a value in a field and represent it with
a txt in another field.
Is thre a way out?

I have just created my first ever crosstab query and have a couple of
questions.
1.  It seems as though any fields in a crosstab query that don't have a
selection made in the "Crosstab:" row in the design view won't show up...

SELECT qrtrimdateformat.MSC, qrtrimdateformat.Date, Avg(qrtrimdateformat.
HOFailIntra) AS AvgOfHOFailIntra
FROM qrtrimdateformat
GROUP BY qrtrimdateformat.MSC, qrtrimdateformat.Date;

The following query works with Access linked tables:
SELECT ACCOUNT, Date() AS [Current Date], 0 AS Historical
FROM [Local Exchange G/L]
GROUP BY ACCOUNT, Date(), 0;

The database has a series of tables each of which starts off with the
same catagories of fields - location location ID and shift. It can be
done more efficiently, I know, but I want to walk before I try to run.
A query has been set up on all but one of these tables to return all

I hope someone can help?
Have a Notes table that has a unique id (Autonumber), Account number, notes
field
and datetime field.

I have a crosstab query that is pulling data from 4 tables:
Project, which is on the one side of a one-to-many relationship with...
Bid, which is on the one side of a one-to-many relationship with...
Item, which is on the one side of a one-to-many relationship with...

My mind is running in circles on itself trying to find a solution, or series
of solutions to this issue. Any assistance is deeply appreciated.
I have a table, which gets sent to me from a contracted vendor as a
spreadsheet, and I have to 'clean' the table of human errors ...

Hi all, How can I remove the first space from the following Postcodes :
B 1 0FD or B 3 1GF
thanks Garry

I made this query:
select CONSIGNMENT_CODES.CONSIGNMENT_CODE,
sum(INVC_DETAIL.QTY_SHIP*INVC_DETAIL.UNIT_PRICE)
from INVC_DETAIL, CONSIGNMENT_CODES

I have a table with dates as the records and prices as the fields.  I want to
do a query where a person can input a date and will get either that date's
prices or the prices on the next previous date before their input date.
<= gives me all of the dates prior to the one they input

I have a memo field whose data has a blank line as the first line in the
field.  The data starts on the second line.  I got the following query to
return the records, I just cant figure out how to update the field to remove
the blank line.  The line that looks blank contains the ...