Unwanted info in query

[Rhianne]

I have a Personnel database that I have created queries from, so as to show
relevant information for certain data I need to collect and show. However
there seems to be a problem, for example I would like to base a query on
staff type (we have paid, volunteer and placement), I need to be able to show
only paid, only volunteer etc. However even if I only select Volunteer for
the tables I want included in my query - it shows all the names.

What am I doing wrong!?

 

[John Spencer]

Please copy and post the SQL of your query.

(Possibly unneeded instructions follow)
Open the query
Select View:Sql from the Menu
Select all the text
Copy it
Paste it into the message

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

 

[Rhianne]

SELECT Employees.[First Name], Employees.[Last Name], Employees.Volunteer
FROM Employees;

Does it make a difference that the selection of staff type is a check box?
In table view it is demonstrated by a -1, this isn't a problem just want to
be able to get rid of unwanted names!

Thanks for speedy response!

 

[Mika Oukka]

In the design view in the column Volunteer there is the Criteria row.

Type: -1

and run the query.

Mika Oukka

SELECT Employees.[First Name], Employees.[Last Name], Employees.Volunteer
FROM Employees;

Does it make a difference that the selection of staff type is a check box?
In table view it is demonstrated by a -1, this isn't a problem just want
to
be able to get rid of unwanted names!

Thanks for speedy response!

Please copy and post the SQL of your query.

(Possibly unneeded instructions follow)
Open the query
Select View:Sql from the Menu
Select all the text
Copy it
Paste it into the message

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

 

[John Spencer]

It sounds as if you have three fields to show Staff type - Paid, Volunteer,
Placement? Is that true?

To show just the records where Volunteer is checked you would need a query
like:
SELECT Employees.[First Name], Employees.[Last Name], Employees.Volunteer
FROM Employees
WHERE Volunteer = True

In Design view
Field: Volunteer
Criteria: True

Your table design would be better if you had one field for staff type and
stored a value of Volunteer, Paid, or Placement in that field. A big
advantage to this would be if another type of staff was added (Part time,
Full Time) then all you would need to do would be to enter that into staff
type. With what I suspect is the current design, you would need to redesign
your tables, forms, queries, and reports to handle the addition of a new
staff type.
--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

SELECT Employees.[First Name], Employees.[Last Name], Employees.Volunteer
FROM Employees;

Does it make a difference that the selection of staff type is a check box?
In table view it is demonstrated by a -1, this isn't a problem just want
to
be able to get rid of unwanted names!

Thanks for speedy response!

Please copy and post the SQL of your query.

(Possibly unneeded instructions follow)
Open the query
Select View:Sql from the Menu
Select all the text
Copy it
Paste it into the message

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

 

[Rhianne]

I have just tried that and a window pos up saying - Data type mismatch in
criteria expression.

Any other suggestions?? Please??

In the design view in the column Volunteer there is the Criteria row.

Type: -1

and run the query.

Mika Oukka

SELECT Employees.[First Name], Employees.[Last Name], Employees.Volunteer
FROM Employees;

Does it make a difference that the selection of staff type is a check box?
In table view it is demonstrated by a -1, this isn't a problem just want
to
be able to get rid of unwanted names!

Thanks for speedy response!

Please copy and post the SQL of your query.

(Possibly unneeded instructions follow)
Open the query
Select View:Sql from the Menu
Select all the text
Copy it
Paste it into the message

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

I have a Personnel database that I have created queries from, so as to
show
relevant information for certain data I need to collect and show.
However
there seems to be a problem, for example I would like to base a query
on
staff type (we have paid, volunteer and placement), I need to be able
to
show
only paid, only volunteer etc. However even if I only select Volunteer
for
the tables I want included in my query - it shows all the names.

What am I doing wrong!?

 

[Rhianne]

I have typed in true and now all my information has disappeared from the
query. What else should i be doing - I don't really want to have to change
the design of the database.

It sounds as if you have three fields to show Staff type - Paid, Volunteer,
Placement? Is that true?

To show just the records where Volunteer is checked you would need a query
like:
SELECT Employees.[First Name], Employees.[Last Name], Employees.Volunteer
FROM Employees
WHERE Volunteer = True

In Design view
Field: Volunteer
Criteria: True

Your table design would be better if you had one field for staff type and
stored a value of Volunteer, Paid, or Placement in that field. A big
advantage to this would be if another type of staff was added (Part time,
Full Time) then all you would need to do would be to enter that into staff
type. With what I suspect is the current design, you would need to redesign
your tables, forms, queries, and reports to handle the addition of a new
staff type.
--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

SELECT Employees.[First Name], Employees.[Last Name], Employees.Volunteer
FROM Employees;

Does it make a difference that the selection of staff type is a check box?
In table view it is demonstrated by a -1, this isn't a problem just want
to
be able to get rid of unwanted names!

Thanks for speedy response!

Please copy and post the SQL of your query.

(Possibly unneeded instructions follow)
Open the query
Select View:Sql from the Menu
Select all the text
Copy it
Paste it into the message

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

I have a Personnel database that I have created queries from, so as to
show
relevant information for certain data I need to collect and show.
However
there seems to be a problem, for example I would like to base a query
on
staff type (we have paid, volunteer and placement), I need to be able
to
show
only paid, only volunteer etc. However even if I only select Volunteer
for
the tables I want included in my query - it shows all the names.

What am I doing wrong!?

 

[Mika Oukka]

It would be better normally use Yes/No field for boolean type, but DO NOT go
and change it now, because you might lose you data in the field. Check what
kind of values you have in the actual table and try to use the same value as
a criteria.

Mika Oukka

I have just tried that and a window pos up saying - Data type mismatch in
criteria expression.

Any other suggestions?? Please??

In the design view in the column Volunteer there is the Criteria row.

Type: -1

and run the query.

Mika Oukka

SELECT Employees.[First Name], Employees.[Last Name],
Employees.Volunteer
FROM Employees;

Does it make a difference that the selection of staff type is a check
box?
In table view it is demonstrated by a -1, this isn't a problem just
want
to
be able to get rid of unwanted names!

Thanks for speedy response!

:

Please copy and post the SQL of your query.

