Sum(orders!amount*0.2)
what does the above do?

I have a table that has our asset inventory with tag_number as the primary
key.  We have some records of computers that have modems.  In the modem
field, we have the modems tag_number.  So, there are records of just the
modems, then there are also records of the computers with ...

Is there anyway to set up a Query so that if the field contains a specific
word it sends an e-mail to address in another field in the same record?  I
just want to send a standard message to all those who meet the Query.
If so, how can I do it?

need help - want to update a memo field in this way:
original table has text in memo field  - Notes 2004:   xxxxxx
secondary table made from this table has the text from the original table in
memo field and then new text has been added in memo field - Notes 2004:xxxxx

Hi gang,
I've got a little issue here that is proving to be quite frustrating..
hopefully someone could show me my error.
I have a query that is has the following fields

SELECT MonthName(Month(orders!date),1) AS [Month], Day([date]) AS
[Day], Count(orders.id) AS Countid, Sum(orders.amount) AS Sumamt
FROM orders
WHERE (((orders.paystatus)=1) AND ((orders.amount)>0))

In the process of migrating Access mdb fe/be to Access MDB fe / SQL (MSDE)
be. What is the best method for passing queries to the server?
Concatenate the SQL in VBA - if so, how do I pass to server (SQLExec?)?
Create/call stored procedure?

Hi everyone, hope you are well
I am trying to write a function that I can use in my query to alocate
timeslots. Basically, I have data for each 15 min period and I want to show
it as half hourly. So, 22/09/2005 08:00:00 and 22/09/2005 08:15:00 would be

Hiya,
I need to run quite a hefty piece of statistical analysis monthly using a
whole heap of data. Whilst I'm aware that Access may not be the best tool in
the world to use, it's all I have.

I am tryin to create a query that will search through multple tables to
locate production informtion.  Each Table has the same format and holds
producton information for each week.

In order to avoid double entry data, like
'Hällo' that should be concidered the same as 'Hallo' or 'Français' that is
the same as 'Francais', is possible to do a comparaison of the fields
contained on a table with a field typed by the user withouth taking in

that when called will generate a random number between 100,000 and 999,999
and place it in a table. code must check this existing random number table to
make sure there is no duplicate.
thanks, rob

I need to create a query that will give me averages on a list of numbers.
How can I calculate the averages, but ignore 0 or null values. Addtionally
if I am ignoreing the 0 value I don't want the record field to factored in
the average count.

I have a query which will sometimes return sales vales that are blank, so I
have used a NZ command to return a 0 instead of a blank result:
FD UNITS: NZ([FD UNIT],0)
My problem is that I cannot format this to make the field to no decimal

How can i query a table that will select only for those two tields are not
equal.
ex.
Table1