An event that calls a query is returning a run-time error and I can't seem to
figure out why...I am sure it is probably fairly simple, and would appreciate
some help from anyone out there:
Private Sub cmdOK_Click()

and select the critera from the choices in a field.  
I know creating a search Parameter [What Carrier?], but the problem is that
the person doing the query has to spell everything right and that is a
challenge. I rather have him just pick from the choices already in the field.

I'm not sure if this is the correct place to place my request for help, but
hopefully someone can help or steer me in the right direction.
I have the following crosstab query I am trying to create a chart for.  I've
tried in Excel, but can't get it to accept multiple x axis.

My mother-tongue is not english.So if there's something I cann't express
clear,pls be tolerant,thanks.
There are two tables,with the same field definations, but not all same
records.assuming table A is a snapshot of 2008-2-29,Table B is a snapshot of

How can I determine number of weeks between 2 date with decimal precision.
let say if the was a delta of 6 day between 2 date return 6/7 = 0.86
I tried the DateDiff("ww",.....) but it return whole number not decimal as I
require in this instance.

I want to get the <date> in the right order with using statement below:
"SELECT tDate FROM TempTB ORDER BY tDate;"
For example,
if  the list of records has

I have been given a database, which has been used to record incoming
calls, the user enters the time someone phones in, the department name
and person they were put through to.
They now want to be able to record the number of calls to departments

I asked this question before and didnt get reponse but I think I didnt ask it
properly nor provide the appropriate information. I am hoping to have
explained it better this time.
I have a query which selects the most recent record that works great (see

I wish to update the MedRecord in Table IntakeInfo with
thePatientMedicalRecord# from the Table PatientInfo. PatientID is the pk in
PatientInfo. There is a one-to-many between PatientInfo and IntakeInfo.
I used the query design. This is the SQL code that Access provided:

I'm not sure if this has been covered here.  I have a form that adds
individual purchases to a customer's account, updating a table that records
the item urchased, the price and the quantity.  I am trying to set up
invocies and payments.  I have a tranactions table which appends ...

is there a way to rewrite this code to make it short.  The query won't run
because it max the # of characters allowed.  sorry it's written in caps.
thanks in advance:
BASE ADMIN: IIf(CDPINC_ARIBD!IDACCTREV="5021-0PENSN-QTV" Or CDPINC_ARIBD!

I have the following expression in a query:
       Actual Month: Sum(IIf(Len([header]=3),[qty]))
basically I want a sum of quantity if the length of header = 3.
But when I try to run the query, i get :

I have a subform that creates an unbound text box based on user questions.  
It creates a document format  that I want it to query on using the "like"
expression in the criteria so the criteria reads:
Like ("[Forms]![FormName]![Text17]*").  

I'm having a complete brain fart and cant find it in help.  what is the
formula to return a value after a specific character.  the most common
example is when you have a last, first name in one field and want to split it
out.

Hi, I wonder if some one can help me.
The following code works:
Milestone:
IIf([dbo_Site_ProjectCard_Milestones]![TaskPercentageComplete]=100,"Completed",IIf(IsNull([Kdcr