This Frame has 4 radio buttons. When the user clicks the first button
(option value=0) I want to display all records in the file. This works for
the other cases but not for Case 0. What's my problem?
   Select Case Frame31.Value

I am wanting to run a report for all 24 branches based off one report. The
reason I need this one report is because all the data reporting will be the
generally the same, just different branch info, team info, and detail. I want
the user to be able to select the date range, a ...

Jut wonder why I can only see TABLES when I try to connect from MS-Word
to my MS-Access database?? All tables show up nicely, but not one single
QUERY.
I'm using Office XP (Access 2002 and Word 2002)

What I'm looking for is an average (Monthly) for payment methods. For
example what percentage of payments for this month are in Cash, Check,
Credit Card, Money Order etc.
The Tables this is on are:

I have a make table query which creates 3 records based on expenditure. All
individual records are allocated to 1 of 2 separate locations or identified
as a shared cost.
So I end up with SAY

I originally posted this as "Help with the WHERE clause", were I was using
two different tables. I really can pull the info needed  on our current
customer base with just the one.
I am going to try and explain this as best possible. My database is for

I'm using Access 2003. How do I unlock a table ?
I have in VBA the follwing code :
Sub MySub_Click()
db.Tabledefs.Delete ("mytable")

I am trying to delete records from a form upon closing of the form if
the record has been updated using a toggle button.  Would it be easier
just to run a delete query for this?  Is it possible to delete upon
close?

The data on a table field I need to post on a different table when fields
from both tables match

I have a report (RPT_ADMISSIONS) that has a recordsource of QRY_ADMISSIONS.
The Qry_Admissions contains several demographic data such as Black, White,
Male, Female, etc...this data is imported from an older system we use at
work.  I need to make a report that will group and count ...

Hi experts,
I have to design a select query with 240 fields in Access 2000. I don't
have other options in this case.
I always got "Too many fields" error. I re-created the whole queries

I have created a form with a text box (txtInput).  My hope is to be
able to enter a string to be used as criteria in a query.  For example,
I want to be able to enter *elect* into the text box and have the query
result in anything that has "electrical" or "electric" in it.  The way

I have the following code to retrieve records from an access table in another
database. If I run a query using a linked table it returns all records as
expected. How ever with the sql I have below I recieve the error message 'No
Current Record' when .MoveFirst is executed, i.e. ...

TIA,
I have a report based on a query, it works very well, but everytime the user
wants the report they have to type in the date in a specific format. I
thought it would be easy, but I'm having a dumb day, can't think around this

I have a table called tblItems with a "itemDesc" text field.  I aso have a
table called tblExcludeTheseWords.   This table contains a list of words that
I would like to compare against the itemDesc field in tblItems and exclude
these records if a match is found in ANY part of ...