(Possibly unneeded instructions follow)
Open the query
Select View:Sql from the Menu
Select all the text
Copy it
Paste it into the message

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

I have a Personnel database that I have created queries from, so as
to
show
relevant information for certain data I need to collect and show.
However
there seems to be a problem, for example I would like to base a
query
on
staff type (we have paid, volunteer and placement), I need to be
able
to
show
only paid, only volunteer etc. However even if I only select
Volunteer
for
the tables I want included in my query - it shows all the names.

What am I doing wrong!?

 

[John Spencer]

Open your Employees table in design view
What type of field is Volunteer? Is it a number field, a yes/no field, or a
text field?

If it is a Yes/No field then the answer I gave you previously should apply.
As a test change TRUE to FALSE and see if you get all the records back.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

I have typed in true and now all my information has disappeared from the
query. What else should i be doing - I don't really want to have to change
the design of the database.

It sounds as if you have three fields to show Staff type - Paid,
Volunteer,
Placement? Is that true?

To show just the records where Volunteer is checked you would need a
query
like:
SELECT Employees.[First Name], Employees.[Last Name], Employees.Volunteer
FROM Employees
WHERE Volunteer = True

In Design view
Field: Volunteer
Criteria: True

Your table design would be better if you had one field for staff type and
stored a value of Volunteer, Paid, or Placement in that field. A big
advantage to this would be if another type of staff was added (Part time,
Full Time) then all you would need to do would be to enter that into
staff
type. With what I suspect is the current design, you would need to
redesign
your tables, forms, queries, and reports to handle the addition of a new
staff type.
--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

SELECT Employees.[First Name], Employees.[Last Name],
Employees.Volunteer
FROM Employees;

Does it make a difference that the selection of staff type is a check
box?
In table view it is demonstrated by a -1, this isn't a problem just
want
to
be able to get rid of unwanted names!

Thanks for speedy response!

:

Please copy and post the SQL of your query.

(Possibly unneeded instructions follow)
Open the query
Select View:Sql from the Menu
Select all the text
Copy it
Paste it into the message

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

I have a Personnel database that I have created queries from, so as
to
show
relevant information for certain data I need to collect and show.
However
there seems to be a problem, for example I would like to base a
query
on
staff type (we have paid, volunteer and placement), I need to be
able
to
show
only paid, only volunteer etc. However even if I only select
Volunteer
for
the tables I want included in my query - it shows all the names.

What am I doing wrong!?

 

[Rhianne]

That isn't working either. In my database's form view, the selection for
staff type is check boxes.

I really really don't want to have to change the design of my database again.

What else can I do?

Open your Employees table in design view
What type of field is Volunteer? Is it a number field, a yes/no field, or a
text field?

If it is a Yes/No field then the answer I gave you previously should apply.
As a test change TRUE to FALSE and see if you get all the records back.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

I have typed in true and now all my information has disappeared from the
query. What else should i be doing - I don't really want to have to change
the design of the database.

It sounds as if you have three fields to show Staff type - Paid,
Volunteer,
Placement? Is that true?

To show just the records where Volunteer is checked you would need a
query
like:
SELECT Employees.[First Name], Employees.[Last Name], Employees.Volunteer
FROM Employees
WHERE Volunteer = True

In Design view
Field: Volunteer
Criteria: True

Your table design would be better if you had one field for staff type and
stored a value of Volunteer, Paid, or Placement in that field. A big
advantage to this would be if another type of staff was added (Part time,
Full Time) then all you would need to do would be to enter that into
staff
type. With what I suspect is the current design, you would need to
redesign
your tables, forms, queries, and reports to handle the addition of a new
staff type.
--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

SELECT Employees.[First Name], Employees.[Last Name],
Employees.Volunteer
FROM Employees;

Does it make a difference that the selection of staff type is a check
box?
In table view it is demonstrated by a -1, this isn't a problem just
want
to
be able to get rid of unwanted names!

Thanks for speedy response!

:

Please copy and post the SQL of your query.

(Possibly unneeded instructions follow)
Open the query
Select View:Sql from the Menu
Select all the text
Copy it
Paste it into the message

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

I have a Personnel database that I have created queries from, so as
to
show
relevant information for certain data I need to collect and show.
However
there seems to be a problem, for example I would like to base a
query
on
staff type (we have paid, volunteer and placement), I need to be
able
to
show
only paid, only volunteer etc. However even if I only select
Volunteer
for
the tables I want included in my query - it shows all the names.

What am I doing wrong!?

 

[John Spencer]

Check boxes can be bound to a boolean (Yes/No) field or to a number field.
You did not answer my question about the field type.

This is the query you originally posted.
SELECT Employees.[First Name]
, Employees.[Last Name]
, Employees.Volunteer
FROM Employees

What values does it return for Volunteer?
Are the values left-aligned or right-aligned?
Please post the query you are using that isn't working.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

That isn't working either. In my database's form view, the selection for
staff type is check boxes.

I really really don't want to have to change the design of my database
again.

What else can I do?

Open your Employees table in design view
What type of field is Volunteer? Is it a number field, a yes/no field,
or a
text field?

If it is a Yes/No field then the answer I gave you previously should
apply.
As a test change TRUE to FALSE and see if you get all the records back.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

I have typed in true and now all my information has disappeared from the
query. What else should i be doing - I don't really want to have to
change
the design of the database.

:

It sounds as if you have three fields to show Staff type - Paid,
Volunteer,
Placement? Is that true?

To show just the records where Volunteer is checked you would need a
query
like:
SELECT Employees.[First Name], Employees.[Last Name],
Employees.Volunteer
FROM Employees
WHERE Volunteer = True

In Design view
Field: Volunteer
Criteria: True

Your table design would be better if you had one field for staff type
and
stored a value of Volunteer, Paid, or Placement in that field. A big
advantage to this would be if another type of staff was added (Part
time,
Full Time) then all you would need to do would be to enter that into
staff
type. With what I suspect is the current design, you would need to
redesign
your tables, forms, queries, and reports to handle the addition of a
new
staff type.
--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

SELECT Employees.[First Name], Employees.[Last Name],
Employees.Volunteer
FROM Employees;

Does it make a difference that the selection of staff type is a
check
box?
In table view it is demonstrated by a -1, this isn't a problem just
want
to
be able to get rid of unwanted names!

