Child ID Access

I am designing an Access 2007 database that will, among other things, track attendance. In the future I will need to be able to run reports listing things like who hasn’t been to the last 5 meetings. Right now I need to be able to create a query to tell me who has attended less than 3 meetings.

At the moment the data is organized in two forms. The Attendance form contains the following fields: attID, attDate, attPerson, and others not related to this problem. The attPerson field relates to the primary key in my Person table, which includes, among unrelated data: personID, personNameLast, personNameFirst.

How do I create a query (preferably without using SQL) to count the number of meetings any person has been to? Can it be done with this set up? If not, how should I destine my database to allow me to do this?

Thank you for your help.

The easiest way (imho) is to do this via SQL:
SELECT attPerson, COUNT(*) AS Meetings
FROM Attendance
GROUP BY attPerson;

You should be able to build this via the query designer interface by doing the following:
Field 1 – Field: attPerson; Table: Attendance; Total: Group By
Field 2 – Field: Meetings:Count(*); Table <blank>; Total: Expression

Hope this helps!

i want the second combo box to pick a default category when an item is selected in the first combo box. thanx in advance.

The article at the site bellow explains you how to do it

http://support.microsoft.com/kb/289670

Let’s say if I have 10 records but would only want to email the 8th record report, what should I do?

make a query to get the relevant record say for example :

SELECT * FROM urTable WHERE LastName =’" & "Arthur ‘"

If you have Unique Id u can use

SELECT * FROM urTable WHERE emplId=" & 8

Note the enclosed before ‘" and ‘" for string expresson for numeric no need as you will see in second example.

When you are in Print preview send it by mail.

download the latest version of IM.

I am creating my query from a microsoft access table I already have, however, I cannot figure out what the commands are that make my Query make an average, lowest rate, and highest rate, while i am in design view.

put the following into sql view, run the query and it automatically will switch you into design view there after:
select avg(fld) as Average, min(fld) as [Lowest Rate], max(fld) as [Highest Rate] from tbl;

Your best bet is to create the checklist in a table, ad then generate a form based on that table. This will give you all the controls.

Rearrange the controls into groups, and use the shape control to group them. You can then add labels to this with the label control.

I used to have Windows XP, and my job had a link where I could click and access my work hard drive from my home computer. However, when I got the new laptop with the Vista system, and I downloaded the link from my employer, I couldn’t access the files. Is there a way of working around the features of Vista?

You need to speak to your admin people at work. Have you tried LogMeIn? Go to www.logmein.com.

Can anyone explain *as simply as possible* how to delete records with their related records in Access database to ensure the consistency of the database is maintained.
But, I mean I need a way that will be fool proof and definitely delete the record with all related records to it.

Any help? Thanks.

If you have correct relationships linking primary keys to foreign keys, open any relationship between two tables containing related records, and then tick the box titled "cascade delete related records". With this option selected, every time that you delete a parent record, all related records will be deleted as well, regardless of how you perform the delete.

A word of caution though. You do not always want to delete related records. A text book example would be employees and projects. Just because an employee no longer exists, if you delete that employee from the system, you would (probably) not want to delete all the projects they were working on with them.

Dear Friend

I have two tables in Microsoft Access. Two tables has got common field named as “item“. One has field purchaseqty & another has field supplyqty and numeric data is there. Can I subtract row wise data from two tables and store it to another table which has got field item & qty?

Please help.

Regards
Pervez

It is never recommended to store dynamic information in a database. By that I mean if any of your purchaseqty in table 1 changes, or supplyqty in table 2 changed then your value stored in table 3 would be incorrect…

It is better, instead of storing calculated data, to make the necessary calculations only when you need to display it to the end user. Whether that be on a form, a report, or in a data access page.

Control Source for the calculated data would be:

=[table 1].[purchaseqty] – [table 2].[supplyqty]

OR

=[table 2].[supplyqty] – [table 1].[purchaseqty]

Whichever is suitable for your calculation.

I made a software insist of a database system software using Ms Access 2003. It includes forms, tables, Sql queries and VBA codes for retrieve, insert, deletes and maintains the tables, including its relationships. Now I want to know what is the exact cost to this product or what is the exact rate that my customer should pay?

http://databases.about.com/od/access/l/aaaccess1.htm
http://search.techrepublic.com.com/search/database+system+and+microsoft+access.html?&c=1&s=0&m=20&o=0&i=0&t=0
http://technet.microsoft.com/
http://office.microsoft.com/products