I want to run a query that will change the format of a field, current as
general number, to currency.  This is going to be a daily thing so I want to
automate this rather than manuallly changing it each time.  I assume this
would be an update query.  Can someone tell me how to ...

I have an append query (source MS sql server database table) having 4 fiedls
Date
Branch
Product

I have a database which holds all our customers service data and am trying to
produce a form which allows an operator to select the [calibrationmonth] and
[engineer] via option groups (checkboxes), then on clicking a command button
will have all the records for that chosen month ...

I  would like to give users optional criteria search option and return multi
records.
I would like to know are there any optional parameter for a query or I have
run different query for different number of parameters or I need build Select

How can I create following function which collects the information from
sheets 2-4 to sheet1? After I have activated Sheets 2, 3 and 4, I will give
two parameters on Sheet1. Cell A3 is the header and cell E3 is the value
that I like to collect. After giving the 2 parameters, it ...

I wanted to know, is there a way to attach a query to a textbox, or,
similarly, remove the scrollbars from a combo/listbox?

Dear
I have  a table with two field, one field for emplyees name,
another field for date arrived from vaccation.(this field for date of
arrived from vaccation for each and every time)

Hello: I need to run a query able to find duplicated data within some field.
I tried filters but my DBase is too large and this task became time
consuming. How this expression looks like.
Thanks

I have a tbl in which I store manually input chgs for a particular supplier.  
This table is on the many side of a one-to-many relationship.  The table has
a PK of date of chg, who chgd it, what field was changed, and an autonumber
chg no.  This is because multiple chgs can be ...

I have a query that current pulls data on the expected due dates of
pregnant women. This query contains the first dr visit date and the
expected due date. My client now wants information on the delivery
information as well. Obviously this cannot be exactly matched as

Im using a Report in MS ACCESS 2003. Ive 2 tables. One named 'Candiate_Table'
and the other named 'Votes_Table'.
     'Candidate_Table' has the id of each candidates which are primary-keys.
'Vote_Table' contains votes obtained for all candidates.

MASTER Table:
ClaimsPrimaryKey
DETAIL Table:
AutoNumberPrimaryKey    Date    ClaimsPrimaryKey    ClaimsStatus

I have a query that picks up its filter from unbound fields on a search form.
can i set it up so that if the unbound field is blank the query will report
on all fields.
secenario is producing account reports filtered by account number, and i

This may be to complex for my skill level but i want to know if this is
possible.
We use an Infopath 2003 form here in the office that is connected to an
access 2003 db. One section of the form should be filled out and when the

I have  a Query set up this way Total:
[WebCharge]-[AuthNetCharge]-[TPmCharge]. This works great when I want to see
the the total for web Charges. But I have 3 ways in which products can be
purchased, which are: Web Charge, E Plans, and direct bill.