Hi there...
I'm trying to figure some syntax out.  I want a SELECT query where one of
the fields that I have is character in the Access table, but I want to
convert it to numeric for the purposes of the query.

I have a table like this:
NAME    CODE    FREQUENCY
-------------------------
Bob    1    3

Is there any way where I can query Adobe Acrobat 6.x from ITK showing if the
object is Approved/Non-Approved and also take the Adobe Acrobat 6.x from
Results so that I will be able to "match" Adobe Acrobat 6.x from ITK and
Results and "merge" its Approved/Non-Approved status?

Hi, I am trying to create a parameter query.  I have a databse with names and
counties that the people live in.  I want a query that will allow you to
select one or more counties and display the names of the people who live in
the counties.  I was also wondering if a checkbox ...

I’m trying to use a VB variable in an SQL statement and having trouble with
the “ and ‘ and & characters enclosing variables Me!txtTestRprtID and
intStdId.
What do the different characters mean and how should they be used?

Using Access 2000.  I am trying to show all of my employee names in a query
(sql below) even if the count of their tblEmployeeAudits.EmpAuditID field is
0.  When I run my query, I only get employees who have numbers more than 0
in the EmpAuditId field.  I tried fooling around ...

Firstly, my apologies. I know this topic has been discussed a number of
times but I have viewed all the old posts and cannot work out how to
apply this to my database.
I have a table with about 15 yes/no fields. I need to know how to count

I would like to have a query check field 1 agents field 2 and if they do not
match show the record.

I have a table with multiple checkbox fields on it.  What I can do is
determine how many checkboxes in each field are True(Yes) and return that
value in a query.
What I need to do, is add the total True(Yes) checkboxes on the table.  When

I have 7 combo boxes each with the same choices of training routine. I want
to have a query that looks at each combo box and chooses the relevant workout
data from the relevant fields. The problem is if one of the criteria is null
it shows no data even though other criteria may ...

Hi There!  Any MVP's that would like to help out with this "iif" clause I'd
much appreciate it.  I have a bunch of fields within my table one of which
denotes the time.  I want to take a certain range of time and assign it to a
specific daypart such as EM, DA, EF, PR, LN, or ON.  ...

I'd like to count\sum a list of records seperately for different
individuals.  For example, I have a table that contains different statuses
for these individuals, such as Other, Vacation, Personal Holiday, Training
and Sick.  The problem is each status is listed under one (1) ...

I have the names of several tables in a table called "MyTables", eac
table name as its own record, together with a checkbox
I want to make a query that will return records ONLY from the table
where that table's record in MyTables is checked

I am trying to pull information from a SQL database to do some statistical
analysis.  The number I want to work with is in the databas as a varchar.  I
am trying to add an expression to my query that will give me the average of
the information in the field.  I am not sure how to ...

I have several check boxes in a form, when I run queries one check box
appears on the table while the others use 0 and -1.  How do I get them all to
display the checked and unchecked boxes?  Thanks.