designing query for "off calendar"; have due date expressions working
correctly - time frame is within one month, so need to add to expression that
due dates cannot be Sat or Sun ( have tried inserting (iif("d"=Sat, +2)) and
get same due date which actually is the Sat 1/28) and ...

Hi, Can you direct me to help to block junkmail coming into my entourage
email site? Thanks,Sara

Here's the problem.  I have 2 tables.
Table A
Account Number    Desc     Name
Table B

I have a series of queries which look similar to:
SELECT tblCandidates.Booked, Count(tblCandidates.Booked) AS NumberBooked,
Weekday([Booked]) AS WedOnly
FROM tblCandidates

Is it possible to select all columns from a table except one, without
specifically naming all the desired columns?
Thanks.

Didn't know how to describe this in the subject, but I need a query that
counts the number of items in certain categories, but if that category is
blank, I want it to return a zero.  I need it for a report.
All I seem to be able to get is the count of records that are greater than ...

I am using Access 2002 and created an unbound form with a couple fields to be
used for search criteria to be selected on the fly to drive a query.  I have
a field called Region and one called Status.  I entered the form fields in
the query criteria but can only get the results to ...

I have a form with 4 combo boxes set up and a run report button.  I
would like to pass the selection from the combo boxes to the report
select statement.  Below is my code from the "run report" button.  I am
currently getting a type mismatch error.  Any help would be great.  I

i am trying to set a certain field to a blank vaule if another field is >than
30,000 or >-30,000.  i have set it up and it is working fine with changing
the value to a blank if it is 0ver 30,000, but i am not sure how to work in
the -30,000.  this is what i have:

I want to use a query to select data based on a comparison between two
fields.  For example:   Field one is a phone number, field two is a phone
number.
I want to query to compare field wanted field to infield one equals field to

Hi guys, I am trying to create a query collecting data from 4 tables as well
as calculating totals delivered but it's hurting my head trying to work out
all the joins can anyone help please?
The 4 tables are as follows:

I have the following table in my database:-
ID|Age|Gender|Ethnicity
1   12    Male         W1  
2   13    Female     B1

I am trying to create a Memo field for an Address block based upon four
address lines (text fields) and want to seperate each with linefeed/Carriage
return.
How do I embed the line feeds in the update query

I have two tables InputData and CommonData each with three fields F1
(Long integer), F2 (Date/Time), F3 (Text) i.e. the tables have
identical design.  I am trying to delete all rows from InputData which
have their F1 value in CommonData as well.  This means I wish to leave

Compared to SQL2000, Access has its own, original way to build the table
relationships in an SQL Statement.
I'm trying to build an application with Visual Basic 6 that shows some data
using DAO 3.6.