Comparison or Difference Results: NEW

[Charles Phillips]

Hello,
I have a database in MS-Access 2003.
The db is being used to manage the deployment & migration of 500+ laptops.
I have a field named "completed". I would like write a query that subtracts
the number of completed laptops from the total number of laptops.
I would like to show results in a chart.
Can someone point me to some samples or examples????


Thank you,

Charles L. Phillips

 

[Charles Phillips]

Hello,
I have a database in MS-Access 2003.
The db is being used to manage the deployment & migration of 500+ laptops.

I have a field name "Model". This field has ALL the laptop models. To get
the total # of laptops I used the following:

Total Systems =Count([Model])

I have a field named "Results (completed)". I would like write a query that
subtracts the number of completed laptops from the total number of laptops.

Example:

Laptops to do: =Count([Model]) - =Count([Results(Completed)])

Can someone point me to some samples or examples????


Thank you,

Charles L. Phillips

 

[Brendan Reynolds]

I'm assuming that 'Results (completed)' is a Boolean ('Yes/No') field ...

=DCount("*","Table1","[Results (completed)] = False")

Replace "Table1" with the name of your table.

See 'DCount function' in the help file for more information.

--
Brendan Reynolds
Access MVP

Hello,
I have a database in MS-Access 2003.
The db is being used to manage the deployment & migration of 500+ laptops.

I have a field name "Model". This field has ALL the laptop models. To get
the total # of laptops I used the following:

Total Systems =Count([Model])

I have a field named "Results (completed)". I would like write a query
that subtracts the number of completed laptops from the total number of
laptops.

Example:

Laptops to do: =Count([Model]) - =Count([Results(Completed)])

Can someone point me to some samples or examples????


Thank you,

Charles L. Phillips

Hello,
I have a database in MS-Access 2003.
The db is being used to manage the deployment & migration of 500+
laptops.
I have a field named "completed". I would like write a query that
subtracts the number of completed laptops from the total number of
laptops.
I would like to show results in a chart.
Can someone point me to some samples or examples????


Thank you,

Charles L. Phillips

 

[Charles Phillips]

Hello,
"Thank You"...


Charles L. Phillips

I'm assuming that 'Results (completed)' is a Boolean ('Yes/No') field ...

=DCount("*","Table1","[Results (completed)] = False")

Replace "Table1" with the name of your table.

See 'DCount function' in the help file for more information.

--
Brendan Reynolds
Access MVP

Hello,
I have a database in MS-Access 2003.
The db is being used to manage the deployment & migration of 500+
laptops.

I have a field name "Model". This field has ALL the laptop models. To get
the total # of laptops I used the following:

Total Systems =Count([Model])

I have a field named "Results (completed)". I would like write a query
that subtracts the number of completed laptops from the total number of
laptops.

Example:

Laptops to do: =Count([Model]) - =Count([Results(Completed)])

Can someone point me to some samples or examples????


Thank you,

Charles L. Phillips

Hello,
I have a database in MS-Access 2003.
The db is being used to manage the deployment & migration of 500+
laptops.
I have a field named "completed". I would like write a query that
subtracts the number of completed laptops from the total number of
laptops.
I would like to show results in a chart.
Can someone point me to some samples or examples????


Thank you,

Charles L. Phillips