Thanks for speedy response!

:

Please copy and post the SQL of your query.

(Possibly unneeded instructions follow)
Open the query
Select View:Sql from the Menu
Select all the text
Copy it
Paste it into the message

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

I have a Personnel database that I have created queries from, so
as
to
show
relevant information for certain data I need to collect and show.
However
there seems to be a problem, for example I would like to base a
query
on
staff type (we have paid, volunteer and placement), I need to be
able
to
show
only paid, only volunteer etc. However even if I only select
Volunteer
for
the tables I want included in my query - it shows all the names.

What am I doing wrong!?

 

[Rhianne]

I have obsolutely no idea what you just asked me.

The query is "working" it just is displaying all the names in the database -
it does show a -1 in the staff type column (whilst in table view) but I do
not want this. I only want volunteer or paid staff etc to be shown.Does this
make sense?


SELECT Employees.[First Name], Employees.[Last Name], Employees.Placement,
Employees.Ferndale
FROM Employees;

This is not doing what I want it to do.

I do understand what you mean by field type. In form view my staff type is
selected by check boxes which are bound to a table???

Sorry to sound so confusing!

Check boxes can be bound to a boolean (Yes/No) field or to a number field.
You did not answer my question about the field type.

This is the query you originally posted.
SELECT Employees.[First Name]
, Employees.[Last Name]
, Employees.Volunteer
FROM Employees

What values does it return for Volunteer?
Are the values left-aligned or right-aligned?
Please post the query you are using that isn't working.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

That isn't working either. In my database's form view, the selection for
staff type is check boxes.

I really really don't want to have to change the design of my database
again.

What else can I do?

Open your Employees table in design view
What type of field is Volunteer? Is it a number field, a yes/no field,
or a
text field?

If it is a Yes/No field then the answer I gave you previously should
apply.
As a test change TRUE to FALSE and see if you get all the records back.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

I have typed in true and now all my information has disappeared from the
query. What else should i be doing - I don't really want to have to
change
the design of the database.

:

It sounds as if you have three fields to show Staff type - Paid,
Volunteer,
Placement? Is that true?

To show just the records where Volunteer is checked you would need a
query
like:
SELECT Employees.[First Name], Employees.[Last Name],
Employees.Volunteer
FROM Employees
WHERE Volunteer = True

In Design view
Field: Volunteer
Criteria: True

Your table design would be better if you had one field for staff type
and
stored a value of Volunteer, Paid, or Placement in that field. A big
advantage to this would be if another type of staff was added (Part
time,
Full Time) then all you would need to do would be to enter that into
staff
type. With what I suspect is the current design, you would need to
redesign
your tables, forms, queries, and reports to handle the addition of a
new
staff type.
--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

SELECT Employees.[First Name], Employees.[Last Name],
Employees.Volunteer
FROM Employees;

Does it make a difference that the selection of staff type is a
check
box?
In table view it is demonstrated by a -1, this isn't a problem just
want
to
be able to get rid of unwanted names!

Thanks for speedy response!

:

Please copy and post the SQL of your query.

(Possibly unneeded instructions follow)
Open the query
Select View:Sql from the Menu
Select all the text
Copy it
Paste it into the message

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

I have a Personnel database that I have created queries from, so
as
to
show
relevant information for certain data I need to collect and show.
However
there seems to be a problem, for example I would like to base a
query
on
staff type (we have paid, volunteer and placement), I need to be
able
to
show
only paid, only volunteer etc. However even if I only select
Volunteer
for
the tables I want included in my query - it shows all the names.

What am I doing wrong!?

 

[John Spencer]

OPEN the table in design view.
FIND the field
WHAT is the field type of the field that is showing -1? Does this field
ever show any other value? Or does it only show -1 and blank?

Your posted query doesn't show a field (column) that is entitled Staff Type.
Is one of the fields shown the staff type or is that another field?

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

I have obsolutely no idea what you just asked me.

The query is "working" it just is displaying all the names in the
database -
it does show a -1 in the staff type column (whilst in table view) but I do
not want this. I only want volunteer or paid staff etc to be shown.Does
this
make sense?


SELECT Employees.[First Name], Employees.[Last Name], Employees.Placement,
Employees.Ferndale
FROM Employees;

This is not doing what I want it to do.

I do understand what you mean by field type. In form view my staff type is
selected by check boxes which are bound to a table???

Sorry to sound so confusing!

Check boxes can be bound to a boolean (Yes/No) field or to a number
field.
You did not answer my question about the field type.

This is the query you originally posted.
SELECT Employees.[First Name]
, Employees.[Last Name]
, Employees.Volunteer
FROM Employees

What values does it return for Volunteer?
Are the values left-aligned or right-aligned?
Please post the query you are using that isn't working.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

That isn't working either. In my database's form view, the selection
for
staff type is check boxes.

I really really don't want to have to change the design of my database
again.

What else can I do?

:

Open your Employees table in design view
What type of field is Volunteer? Is it a number field, a yes/no
field,
or a
text field?

If it is a Yes/No field then the answer I gave you previously should
apply.
As a test change TRUE to FALSE and see if you get all the records
back.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

I have typed in true and now all my information has disappeared from
the
query. What else should i be doing - I don't really want to have to
change
the design of the database.

:

It sounds as if you have three fields to show Staff type - Paid,
Volunteer,
Placement? Is that true?

To show just the records where Volunteer is checked you would need
a
query
like:
SELECT Employees.[First Name], Employees.[Last Name],
Employees.Volunteer
FROM Employees
WHERE Volunteer = True

In Design view
Field: Volunteer
Criteria: True

Your table design would be better if you had one field for staff
type
and
stored a value of Volunteer, Paid, or Placement in that field. A
big
advantage to this would be if another type of staff was added (Part
time,
Full Time) then all you would need to do would be to enter that
into
staff
type. With what I suspect is the current design, you would need to
redesign
your tables, forms, queries, and reports to handle the addition of
a
new
staff type.
--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

SELECT Employees.[First Name], Employees.[Last Name],
Employees.Volunteer
FROM Employees;

