I have a table that has about 35 columns in it. The columns are labelled
BM01, BM02, BM03, etc... Each column has either Yes, No, or is blank in each
row. I am hoping there is a way to create a query that will show me the
number of Yes's divided by the sum of Yes+No for each ...

hola, què es la odisea? ( hello , What is the "Odisea") Can you give me a
narrative secuence? (me pueden dar un resumen de ésta o una secuencia
narrativa?)

I created table whereby certain fields are concatenated.  Between the
concatenated fields, a hard carriage return was placed (e.g., vbCr).
When I place the results in a form, the carriage return is displayed as a
small square between the fields.  Is it possible for the form to ...

How does one completely reformat a hard drive under Win 2000?  Under Win 98,
you shut down, then chose Restart in DOS mode, then proceeded with Format C:.
I have tried inserting the Win 2K CD in the CD Rom drive and choosing to do
a new installation but this does not completely ...

I downloaded the "3 answer test" and can't figure out how to start the same
format on page 2

I have created a buytton to print a report based on user input.
I know how to create the button and macro to open the report
I have created a report based on a query that slects the records between the
dates the user inputed in the prompt.

I have some code that opens a couple of make-table querys, and then executes
some more code.  I would like to insert the line 'DoCmd.DeleteObject acTable,
"Table to Delete"' to delete those tables that are created, but it doesn't
work.  The tables don't delete.  I'm assuming it ...

I using access 2003. I am trying to compare data from two tables. Table A
and Table B. Table A has 12 digits in 1 column and table b has 10 digits in
1 column. I need to compare Table A data starting in position 2 and ending
in positon 11. I tried using instr function but it did ...

I have a form that travelers enter information for a trip.  I have two
command buttons one will direct them to the next form and the other one will
close the form.  Is there a way if they click close for without saving it
will clear the information they just typed in.  I only ...

We have migrated our SQL table from SQL 2000 to SQL 2005 and as a result had
to migrate our ADP files from Access 2003 to Access 2007.
In Access 2007 when we resize a column to show the data and then close the
table we are asked if we want to save the changes.  When we reply "Yes" ...

I have just become an Access database developer.  I create Access
applications using Access run-time.  I allow my clients to compact
their data file to maximize the performance of the applications.  One
of my clients is complaining that they have some data lost after

I want to open a form as modal. When I use this way, it suspend the calling
sub.
"docmd.openform formName,,,,,acDialog", Which is very good.
But when I want to open the form as class, The calling sub could be suspend.

I'd like a calendar button to appear on a form. When clicking the button, it
should show a small calendar to click a date and have the month/day/year
appear in the date field. How can I do that?
Many thanks in advance.

Does anyone know where I can find an IT Services Catalog Template?

The Access 2K text I'm reading says the following should work:
Form_MyFormName.PublicVar = "New Caption"
Forms!MyFormName.visible = True
The text says that even if MyFormName is not loaded, this syntax will load