Search Result

Hi,

I have two tables, [Rules] and [Process] which are in a many to many relationship via a junction table[JRule_Process]. It has the following field (relevant ones for this discussion):

[Rules]
RuleID
RuleName

[Process]
ProcessID
DetailProcessNa me

[JRule_Process]
JunctionID
RuleID
ProcessID


I have almost 5000 unique...

I have 2 tables both have a primary key which links them,

How can I run a count query to look at the first table and check the id, then look at the second table and count up how many records have that same id?

table one
key - software_make
1 Adobe
2 Microsoft


table two

key - asset - Number_installe d
2 11454 1
2 1245 1
...

I have a database of people who call into our office for assistance. They are designated by their location (A drop down menu with City/County/Out of County) and then the Nature of Problem is checked off (Eviction, Request for Housing, Implied Warranty) (Sometimes someone needs all three options).

I would like to show in a monthly report how many times a check box was clicked for the Nature of Problem and the location the call was...

Hi, im doing a CD library database and i have two tables, "CD" and "CD Copies" linked by "Catalogue ID No" field. Bellow is a picture of what i mean (click the link below it if it doesnt work!):


https://picasaweb.google.com/1167658...75094040621826

I would like to return the number of "CD Coppies" a selected "CD" has,...

I'm trying to consolidate inventory records in db. (I'm displaying the result in a table form but for this post I'm putting it simple)

table_name= PC:
department - msoffice
IT - 2000
IT - 2002
IT - 2000
SNM - 2000
SNM - 2003
Finance - 2003
-----------------------------------

expected output:
msoffice - dept - qty
2000 - IT - 2
2000 - SNM - 1
2002 - IT...

I have a login form in my access database that is working perfectly. I would like to count how many times the command button is clicked so I can do things such as close the program aftr so many failed attempts, etc.

Can anyone tell me how to make this happen? How do I count the number of times a button us clicked?

Thank you.

Hi there,

looked around quite a bit, but haven't really found a nice solution how to read PDF (and eventually Word) documents, in order to provide keywords for a Portal search engine, and link back to the document.

Can anyone give me a hint for a usable script? Thanks a lot!

in Microsoft Access '07, I am creating a Database that tracks whether or not a specific department is deficient in specific areas. I am using Booleans in the form of check marks to annotate which departments have which deficiencies. True = Deficient, and False = Satisfactory.
I would like to summarize this data in another table that has all of the companies departments, and all of the information of said departments, in it, while stating the...

Hello,

I am working on a database with the following structure:

ID trait1 trait2
1 899 789
1 600 700
1 500 560
2 430 560
2 600 700
2 800 230
2 500 650
...

So I have multiple measurements per each individual.
I would like to add a column numbering observations for each individual.
I would...

Access 2010. I have a drop down list with "Male" or "Female" as the choice. I wish to count the number of Males and the number of Females to show on a report. The Field name is [Gender] which is stored in a table.

Is there a code to use in an unbounded text box that will show the totals on a report? I have tried =Count(If[Gender])="Female")) and it returns 'Error' as the value.

Thank you,...

I have a query set up with a list of records with check box fields, Text boxes and one text field with numbers.

I used this expression to get the sum total of [Text box with numbers] per total records by counting [Text Box A]

=Sum([Text Box with numbers])/Count([Text Box A])

80/21=3.81



Now I want the total of [Text box with numbers] per records with [Check Box A] checked....

Can anyone tell the perl script that counts the time when we are online?

In Crystal, I've come across the following code but don't really understand it:
I'm involved in creating equivalent reports from an old system using Crystal, into a new system with SQL Server 2005 without Crystal, so i need to understand what exactly this statement does so i can do something which produces equivalent results in SQL Server.
The fact that it repeats the...

(Using Access 2007)
For a report I need to create and submit, they want counts of how many employees fit into a few given categories, and then they want some simple totals involving those count numbers.

I know how to create a query that returns the count number for a given category. I use the count function to count how many records are returned by the queries I've created to define the categories. That's easy.
...

I would greatly appreciate it if any one of you kind souls could take some time to help me out with an interesting bug in my program. I have tried many times to find the source of the problem unsuccessfully and believe that a second set of eyes will do wonders. Thanks in advance for reading my post.

*************** *************** ***

So, after quite some work, I was able to get this program to run (I am a bit of a...