Does it make a difference that the selection of staff type is a
check
box?
In table view it is demonstrated by a -1, this isn't a problem
just
want
to
be able to get rid of unwanted names!

Thanks for speedy response!

:

Please copy and post the SQL of your query.

(Possibly unneeded instructions follow)
Open the query
Select View:Sql from the Menu
Select all the text
Copy it
Paste it into the message

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

I have a Personnel database that I have created queries from,
so
as
to
show
relevant information for certain data I need to collect and
show.
However
there seems to be a problem, for example I would like to base
a
query
on
staff type (we have paid, volunteer and placement), I need to
be
able
to
show
only paid, only volunteer etc. However even if I only select
Volunteer
for
the tables I want included in my query - it shows all the
names.

What am I doing wrong!?

 

[Rhianne]

In design view it does not show -1 or anything else. It is when it is in
table view (the particular) query that in the volunteer column (I have at
least 6 differing staff types) shows -1. When I open design and amend the
criteria in the relevant column to -1 or true or false, when I reopen the
query in table view, nothing appears apart from the empty columns, with the
appropriate headings.

OPEN the table in design view.
FIND the field
WHAT is the field type of the field that is showing -1? Does this field
ever show any other value? Or does it only show -1 and blank?

Your posted query doesn't show a field (column) that is entitled Staff Type.
Is one of the fields shown the staff type or is that another field?

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

I have obsolutely no idea what you just asked me.

The query is "working" it just is displaying all the names in the
database -
it does show a -1 in the staff type column (whilst in table view) but I do
not want this. I only want volunteer or paid staff etc to be shown.Does
this
make sense?


SELECT Employees.[First Name], Employees.[Last Name], Employees.Placement,
Employees.Ferndale
FROM Employees;

This is not doing what I want it to do.

I do understand what you mean by field type. In form view my staff type is
selected by check boxes which are bound to a table???

Sorry to sound so confusing!

Check boxes can be bound to a boolean (Yes/No) field or to a number
field.
You did not answer my question about the field type.

This is the query you originally posted.
SELECT Employees.[First Name]
, Employees.[Last Name]
, Employees.Volunteer
FROM Employees

What values does it return for Volunteer?
Are the values left-aligned or right-aligned?
Please post the query you are using that isn't working.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

That isn't working either. In my database's form view, the selection
for
staff type is check boxes.

I really really don't want to have to change the design of my database
again.

What else can I do?

:

Open your Employees table in design view
What type of field is Volunteer? Is it a number field, a yes/no
field,
or a
text field?

If it is a Yes/No field then the answer I gave you previously should
apply.
As a test change TRUE to FALSE and see if you get all the records
back.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

I have typed in true and now all my information has disappeared from
the
query. What else should i be doing - I don't really want to have to
change
the design of the database.

:

It sounds as if you have three fields to show Staff type - Paid,
Volunteer,
Placement? Is that true?

To show just the records where Volunteer is checked you would need
a
query
like:
SELECT Employees.[First Name], Employees.[Last Name],
Employees.Volunteer
FROM Employees
WHERE Volunteer = True

In Design view
Field: Volunteer
Criteria: True

Your table design would be better if you had one field for staff
type
and
stored a value of Volunteer, Paid, or Placement in that field. A
big
advantage to this would be if another type of staff was added (Part
time,
Full Time) then all you would need to do would be to enter that
into
staff
type. With what I suspect is the current design, you would need to
redesign
your tables, forms, queries, and reports to handle the addition of
a
new
staff type.
--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

SELECT Employees.[First Name], Employees.[Last Name],
Employees.Volunteer
FROM Employees;

Does it make a difference that the selection of staff type is a
check
box?
In table view it is demonstrated by a -1, this isn't a problem
just
want
to
be able to get rid of unwanted names!

Thanks for speedy response!

:

Please copy and post the SQL of your query.

(Possibly unneeded instructions follow)
Open the query
Select View:Sql from the Menu
Select all the text
Copy it
Paste it into the message

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

I have a Personnel database that I have created queries from,
so
as
to
show
relevant information for certain data I need to collect and
show.
However
there seems to be a problem, for example I would like to base
a
query
on
staff type (we have paid, volunteer and placement), I need to
be
able
to
show
only paid, only volunteer etc. However even if I only select
Volunteer
for
the tables I want included in my query - it shows all the
names.

What am I doing wrong!?

 

[John Spencer]

Please post the SQL of the query that is showing no records returned.
Perhaps you are doing something other than what I expect when you are
inputting the criteria.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

In design view it does not show -1 or anything else. It is when it is in
table view (the particular) query that in the volunteer column (I have at
least 6 differing staff types) shows -1. When I open design and amend the
criteria in the relevant column to -1 or true or false, when I reopen the
query in table view, nothing appears apart from the empty columns, with
the
appropriate headings.

OPEN the table in design view.
FIND the field
WHAT is the field type of the field that is showing -1? Does this field
ever show any other value? Or does it only show -1 and blank?

Your posted query doesn't show a field (column) that is entitled Staff
Type.
Is one of the fields shown the staff type or is that another field?

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

I have obsolutely no idea what you just asked me.

The query is "working" it just is displaying all the names in the
database -
it does show a -1 in the staff type column (whilst in table view) but I
do
not want this. I only want volunteer or paid staff etc to be shown.Does
this
make sense?


SELECT Employees.[First Name], Employees.[Last Name],
Employees.Placement,
Employees.Ferndale
FROM Employees;

This is not doing what I want it to do.

I do understand what you mean by field type. In form view my staff type
is
selected by check boxes which are bound to a table???

Sorry to sound so confusing!

:

Check boxes can be bound to a boolean (Yes/No) field or to a number
field.
You did not answer my question about the field type.

This is the query you originally posted.
SELECT Employees.[First Name]
, Employees.[Last Name]
, Employees.Volunteer
FROM Employees

What values does it return for Volunteer?
Are the values left-aligned or right-aligned?
Please post the query you are using that isn't working.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

That isn't working either. In my database's form view, the selection
for
staff type is check boxes.

I really really don't want to have to change the design of my
database
again.

What else can I do?

:

Open your Employees table in design view
What type of field is Volunteer? Is it a number field, a yes/no
field,
or a
text field?

