I have a combo box on a form that contains the months in text format. They
appear in month order on the form but when I query, they are in alphabetical.
How can I get this to be in month order on the query and also look like
months in my cbo and not dates?

I have a query that calculates the balnce from payments made.This works fine
and displays the correct figures.My problem is I that I need to display
onlythe records that have paid and the balance is zero
My balance query is

hello ppl
i was wondering if the LIKE can be used  combined with a parameter, so the
query remains the same but only change the text im looking for into a memo
data field.

Is there a way or what is the expression used if I want to do a runnin
total in a query under a field called "Amount Donated".  In addition,
would like to filter by selection using the DonorID as the primary ke
to show the total.

Thanks to Allen Browne for his help.
I need help again.
I used DLookup function, as said Allen Browne, and it was very useful
The point now is as follow.

I have a table I am trying to query I want to return all rows with H* and
convert them to other text in my column, here is the query, can't figure out
what I am doing wrong.  
iif([field]="h*","handy",iif([field]="t*","tell",null))  I have tried it with

1.Can you do a parameter query on a Memo field?
2. Can I set up a query to find all records that do not have a date in
the field.
As you can probably tell, I have tried but have not been successfull

I'm trying to write an expression that will convert a number into
year/month/day format based on 365 day year, and 30 day months. For example
366 should read:
"1 year, 0 months, 1 day". I've been told I have to hard-code this. How do I

How can I query the current record only and have it sent via e-mail with the
click of a command button?

This is really strange, In a simple select query based on a single table,
after highlighting a row and then copying (Ctrl + C or by the edit menu)
Access will crash, then do a compact & repair. It's Acc2002, I am the
designer and it doesn't happen to me, however it happens to my ...

Thanks for taking the time to read my question.
I have a field in a query that I want to apply an iif statement to in the
criteria.  If cboX = "Blank" then "*" else cboX
CODE

I want to say thanks to Allen Browne for his help...
The problem now is as follow....
I have one Form (Invoice) with one subform (Invoice's Details), when
select one client in the cbo of the form, the subform's cbo shows onl

I want to take two records with the same key fields but missing data and
merge them together to make one complete record. For example, record A has
name but address and  phone number are blank while record B has address and
phone number but name is blank.  I want to take the ...

How can I insert into a table value witch is
for example 12,3 while it takes it as 2 different values in a sql string (I
don't wont the value to converted to string but keep is as double)
Thank in advace

i have many yes/no and true/false data field in a query.
how i can use the parameter for that kind off fields?