Does anyone know the best way to calculate the rate of return for a stock in
Access using a query?
Essentially, I have a table with the closing price of a stock. I want to be
able to determine:

doing a greyhound race database and having trouble with say todays distance
in my crosstable i would like to extract all runs the dog has had within a
10% range of todays distance. eg. if todays race is 500m i want to extract
all runs in my select query that are within 450m and ...

in my application,i use sql to communicate with access database,i don't know
how to set default value in create table syntax.who can help me? thanks a
lot.

Need a report to be in below format, 2-3 tables all linked...
S.No   Name   Address    date   amount
       shopname
       sub total                            xxxx    

I have a query in my greyhound racing database where i have a table that
lists say 10 runners for todays race and i extract each previous field(run)
the dog has had from another table where the date of that run was before
todays date using criteria in the select query.Problem is ...

Does anyone have any ideas regarding the above.
I have 2 fields in my table that I need to run a query against.  
The first is a Date field and the second is a Processed field.
The Processed field is a Yes/No field which will contain Y or N.

I want to make a querry to select records filtered on my continuous form. By
using the below code I get only first one of them (or the one the cursor is
on at a time).
How can I get all records which I view on my form?

I am having a problem with a project I am working on. I need to update a
table with the results of a query, but I am unsuccessful when I try to do
this. Below is some suggesstions from a prior post that I made. Can anyone
help me out with this?

Two tables -- Transaction table with Trxn_Date for each record, and Price
History that lists effective date and current price.  I need to match the
most current price in Price History table to the Trxn_Date.  
Trxn_Date

I have two text fields on a form which give me a total and it works well But
when i run a query the total field does not show the value it calculates on
the form. It shows 0 or nothing

Ok, I know how to e.mail to one recipent, but how do I set several e-mail
addresses:
Private Sub Command45_Click()
   DoCmd.SendObject acSendNoObject, , , [EmailAddressFieldName]

I've got two sets of data, financial information imported into access from
two different sources. I basically want to check one version against the
other. Problem is, there is no real way to uniquely identify them (that I
know of). Table 1 has tons more information than table 2 ...

I have a date deposit and date received field.  To calculate the number of
days it takes to deposit, I merely calculate Days: [dt deposit]-[dt
received].  However, I need to exclude Sat and Sun from being counted.  I can
only count business days.  I've tried Iff statements, but ...

I have a table of starttime and endtime (with calculated daily total) and I
would like to count how many people were at work before 8:30 am, how many
8:30 - 1:30, and finally how many from 1:30 on.  Can you suggest how I can do
that?

I am querying 3 tables in a union query, tblInvoices, tblDebtors and
tblContracts. I have another table called suppliers, with 2 fields, ID &
Name. The bound column in the 3 main tables is to the supplier ID, but I have
adjusted the column widths to 0,10 so the supplier name is ...