If it is a Yes/No field then the answer I gave you previously
should
apply.
As a test change TRUE to FALSE and see if you get all the records
back.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

I have typed in true and now all my information has disappeared
from
the
query. What else should i be doing - I don't really want to have
to
change
the design of the database.

:

It sounds as if you have three fields to show Staff type - Paid,
Volunteer,
Placement? Is that true?

To show just the records where Volunteer is checked you would
need
a
query
like:
SELECT Employees.[First Name], Employees.[Last Name],
Employees.Volunteer
FROM Employees
WHERE Volunteer = True

In Design view
Field: Volunteer
Criteria: True

Your table design would be better if you had one field for staff
type
and
stored a value of Volunteer, Paid, or Placement in that field.
A
big
advantage to this would be if another type of staff was added
(Part
time,
Full Time) then all you would need to do would be to enter that
into
staff
type. With what I suspect is the current design, you would need
to
redesign
your tables, forms, queries, and reports to handle the addition
of
a
new
staff type.
--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

SELECT Employees.[First Name], Employees.[Last Name],
Employees.Volunteer
FROM Employees;

Does it make a difference that the selection of staff type is
a
check
box?
In table view it is demonstrated by a -1, this isn't a problem
just
want
to
be able to get rid of unwanted names!

Thanks for speedy response!

:

Please copy and post the SQL of your query.

(Possibly unneeded instructions follow)
Open the query
Select View:Sql from the Menu
Select all the text
Copy it
Paste it into the message

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

message
I have a Personnel database that I have created queries
from,
so
as
to
show
relevant information for certain data I need to collect and
show.
However
there seems to be a problem, for example I would like to
base
a
query
on
staff type (we have paid, volunteer and placement), I need
to
be
able
to
show
only paid, only volunteer etc. However even if I only
select
Volunteer
for
the tables I want included in my query - it shows all the
names.

What am I doing wrong!?

 

[Rhianne]

SELECT Employees.[First Name], Employees.[Last Name], Employees.Volunteer,
Employees.Ferndale
FROM Employees
WHERE (((Employees.Ferndale)="true"));

I included the "true" in volunteer column's criteria - as per instructions.
If I enter false, then it is the same outcome.

Thanks.

Please post the SQL of the query that is showing no records returned.
Perhaps you are doing something other than what I expect when you are
inputting the criteria.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

In design view it does not show -1 or anything else. It is when it is in
table view (the particular) query that in the volunteer column (I have at
least 6 differing staff types) shows -1. When I open design and amend the
criteria in the relevant column to -1 or true or false, when I reopen the
query in table view, nothing appears apart from the empty columns, with
the
appropriate headings.

OPEN the table in design view.
FIND the field
WHAT is the field type of the field that is showing -1? Does this field
ever show any other value? Or does it only show -1 and blank?

Your posted query doesn't show a field (column) that is entitled Staff
Type.
Is one of the fields shown the staff type or is that another field?

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

I have obsolutely no idea what you just asked me.

The query is "working" it just is displaying all the names in the
database -
it does show a -1 in the staff type column (whilst in table view) but I
do
not want this. I only want volunteer or paid staff etc to be shown.Does
this
make sense?


SELECT Employees.[First Name], Employees.[Last Name],
Employees.Placement,
Employees.Ferndale
FROM Employees;

This is not doing what I want it to do.

I do understand what you mean by field type. In form view my staff type
is
selected by check boxes which are bound to a table???

Sorry to sound so confusing!

:

Check boxes can be bound to a boolean (Yes/No) field or to a number
field.
You did not answer my question about the field type.

This is the query you originally posted.
SELECT Employees.[First Name]
, Employees.[Last Name]
, Employees.Volunteer
FROM Employees

What values does it return for Volunteer?
Are the values left-aligned or right-aligned?
Please post the query you are using that isn't working.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

That isn't working either. In my database's form view, the selection
for
staff type is check boxes.

I really really don't want to have to change the design of my
database
again.

What else can I do?

:

Open your Employees table in design view
What type of field is Volunteer? Is it a number field, a yes/no
field,
or a
text field?

If it is a Yes/No field then the answer I gave you previously
should
apply.
As a test change TRUE to FALSE and see if you get all the records
back.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

I have typed in true and now all my information has disappeared
from
the
query. What else should i be doing - I don't really want to have
to
change
the design of the database.

:

It sounds as if you have three fields to show Staff type - Paid,
Volunteer,
Placement? Is that true?

To show just the records where Volunteer is checked you would
need
a
query
like:
SELECT Employees.[First Name], Employees.[Last Name],
Employees.Volunteer
FROM Employees
WHERE Volunteer = True

In Design view
Field: Volunteer
Criteria: True

Your table design would be better if you had one field for staff
type
and
stored a value of Volunteer, Paid, or Placement in that field.
A
big
advantage to this would be if another type of staff was added
(Part
time,
Full Time) then all you would need to do would be to enter that
into
staff
type. With what I suspect is the current design, you would need
to
redesign
your tables, forms, queries, and reports to handle the addition
of
a
new
staff type.
--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

SELECT Employees.[First Name], Employees.[Last Name],
Employees.Volunteer
FROM Employees;

Does it make a difference that the selection of staff type is
a
check
box?
In table view it is demonstrated by a -1, this isn't a problem
just
want
to
be able to get rid of unwanted names!

Thanks for speedy response!

:

Please copy and post the SQL of your query.

(Possibly unneeded instructions follow)
Open the query
Select View:Sql from the Menu
Select all the text
Copy it
Paste it into the message

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

message
I have a Personnel database that I have created queries
from,
so
as
to
show
relevant information for certain data I need to collect and
show.
However
there seems to be a problem, for example I would like to
base
a
query
on
staff type (we have paid, volunteer and placement), I need
to
be
able
to
show
only paid, only volunteer etc. However even if I only
select
Volunteer
for
the tables I want included in my query - it shows all the
names.

What am I doing wrong!?

 

[John Spencer]

NO QUOTES if FernDale is a YES/No field which checkboxes are normally based
on a Yes/No field

SELECT Employees.[First Name]
, Employees.[Last Name]
, Employees.Volunteer,
Employees.Ferndale
FROM Employees
WHERE (((Employees.Ferndale)=TRUE));

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

