database development in london - How does sub-documents work?

Resolved · Low Priority · Version Standard

Mon 6 Aug 2007, 10:41 Delegate Jonathan said...

Jonathan has attended:
Access Introduction course
Access Intermediate course
Access Advanced course

How does sub-documents work?

Tue 7 Aug 2007, 10:51 Trainer Richard said...

RE: How does sub-documents work?

A Subdocument is an embedded data set. So you have your primary data, for example a list of clients. Your subdata set could be a table or query containing anything relating to these cleints, perhaps purchases. So when you link the subdata to the primary data you can view the related recoards more easily.

An example might be a subform. Here your main form contains the client data fields and the subform contains the sales. As you scroll through the cleints records, the subdata will change according to the current client record.

Does that cleirfy it for you?
Regards

Richard

Access tip:

Calculating The Difference Between Dates

If you wish to calculate the time between two date fields, this can be done in a number of ways:

1. As a calculated field in a query
2. As a calculated control in a form or report
3. As a calculation in a VBA procedure.

The basic syntax to get the number of days between two dates is:

=[One Date Field] - [Another Date Field]

You can also use one of the following functions:

=Month([One Date Field] - [Another Date Field])
which calculates the number of months between the two fields

=Year([One Date Field] - [Another Date Field])
which calculates the number of years between the two fields.

Another function is the DateDiff() function.

It uses an argument to determine how the time interval is measured. For example:

=DateDiff("q",[One Date Field] - [Another Date Field])
returns the number of quarters between the two fields.

Other intervals that can be used in this expression are as follows:
"yyyy" - Years
"m" - Months
"d" - Days
"w" - Weekdays
"ww" - Weeks
"h" - Hours
"n" - Minutes
"s" - Seconds

View all Access hints and tips

database development in london - How does sub-documents work?

How does sub-documents work?

RE: How does sub-documents work?

Access articles

Access tip:

Calculating The Difference Between Dates