I need to have a query that sorts by products received by months for a
report.
I have the following sql and this gives me a total of all the records in the
table by product and then by weight.  I want to add the field [del] which is

It looks simple but  I couldn't solve the problem so far:
I have a  single-column table. The values are boolean.
The column looks like this : 0 0 0 -1 -1 0 -1 -1 -1 0 -1 -1 0 0 etc.
I need to write SELECT statement counting all 0s and -1s like this :

How do I remove a large email from outbox because its too big to send?

Hello I have following SQL:
SELECT qryTempeAccounts.*
FROM qryTempeAccounts
WHERE qryTempeAccounts.[Total Over 60] In   (   SELECT TOP 20 T.[Total Over

I want to know how to, in a querry, have the font change to fit to the cell
size. I can find how to have the cell change, but I want the cell to stay the
same size and have the text shrink to fit.  Thanks , Steve

I have a table that has 3 fields, dDate, Return, MCap
I am trying to get a query that will give me the average of Return for the
Top 10 companies with the largest MCap for each day.
I have the below working, but can only do so for an individual day.  I can't

I have a large access file that has a text field with data in it of various
length that some how got spaces of various lengths at the very end of each
entry. I need to remove those spaces. What is the easiest way to do a query
to remove those spaces? Thank you for any help.

I am  using a validation rule ^[0-9]*$ in my TextBox on Access form which
allows only Numbers to be entered in the TextBox. How ever it doesnt seem to
be working.And I am geting "Please enter Numbers only" validation text every
time I enter anything in the textbox.

Anyone know how to do the equivalent of the excel NORMDIST function in an
access query?  That is:  to convert a z score into a cumulative percentile.
Your comments welcome.

Is there a way to make Access return a number in an extensive way, like I
have the field currency with a value of 34,50€ and I want Access to return me
this number like "Thirty four euro and fifty cents".
Thank you for your help

I am having a problem with the following query
SELECT progress.[progress id], progress.[award  id], progress.status,
progress.[candidate ID], progress.[start date], progress.assessor,
progress.IV, progress.comments, progress.award, progress.[units completed],

Access 97- I have a field that contains a date as follows- 17/11/2005.When I
sort by that field, it sorts by day then month then year. Can I get it to
sort by year then month then day?

Hey, all. I've been assigned a database project at work, and I'm stuck on
something.
The db tracks information related to the time it takes to stage various
shipments for a 2nd shift shipping operation. Shift hours run from 3PM to

I'm just an Access newbie, so I have a really dumb question.  I have
Database A, which contains a link to a table in Database B.  This table has
to be manually refreshed sporadically, using a query in database B.  Since
the end-user does almost all of their work in Database A...is ...

I posted the same tread yesterday.  Please help.  I need to know what is
causing to happen.  
I have a report to run a list of clients that we have not billed invoices
for.  The Control Source of the report is a SQL query, and the SQL query is