SELECT Employees.[First Name], Employees.[Last Name], Employees.Volunteer,
Employees.Ferndale
FROM Employees
WHERE (((Employees.Ferndale)="true"));

I included the "true" in volunteer column's criteria - as per
instructions.
If I enter false, then it is the same outcome.

Thanks.

Please post the SQL of the query that is showing no records returned.
Perhaps you are doing something other than what I expect when you are
inputting the criteria.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

In design view it does not show -1 or anything else. It is when it is
in
table view (the particular) query that in the volunteer column (I have
at
least 6 differing staff types) shows -1. When I open design and amend
the
criteria in the relevant column to -1 or true or false, when I reopen
the
query in table view, nothing appears apart from the empty columns, with
the
appropriate headings.



:

OPEN the table in design view.
FIND the field
WHAT is the field type of the field that is showing -1? Does this
field
ever show any other value? Or does it only show -1 and blank?

Your posted query doesn't show a field (column) that is entitled Staff
Type.
Is one of the fields shown the staff type or is that another field?

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

I have obsolutely no idea what you just asked me.

The query is "working" it just is displaying all the names in the
database -
it does show a -1 in the staff type column (whilst in table view)
but I
do
not want this. I only want volunteer or paid staff etc to be
shown.Does
this
make sense?


SELECT Employees.[First Name], Employees.[Last Name],
Employees.Placement,
Employees.Ferndale
FROM Employees;

This is not doing what I want it to do.

I do understand what you mean by field type. In form view my staff
type
is
selected by check boxes which are bound to a table???

Sorry to sound so confusing!

:

Check boxes can be bound to a boolean (Yes/No) field or to a number
field.
You did not answer my question about the field type.

This is the query you originally posted.
SELECT Employees.[First Name]
, Employees.[Last Name]
, Employees.Volunteer
FROM Employees

What values does it return for Volunteer?
Are the values left-aligned or right-aligned?
Please post the query you are using that isn't working.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

That isn't working either. In my database's form view, the
selection
for
staff type is check boxes.

I really really don't want to have to change the design of my
database
again.

What else can I do?

:

Open your Employees table in design view
What type of field is Volunteer? Is it a number field, a yes/no
field,
or a
text field?

If it is a Yes/No field then the answer I gave you previously
should
apply.
As a test change TRUE to FALSE and see if you get all the
records
back.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

I have typed in true and now all my information has disappeared
from
the
query. What else should i be doing - I don't really want to
have
to
change
the design of the database.

:

It sounds as if you have three fields to show Staff type -
Paid,
Volunteer,
Placement? Is that true?

To show just the records where Volunteer is checked you would
need
a
query
like:
SELECT Employees.[First Name], Employees.[Last Name],
Employees.Volunteer
FROM Employees
WHERE Volunteer = True

In Design view
Field: Volunteer
Criteria: True

Your table design would be better if you had one field for
staff
type
and
stored a value of Volunteer, Paid, or Placement in that
field.
A
big
advantage to this would be if another type of staff was added
(Part
time,
Full Time) then all you would need to do would be to enter
that
into
staff
type. With what I suspect is the current design, you would
need
to
redesign
your tables, forms, queries, and reports to handle the
addition
of
a
new
staff type.
--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

message
SELECT Employees.[First Name], Employees.[Last Name],
Employees.Volunteer
FROM Employees;

Does it make a difference that the selection of staff type
is
a
check
box?
In table view it is demonstrated by a -1, this isn't a
problem
just
want
to
be able to get rid of unwanted names!

Thanks for speedy response!

:

Please copy and post the SQL of your query.

(Possibly unneeded instructions follow)
Open the query
Select View:Sql from the Menu
Select all the text
Copy it
Paste it into the message

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

message
I have a Personnel database that I have created queries
from,
so
as
to
show
relevant information for certain data I need to collect
and
show.
However
there seems to be a problem, for example I would like to
base
a
query
on
staff type (we have paid, volunteer and placement), I
need
to
be
able
to
show
only paid, only volunteer etc. However even if I only
select
Volunteer
for
the tables I want included in my query - it shows all
the
names.

What am I doing wrong!?

 

[Rhianne]

I copied and pastied what you left below and now when I open my query it has
everyone as based at Ferndale (we have two brances Ferndale and Aberdare),
and it still is showing all staff - not just volunteers.

I think I am slowly going mad..............

NO QUOTES if FernDale is a YES/No field which checkboxes are normally based
on a Yes/No field

SELECT Employees.[First Name]
, Employees.[Last Name]
, Employees.Volunteer,
Employees.Ferndale
FROM Employees
WHERE (((Employees.Ferndale)=TRUE));

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

SELECT Employees.[First Name], Employees.[Last Name], Employees.Volunteer,
Employees.Ferndale
FROM Employees
WHERE (((Employees.Ferndale)="true"));

I included the "true" in volunteer column's criteria - as per
instructions.
If I enter false, then it is the same outcome.

Thanks.

Please post the SQL of the query that is showing no records returned.
Perhaps you are doing something other than what I expect when you are
inputting the criteria.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

In design view it does not show -1 or anything else. It is when it is
in
table view (the particular) query that in the volunteer column (I have
at
least 6 differing staff types) shows -1. When I open design and amend
the
criteria in the relevant column to -1 or true or false, when I reopen
the
query in table view, nothing appears apart from the empty columns, with
the
appropriate headings.



:

OPEN the table in design view.
FIND the field
WHAT is the field type of the field that is showing -1? Does this
field
ever show any other value? Or does it only show -1 and blank?

Your posted query doesn't show a field (column) that is entitled Staff
Type.
Is one of the fields shown the staff type or is that another field?

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

I have obsolutely no idea what you just asked me.

The query is "working" it just is displaying all the names in the
database -
it does show a -1 in the staff type column (whilst in table view)
but I
do
not want this. I only want volunteer or paid staff etc to be
shown.Does
this
make sense?


SELECT Employees.[First Name], Employees.[Last Name],
Employees.Placement,
Employees.Ferndale
FROM Employees;

This is not doing what I want it to do.

I do understand what you mean by field type. In form view my staff
type
is
selected by check boxes which are bound to a table???

