I have 23 employess all with varied skills. What I want to do is have a list
of their capabilities, 8 categories to be precise and a list of their days
off everyone works on a rotating schedule, and use a query to assign them to
different positions base on those two factors, ...

Am new'ish to access and wondered if it was easily possible to distribute the
A-Z & Z-A sort buttons into the run time version of access? i.e. at the .mde
front end. Is an option anywhere when it gets published? I can see lots of
ways to do it via forms (i.e. as a button etc). ...

We're experiencing very strange behavior with an Access 2000 report. We use
a query as the recordsource for the report. The query is based on several
underlying queries and has numerous fields which are dollar amounts. When
the query is run by itself all the values look fine and ...

I'm somewhat new to Access. Thanks for the assist in advance.
I have a database where I would like to graph the results of a query in
EXCEL. The Graph does not appear well within the Chart function of a report.
At present I run the query and copy and past into EXCEL and then ...

I am using Access 2000
I have an lump sum which I have to charge out each month. In individual
records this amount can change during the year which means the amount
recharged can change for the rest of the year. For estimating purposes I also

How do I add columns in a query?
I need to add four columns, only when all the four columns contain numbers i
get the output else it is blank. Since all the columns are derived from
different queries i am not able to give a default value as zero. Kindly help

I have this code which displays in a value list, which user ID is logged into
my database.  But I want to show the persons actual name (i.e. John Doe,
instead of BLD2174)  I created a table with UserName and UserID as the fields.
UserID has the PC name.  I want UserName to show.  ...

I had two questions regarding a couple of queries I am trying to create.
1)  I have a field call TBR which is a yes/no.  What I am trying to have it
is, if another field in the same table has a certain phrase within the field
(can be at the beginning, middle, end & have other ...

Using Access 2003 and I use the query grid but post the sql so it helps you
guys.  I have an audits database that we use to keep track of how correctly
our paper work is being filled out.  I have many Audit Types and in each
Audit type there are Audit Items.   For each audit item we ...

I have a table with each record having 2 rows - 1st is original data, 2nd
row is changed data. I am trying to write a query where I can display the 2
rows as 1 and have the changed data side by side - like below
productid productname   price

Using the OutputTo action in a Macro, I want it to prompt me for the
Output File name but already have the location preselected.
For example, I always want the file saved in c:\documents\kris\
If I put that in the Output File name, it errs on me.  It would be

I have a query that I am trying to prompt the user to key the date range and
the individuals user ID on.  The prompting works great and if the user is
just inquiring about one day, everything adds up fine.  However, when a date
range is selected, the response is not the desired.  ...

I'm not sure if I'm even going down the right path, I've gotten some help on
null columns but it was much too advanced for me to implement out so I'm
taking a different path.  I have a query
Country                 APAC             EMEA             Co-op              

Is there a way to join an Access table to a SQL table that has "Float" as a
datatype?
I am trying to join an Access table to a SQL table - but when I run the
query I get an error "Type mismatch in expression"

Here is my SQL
SELECT qryArvestDeposits.SumOfAmount4, qryArvestCreditPayments.SumOfAmount3,
qryArvestChecks.SumOfAmount2, qryArvestDebits.SumOfAmount1,
[SumOfAmount4]-[SumOfAmount3]-[SumOfAmount2]-[SumOfAmount1] AS Balance FROM