Question A simple query about...erm...queries

[Burnsie]

Right.

I’m building a database after not really using them since school (2001). What I’m wanting to do store Personal information (age, DOB, sex, name etc) and track weight-loss details (Height, weight, BMI etc).

Therefore, I have 2 tables
1-Personal details
2-Testing details

The tables are linked with a one-to-many relationship through a unique participant ID field.

I also have one form linked to these tables. The main form with personal details in it and a sub-form with test data in a table format. Each row/record in the sub-form relates to one test date, therefore allowing me to enter data from repeated tests.

I’ve now moved onto queries and reports.

If I create a query, say I put in the ID and name from the “personal details table” and the test data from the “test” table (in date, height, weight, BMI etc) will this data produced by the query automatically update as i add more participants or test results?

Secondly, how do i create a query/report that is date specific? I.e. how do I find the participants who did the tests between certain dates?

Any help/pointing the right direction would be most welcomed.

Many thanks

B

 

[spoole]

Hi Burnsie,

Yes the query will pick up the new data in the tables.

As for the date range query have a look at this

http://office.microsoft.com/trainin...ID=RP010970001033&CTT=6&Origin=RP010969981033

And another note when creating reports I find it easier to make a select query first with the report data I want then base my report on that query.

 

[bulrush]

In your query, in a date type field, in the criteria area, dates have this format:
Get dates between Jan 1, 2009 and Mar 4, 2009 inclusive:
>=#1/1/2009# and <=#3/4/2009#

This is assuming your OS date format is for America. Dates are formatted, and handled, differently in Europe where their format is dd/mm/yyyy.