Sorry to sound so confusing!

:

Check boxes can be bound to a boolean (Yes/No) field or to a number
field.
You did not answer my question about the field type.

This is the query you originally posted.
SELECT Employees.[First Name]
, Employees.[Last Name]
, Employees.Volunteer
FROM Employees

What values does it return for Volunteer?
Are the values left-aligned or right-aligned?
Please post the query you are using that isn't working.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

That isn't working either. In my database's form view, the
selection
for
staff type is check boxes.

I really really don't want to have to change the design of my
database
again.

What else can I do?

:

Open your Employees table in design view
What type of field is Volunteer? Is it a number field, a yes/no
field,
or a
text field?

If it is a Yes/No field then the answer I gave you previously
should
apply.
As a test change TRUE to FALSE and see if you get all the
records
back.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

I have typed in true and now all my information has disappeared
from
the
query. What else should i be doing - I don't really want to
have
to
change
the design of the database.

:

It sounds as if you have three fields to show Staff type -
Paid,
Volunteer,
Placement? Is that true?

To show just the records where Volunteer is checked you would
need
a
query
like:
SELECT Employees.[First Name], Employees.[Last Name],
Employees.Volunteer
FROM Employees
WHERE Volunteer = True

In Design view
Field: Volunteer
Criteria: True

Your table design would be better if you had one field for
staff
type
and
stored a value of Volunteer, Paid, or Placement in that
field.
A
big
advantage to this would be if another type of staff was added
(Part
time,
Full Time) then all you would need to do would be to enter
that
into
staff
type. With what I suspect is the current design, you would
need
to
redesign
your tables, forms, queries, and reports to handle the
addition
of
a
new
staff type.
--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

message
SELECT Employees.[First Name], Employees.[Last Name],
Employees.Volunteer
FROM Employees;

Does it make a difference that the selection of staff type
is
a
check
box?
In table view it is demonstrated by a -1, this isn't a
problem
just
want
to
be able to get rid of unwanted names!

Thanks for speedy response!

:

Please copy and post the SQL of your query.

(Possibly unneeded instructions follow)
Open the query
Select View:Sql from the Menu
Select all the text
Copy it
Paste it into the message

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

message
I have a Personnel database that I have created queries
from,
so
as
to
show
relevant information for certain data I need to collect
and
show.
However
there seems to be a problem, for example I would like to
base
a
query
on
staff type (we have paid, volunteer and placement), I
need
to
be
able
to
show
only paid, only volunteer etc. However even if I only
select
Volunteer
for
the tables I want included in my query - it shows all
the

 

[John Spencer]

How do you know if someone is a volunteer Do you have a field that tells
you this?

TRY the following - it should display only those employees at Ferndale who
are volunteers. This assumes tht Volunteer is a checkbox field just like
Ferndale is a checkbox.

SELECT Employees.[First Name]
, Employees.[Last Name]
, Employees.Volunteer
, Employees.Ferndale
FROM Employees
WHERE Employees.Ferndale=True
AND Volunteer = True

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

I copied and pastied what you left below and now when I open my query it
has
everyone as based at Ferndale (we have two brances Ferndale and Aberdare),
and it still is showing all staff - not just volunteers.

I think I am slowly going mad..............

NO QUOTES if FernDale is a YES/No field which checkboxes are normally
based
on a Yes/No field

SELECT Employees.[First Name]
, Employees.[Last Name]
, Employees.Volunteer,
Employees.Ferndale
FROM Employees
WHERE (((Employees.Ferndale)=TRUE));

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

SELECT Employees.[First Name], Employees.[Last Name],
Employees.Volunteer,
Employees.Ferndale
FROM Employees
WHERE (((Employees.Ferndale)="true"));

I included the "true" in volunteer column's criteria - as per
instructions.
If I enter false, then it is the same outcome.

Thanks.


:

Please post the SQL of the query that is showing no records returned.
Perhaps you are doing something other than what I expect when you are
inputting the criteria.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

In design view it does not show -1 or anything else. It is when it
is
in
table view (the particular) query that in the volunteer column (I
have
at
least 6 differing staff types) shows -1. When I open design and
amend
the
criteria in the relevant column to -1 or true or false, when I
reopen
the
query in table view, nothing appears apart from the empty columns,
with
the
appropriate headings.



:

OPEN the table in design view.
FIND the field
WHAT is the field type of the field that is showing -1? Does this
field
ever show any other value? Or does it only show -1 and blank?

Your posted query doesn't show a field (column) that is entitled
Staff
Type.
Is one of the fields shown the staff type or is that another field?

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

I have obsolutely no idea what you just asked me.

The query is "working" it just is displaying all the names in the
database -
it does show a -1 in the staff type column (whilst in table view)
but I
do
not want this. I only want volunteer or paid staff etc to be
shown.Does
this
make sense?


SELECT Employees.[First Name], Employees.[Last Name],
Employees.Placement,
Employees.Ferndale
FROM Employees;

This is not doing what I want it to do.

I do understand what you mean by field type. In form view my
staff
type
is
selected by check boxes which are bound to a table???

Sorry to sound so confusing!

:

Check boxes can be bound to a boolean (Yes/No) field or to a
number
field.
You did not answer my question about the field type.

This is the query you originally posted.
SELECT Employees.[First Name]
, Employees.[Last Name]
, Employees.Volunteer
FROM Employees

What values does it return for Volunteer?
Are the values left-aligned or right-aligned?
Please post the query you are using that isn't working.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

That isn't working either. In my database's form view, the
selection
for
staff type is check boxes.

I really really don't want to have to change the design of my
database
again.

What else can I do?

:

Open your Employees table in design view
What type of field is Volunteer? Is it a number field, a
yes/no
field,
or a
text field?

If it is a Yes/No field then the answer I gave you previously
should
apply.
As a test change TRUE to FALSE and see if you get all the
records
back.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

message
I have typed in true and now all my information has
disappeared
from
the
query. What else should i be doing - I don't really want to
have
to
change
the design of the database.

:

It sounds as if you have three fields to show Staff type -
Paid,
Volunteer,
Placement? Is that true?

To show just the records where Volunteer is checked you
would
need
a
query
like:
SELECT Employees.[First Name], Employees.[Last Name],
Employees.Volunteer
FROM Employees
WHERE Volunteer = True

