Please help.
I am trying to create a form containing a Combo Box.  This combo box has a
list of Names.  When user try to click one name and click the OK buttion, it
should be able to generate the report.

Contact data from the web is downloaded into Outlook.  From Outlook, it is
imported into Access.  Some sites list a BusinessPhone2 field in addition to
the fax and phone number.  Quite often, this BusinessPhone2 is the contact's
fax number.  How do I transfer the contents of the ...

I have a crosstab query that work just great. All the data that I require
shows up. But I need to change the first day of the week in my [Date]. I have
tried:
Format$([Date],dddd,vbFriday)

Okay, I have two queries, one provides data based on original contract
budgets and values, the second provides adjusted contract values based on the
original budgets plus changes.  How can I combine the data from these so that
it will provide the original values if nothing has ...

I want to modify a Yes/No field to NULL, I tried the following:
ALTER TABLE table1 ALTER COLUMN [Resigned] [Logical] NULL
but I got syntax error.

I would like to use the query to perform the following:
If [fieldA] is null... then get the data from [fieldZ]
Any help would be greatly appreciated ... thanks!

I have a field called interest rate in table. Data in this table is in
percenatge I used following code ( which I got from  Allen Browene ansewer to
similar qquestion in another post) I is not working for me please tell me
what is wrong with following code.

Microsoft Access 97.  No experience in writing code, but program in queries
regularly.
Have query that includes two dates. Need to subtract date 1 from date 2 and
get response in  ##years ## months ## days.

I have following code to export from query to Excel and open Excel file
(Application.FollowHyperlink)
   DoCmd.SetWarnings False
   Dim stDocName As String

Can anyone figure out where the parenthesis and comma's might be wrong below?
Nights: IIf(DateDiff("d", IIf(CheckInDate < [Start Date],
[Start Date], IIf(Nz(CheckOutDate, Date()) > [End Date],
[End Date], Nz(CheckOutDate, Date()))) = 0, 1),

Hello,
iT'S THERE ANYTHING WRONG WITH THIS QUERY two queries, i am trying to get
one from the otherone. or it's there a best way to do this.
query one: name: qrAllItemsCountFX-Fa

How do I find records that are in one field/table but are missing in a
similar field/table? I am trying to determine which records are missing.
Thanks,
roihunter

Hi,I am a new user and have been using access 2003 for labout 6 months but I
am stumped on this problem, I have trucks  numbered 1-10 with a service
interval that varies with the service type such as a 60k pm is done every
60,000 miles and a 40K pm is done every 40,000 and 20k is ...

I am looking for a solution to my problem in access in regards to a
calculation that shows the days from the beggining of a project to a specific
date. For example: a project could have a start date of 01/01/2001, I want to
figure out how many days has this project been worked on ...

I need help with a query.  In a table each id can have more than one
output_device, but must have at least an entry for 'RECS'. How can I identify
id's that don't have an entry where output_device = 'RECS'?  Example, id of
567 is ok, but I want to get id 459 because it doesn't ...