I have a contacts table that has some blank fields, except contactID.  Some
records entered only have an email address or a phone number.  If I include
phone number in teh Query form, only the minimum number of records show up,
since not all records have the same info.   I ...

Can you create a querry to query multiple fields in different tables.
Eg: Say I have two tables one with ID, name, town, zip and another with ID,
Hobby, Gender, height.
I want to create a querry to find all male in zip starting with 03...,

I have checked my system with every virus program I have NAV McAfee both up
to date subscriptions. My screen seeting will not change when I click the
advanced tab and set it to not reboot or to reboot when I reboot the screen
resolution is the always the same. When I start my PC ...

I have posed this question in another thread, but I want to explain further.
For the sake of managability, I have split a file with a large number of
fields into two. One contains basic information regarding an entity, the
other contains specific information, in this case the ...

I'm having trouble with Rounding in Access 2002...
Here's my formula:
Extended Cost:([Mileage]*0.345)+[Cost]
When I run that formula through my query, with Cost = $25 and Mileage = 25,

i have table a and table b.  in these 2 tables, i have a field n.  field n is

I can't get my newly installed Word 2003 to print odd (or even) pages only,
or any combination of pages, e.g., 1-5, 7,8, etc. It will print a document,
however. Can someone help? Thanks.

I need to select 200 random customers from my table, how can I do that?
Table: tblCustomers
PK: CustI
--

My query field is term_month:month(class_date) and the criteria I've set up
is IIf([forms]![frmSelectTutorRosterReport]![Term]="fall", Between 8 and 12,
<8) .  It returns no records, but if I use 11 in place of the "Between 8 and
12" it works.  What am I missing?  Thanks!

I have built a very feature-rich manufacturing system in Access. The business
rules are complex and so the queries are too. As I extend this application,
the "Query too Complex "error is coming up more frequently.  I understand
this is due to the limits of memory handles. I had ...

I have a table with a date field in ddmmyy.  I need to extract a couont of
the number of records for each month and year - eg May 2005, June 2005 etc.
Is this possible please
Thanks

I have a very small Access file that computes totals for money owed.
It contains one table that has information that is input by hand.
It also contains one query that pulls some of the information from that table,
including costmo1 and costmo2, and two formulas (see below).

Is it possible to be able to run a delete query from a button on a form? When
I try to do this using a wizard, it does not list the delete query in the
query list?
TIA

I created a database with 15 checkboxes for users to answer "yes" they have
completed something or "no" it is not yet done.  I grouped this by my
company's affiliates.  I need to run a query, sorting by affiliate, that
counts the number of "yes"es for each question.  Then I need ...

I use like "*"&[whatever is here is the prompt]&"*"
as criteria in queries all the time. But is it possible and how would I
allow multiple words.
ie. what I have like a google exact phrase search.