When I launch a delete query, i always must klikk 3 times yes, yes , yes to
get it done. What shall i do to get none ?
Thanks for all answers !

there is a field that contains numbers using . for decimal so i need to
create a field that replace . (dot) to , (comma)
the numbers are like 3 not 3.00 or 3.1 not 3,1 or 3.01 not 3,01 so if there
are number without decimal does not present .

I've got a query which uses [Enter Date:] in the criteria to prompt the user
for the date.
The date they enter will Usually be the Current date...but not always.
Is there anything that can be added to the prompt that will automatically

I have a crosstab query that I need to display zeros if the field is blank.
Here is my SQL statement. Any help is appreciated.
TRANSFORM Count([Arrest table Query 2].[Arrest date?]) AS [CountOfArrest
date?1]

Good afternoon,
I'm trying to exclude results returned by a query.  I have a field  which
has the following values: Released, On hold, Maturity A, Maturity B and
Maturity C.

What I have is a query. A combo box uses this query. What I want to do is
build a filter so that when I choose one item from the combo box to place in
a field of a table the next time I open the drop down list of the combo box,
the item used does not show. The only time the item ...

I have a table that has Sales People that we track performance on on a weekly
basis.  I'm trying to develope a query that will show the top 20 sales people
grouped by date.  So the result will have 20 people per day X 5 Days or a
total of 100 records.  This is the only query I ...

I want to be able to query active directory to populate one of the tables in
my access 2000 database. Is this something that can be done from within
access? Or, do I have to write an external program (eg. use .net
DirectoryServices classes) to do this? Can it be done in access ...

I have a table for truck sales in canada by make of truck (there is about 8
makes).  The records are for monthly sales.  I would like to make a table
that has date descending in the left most column (in order to show most
recent results first), and a sum of the top three makes ...

I thought I saw something on this recently, but I couldn't find the post and its responses.
I have a crosstab query where the columns are week-end dates, but in my data, there is 3 weeks missing.  So my results go from
3-31-2006 in one column to 4-28-2006 in the next column.
Can I ...

I have a query that pulls back all records that have a >0 value.  It works
fine.  The problem is that I have a few records that contain a 0 value that I
would like to include in my results.  These results include part number,
price and descritions fields.  Maybe I can use the ...

How can i remove records in a column that have less than 50 characters or so?

Do you know what expression I need to use in the criteria cell?

Hi. I am working on a query that is pulling from 2 tables. Its WHERE
Statement includes all items where cash in or cash out falls in the following
cases:
1. one large transaction for a single day that is between 3,000 and 9,999

I am trying to use the "Not operator" in a query criteria row to exclude
country fields that start with "S". For example, South Africa, South Korea,
Spain etc. So far my attempts have failed.
I tried: