Hello, I 'd like to display the results of a query's output as a percentage
rather than a list of all rows that contain data from the table. Should I do
this as a form or report. I'd like to have multiple queries being outputted
as either a percentage or running totals rather ...

I am currently running the following syntax:
PAGE: Mid([RDCIS]![DCI_NAME],7,9) & IIf([RDCIS]![DCI_NAME]="Page_03a",".0" &
[RDCIS]![SUBEVENT],IIf([RDCIS]![DCI_NAME]="Page_04",".0" &
[RDCIS]![SUBEVENT],IIf([RDCIS]![DCI_NAME]="Page_07",".0" &

Dear Access Community,
I have a database in which all entries are done on a day-to-day basis. A
summary report must be done that shows monthly figures as well as a one year
rolling sum. I have almost gotten everything figured out (thanks to all of

How do you delete the last 2 digits from numbers?  Some of the phone numbers
in my contact list happen to contain 2 extra digits at the end that I would
like to delete.  How would I do this without affecting the correct numbers?

Can someone help me figure out what is wrong with this ?
PAGE1: Mid([RDCIS]![DCI_NAME],7,9) &
IIf([RDCIS]![DCI_NAME]="Page_03a",".0" & [RDCIS]![SUBEVENT],
IIf([RDCIS]![DCI_NAME]="Page_04" And ([RDCIS]![SUBEVENT]<10),".0" &

I have a database for subscriptions to a web site which has the date
on which each application to join was made etc etc.
Can I easily create a chart of the number of people subscribing each
month for the lasr 4 years?

Thanks for taking the time to read my question.
I want to filter this query by the values in my single column list box.  I
made this function to create the string, but the query doesn't like it.  If I
paste the string that the function returns into the criteria line the query

i am using access 2003 with frontpage 2003, and i have set up the
following query
SELECT [movies data].actor1
FROM [movies data]

I'm trying to use the ORDER BY option in both my Table design and in a
separate SQL query, and I'm getting the same puzzling result either
way. The two fields in the query below are text fields, nothing
special (Unicode compression is set to "Yes", but I don't see how that

how do i run a query to select one item with many categories?
ie,
name       |    cat1   |   cat2   |   cat3   |   cat4  |
tom         |    hat     |  gloves  |  tie      |  watch |

I have a query (see SQL below) that connects 2 tables: Contacts and Orgs.
Each table has the field Organization in it. That field is the linking field
between the two, and it is the primary key of the Orgs table.
It is set up so that if the organization is not available in

Access 2003  XP SP2
I am having a problem with an update query.
Table is in a one-to-one relationship,  referentail integrity and
cascading data are checked.

I've had this lingering question for a while and am now finally trying
to address it.  We know switch statements' sizes are limited.  I have
this switch statement below, and I need to add more but am bumping up
against the size limitation:

Okay, I'm used to using queries embedded in other queries, and when you go to
edit them you have to change the []. AS to () AS.  It's flaky, but I can
accept that.  But this is a new one.  Does anyone have any idea why when I
save the following query in Access 2003 it saves funny ...

...if so, how?