In Design view
Field: Volunteer
Criteria: True

Your table design would be better if you had one field for
staff
type
and
stored a value of Volunteer, Paid, or Placement in that
field.
A
big
advantage to this would be if another type of staff was
added
(Part
time,
Full Time) then all you would need to do would be to enter
that
into
staff
type. With what I suspect is the current design, you
would
need
to
redesign
your tables, forms, queries, and reports to handle the
addition
of
a
new
staff type.
--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

message
SELECT Employees.[First Name], Employees.[Last Name],
Employees.Volunteer
FROM Employees;

Does it make a difference that the selection of staff
type
is
a
check
box?
In table view it is demonstrated by a -1, this isn't a
problem
just
want
to
be able to get rid of unwanted names!

Thanks for speedy response!

:

Please copy and post the SQL of your query.

(Possibly unneeded instructions follow)
Open the query
Select View:Sql from the Menu
Select all the text
Copy it
Paste it into the message

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

message
I have a Personnel database that I have created
queries
from,
so
as
to
show
relevant information for certain data I need to
collect
and
show.
However
there seems to be a problem, for example I would like
to
base
a
query
on
staff type (we have paid, volunteer and placement), I
need
to
be
able
to
show
only paid, only volunteer etc. However even if I only
select
Volunteer
for
the tables I want included in my query - it shows all
the

 

[Rhianne]

When I enter the infromation from below - it only shows a selection of names
(which are all volunteers - but not all volunteers are showing) and lists
them all as based at Ferndale, which is incorrect.

I know someone is a volunteers as I have a checkbox in form view and this is
bound to a table - volunteers.

How do you know if someone is a volunteer Do you have a field that tells
you this?

TRY the following - it should display only those employees at Ferndale who
are volunteers. This assumes tht Volunteer is a checkbox field just like
Ferndale is a checkbox.

SELECT Employees.[First Name]
, Employees.[Last Name]
, Employees.Volunteer
, Employees.Ferndale
FROM Employees
WHERE Employees.Ferndale=True
AND Volunteer = True

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

I copied and pastied what you left below and now when I open my query it
has
everyone as based at Ferndale (we have two brances Ferndale and Aberdare),
and it still is showing all staff - not just volunteers.

I think I am slowly going mad..............

NO QUOTES if FernDale is a YES/No field which checkboxes are normally
based
on a Yes/No field

SELECT Employees.[First Name]
, Employees.[Last Name]
, Employees.Volunteer,
Employees.Ferndale
FROM Employees
WHERE (((Employees.Ferndale)=TRUE));

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

SELECT Employees.[First Name], Employees.[Last Name],
Employees.Volunteer,
Employees.Ferndale
FROM Employees
WHERE (((Employees.Ferndale)="true"));

I included the "true" in volunteer column's criteria - as per
instructions.
If I enter false, then it is the same outcome.

Thanks.


:

Please post the SQL of the query that is showing no records returned.
Perhaps you are doing something other than what I expect when you are
inputting the criteria.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

In design view it does not show -1 or anything else. It is when it
is
in
table view (the particular) query that in the volunteer column (I
have
at
least 6 differing staff types) shows -1. When I open design and
amend
the
criteria in the relevant column to -1 or true or false, when I
reopen
the
query in table view, nothing appears apart from the empty columns,
with
the
appropriate headings.



:

OPEN the table in design view.
FIND the field
WHAT is the field type of the field that is showing -1? Does this
field
ever show any other value? Or does it only show -1 and blank?

Your posted query doesn't show a field (column) that is entitled
Staff
Type.
Is one of the fields shown the staff type or is that another field?

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

I have obsolutely no idea what you just asked me.

The query is "working" it just is displaying all the names in the
database -
it does show a -1 in the staff type column (whilst in table view)
but I
do
not want this. I only want volunteer or paid staff etc to be
shown.Does
this
make sense?


SELECT Employees.[First Name], Employees.[Last Name],
Employees.Placement,
Employees.Ferndale
FROM Employees;

This is not doing what I want it to do.

I do understand what you mean by field type. In form view my
staff
type
is
selected by check boxes which are bound to a table???

Sorry to sound so confusing!

:

Check boxes can be bound to a boolean (Yes/No) field or to a
number
field.
You did not answer my question about the field type.

This is the query you originally posted.
SELECT Employees.[First Name]
, Employees.[Last Name]
, Employees.Volunteer
FROM Employees

What values does it return for Volunteer?
Are the values left-aligned or right-aligned?
Please post the query you are using that isn't working.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

That isn't working either. In my database's form view, the
selection
for
staff type is check boxes.

I really really don't want to have to change the design of my
database
again.

What else can I do?

:

Open your Employees table in design view
What type of field is Volunteer? Is it a number field, a
yes/no
field,
or a
text field?

If it is a Yes/No field then the answer I gave you previously
should
apply.
As a test change TRUE to FALSE and see if you get all the
records
back.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

message
I have typed in true and now all my information has
disappeared
from
the
query. What else should i be doing - I don't really want to
have
to
change
the design of the database.

:

It sounds as if you have three fields to show Staff type -
Paid,
Volunteer,
Placement? Is that true?

To show just the records where Volunteer is checked you
would
need
a
query
like:
SELECT Employees.[First Name], Employees.[Last Name],
Employees.Volunteer
FROM Employees
WHERE Volunteer = True

In Design view
Field: Volunteer
Criteria: True

Your table design would be better if you had one field for
staff
type
and
stored a value of Volunteer, Paid, or Placement in that
field.
A
big
advantage to this would be if another type of staff was
added
(Part
time,
Full Time) then all you would need to do would be to enter
that
into
staff
type. With what I suspect is the current design, you
would
need
to
redesign
your tables, forms, queries, and reports to handle the
addition
of
a
new
staff type.
--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

message
SELECT Employees.[First Name], Employees.[Last Name],
Employees.Volunteer
FROM Employees;

Does it make a difference that the selection of staff
type
is
a
check
box?
In table view it is demonstrated by a -1, this isn't a
problem
just
want
to
be able to get rid of unwanted names!

Thanks for speedy response!