I would like to ask how to tell in making a query to check if the date
selected is valid or not:
if isdate(dateBought)=true  then 1 else 2
thank you

I have this Table :
ID      Course  Det1    Det2    Det3
St_1    Curse1  1       2       3
St_1    Curse2  1       2       3

I have set up a mailing list data base in access.  I am a novice.  I don't
want to enter duplicate information in my mailing list, so I set up a Find
Duplicates Query using the wizard.  Now I don't know how to use it nad I
don't have time to sit through a tutorial.  Can anyone ...

is it possible to use a table saved in an access file as a filter for a
passthrough query that retrieves data from a server?  
e.g.  
select odbc.col from odbc.tbl

I have a query I wrote that runs fine.
I can run it, select all & copy everything to Excel (manually) and that
works fine.
but if I try to export the query to Excel - I get this error:

I am a new user in Access 2007 and would like to know if it is possible to
query two different databases? If this is possible, can you provide a sample
of the query?
Thanks in advance.

Is is possible to query a crosstab query?

I have a field in one table called "insurance company". I have used this
field for years. Now we want to display a three letter code for the insurance
company based on a new table that contains the insurance company name in one
field and the three letter code in a seperate field.

I have an address field that conatins street intersections like: Main St &
Dean St
Each record has an "&" between the two streets.  I would like to alphabetize
these street intersections so in this example Dean St. would always come

First, I'm not a VBA programmer.  I have basically created a program with
macros, forms, queries, reports, etc.  I've searched all over this site for
an answer specific to my problem and even for areas where non-programmers can
ask their silly little questions.  Please forgive me ...

I have an access query, which runs from 4 tables linked with SQL server
2005.  Firstly, it takes couple of hours to link these 4 tables.  and then it
returns wrong results, when compared to same query results on SQL.  
I believe, there is a problem with linking table.  The repeat ...

have this crosstab query in Access 2003
TRANSFORM Count(TblMo1A.NewIncidentID) AS CountOfNewIncidentID
SELECT TblMo1A.TypeDescription
FROM TblMo1A

I have a text string in a column called SVCDate that represents 2 dates that
looks like like this
"20080101 - 20080102"
I'm trying to create 2 columns that separates the two dates and then formats

I'm working for a small charity and have a database using check box for
yes/no to monitor the work we do for the funders many years ago I had an
expression think it was on office 79 to chage the value of yes to a posotive
number which enabled me to create reports from the ...

I have imported 2 SQL tables into Access.  One has a product code and the
start time of each code.  The other has information about that product
collected every 5 seconds.  What I need to do is calculate the time
difference between the product codes and then use it to query the ...