I have a table which has twelve fields -- one for each month.  The field
names are the same with the exception of the last two characters:  SAL01,
SAL02, SAL03 ... SAL12.  I want to set up a parameter where the user enters
the month and the respective field is queried -- ...

Is there a way to sum a specific column in a query? What I have is a
query that pulls several line based on a id field. I want to total just
1 column in the query and have it report back as new column. Example
Id         Site        price        date

I'm not sure if what I want should be done in a query or a report...I have
two tables (one with names of who gave stock and one with the actual sales of
the stock).  It is a one to many relationship.  I want to generate a report
that will show the name of the giver and the total ...

How do I input this in the criteria of the query.  I'm trying to keep a
rolling record on a report to give me who has been assigned to the company in
the last 9 months, so whenever I open the report the data will always be
current.

how do I remove non-alphanumerical characters in a Access 2003 dataset?

I have a calculation that brings back a number which represents seconds. I
would like to convert that to hours / minutes / seconds, i.e. hh:nn:ss. If I
just apply the format it returns 00:00:00.
Any ideas?

Suppose that I want the number of male employees in each deptment
rather than all employees. Can I specify this querry on SQL? why or why
not?

I have a switch function that is not working properly.  There is no
syntax error, but it is not displaying any data.  The columns come out
empty.  I'm trying to change a field dynamically.  I have wrote a
function to return a value.  Based on the function value returns, I

I have an employee table that has  a relationship w/ a dependent table
and also a deptment table that has  a relationship with employee table.
How do I perform a query to pull at managers from Dept table who do not
have a dependent?

[enter start date] [enter end date]
how do you type that in the query design date field?

I have searched this site & Google groups for the solution to my problem &
have found info on the subject, but I have not been successful in
implementing in my query.  I am sure the solution is simple but I am a
novice.

I'm using a form as a menu.  There is a text box on the form that the user
enters a date into.  This date is used in multiple queries during the user's
session.  I'd also like to write the date entered to a table.  I have an
append query that runs as part of the session, but ...

I am trying to create a case sensitive query that identifies when users have
made typos when entering the word TO.  I read postings here and have gotten
the StrComp to get me most of the way I need to go.  My query is giving
correct 1 and 0 results depending on whether there is a ...

I would like to replace part of a field after a space.  For example:
Cindy Jones would be Cindy
Tom Price would be Tom
John Smith III would be John

I have a form that has multiple subforms.  One of these forms is used
to enter related codes of which there can be anywhere from 1 to three
entered per main record.
I have a query that I want to run that will identify all records that