I have a single table database (access 2003) with client survey info. Many of
the questions are simple yes/no answers. I used the lookup wizard to create
yes/no combo boxes for these questions. When i try to run a query to count
the yes' or the no's i either get a datatype ...

I set my field caption in a query in Access 2003 like this:
2006/07:July 2006 Data
(I want to change the field name from another table to be 2006/07)
,but it change the caption to be 2006/7   !!!!

I have two customer lists. One attending our conference and our master
customer list..  I am trying to find those who attended the conference, but
are not on our customer list.  I have tried unmatched query, I can only get
it to display records from the master list that doesn't ...

I would like to know how to create a form where I can enter a number
and then that bring all the relevant information associated with that
number no edit just search and display
to give some information . I have an asset table where everything has

I have a query based off of many other queries and it contains a ton of outer
joins. What i want the query to do is spit out one record at the end...and it
works in that regard. My problem comes when I try using the serverfilter
property in my Data Access Page that is based off ...

i created a search query so that i could repeatedly look up different
variables.  Each time i run the query and find what I'm looking for, the new
table with the information I was seeking pops up.  Is there a way that I can
continue searching for my next variable without ...

I'm trying to build a report with pictures. I found the below code online.
It 'kinda' works. One of the quirks is that if I hold my mouse over the
reports name in the DB manager, the screen starts flickering like it's
pre-loading pictures before I double-click it. Next quirk is ...

I want to be able to add the monthly range in Field3(Start) and Field4(End)
using the actual start and end date Ex: Field1 1/7/05 and Field2 3/26/06.  
Each row the actual start and end date will repeat in Field1 and Field2.
Field1    Field2    Field3    Field4

TRANSFORM Sum(MonitorDownTime.[Down Time (mm)]) AS [SumOfDown Time
(mm)]
SELECT MonitorDownTime.[Assigned Monitor], Sum(MonitorDownTime.[Down
Time (mm)]) AS [Total Of Down Time (mm)]

If i have a query called SunQuery, how can I run it in an if statement, for
example.
if T.Min>T.Inventory then run query.
Thanks.

Is there a way to protect a query with a password, without protecting the
entire database? I have specific queries that my manager should be the only
one able to access, however, the database is used by all employees. Please
advise. Thanks.

I have A deposition and or valuable testimony relevant to the case involving
Robert Joseph James who was arrested on 8/ 16 / 06 on warrents relating to a
Felony Violation of a Court order No contact order with Terry A. Wendt
----------------

    hey i have a quick question on a query which isnt working at the moment.
My query looks at 2 tables named: 'receipt main' and 'receipt details'
Below is a list of fields in each table:
RECEIPT MAIN: PK receiptNo, ReceiptDate, Salesperson

I am trying to segment a table by the ID.  In the criteria row, I put

entries of the entire table, over 4000.  
What I am trying to do is segment this table into 4 tables of 1000 entries

Hello All,
My problem is that i have created a query which asks the user for a company
name so it can search records to display other information on the company
name they have entered. My problem is that even if the user enters just part