How to get data in a form from different records out of a query ?

[Choemmy]

Hello,

I'm making a database of data on a daily base !

Now I want to make a form with an overvieuw of one week. I count in every
record by day the week that the day is in so now I can search for all the
data of a week by using a query.

Now I want to collect this data in a form so I can get an overvieuw of one
week and so I can count the average and total of that week.

I can only link a text box to the first colom of the query and than scroll
into the query, but I want to have all the data on the same form without
scrolling.

I don't know how to refer to a data in an other record !

Greetings

 

[John Vinson]

Hello,

I'm making a database of data on a daily base !

Now I want to make a form with an overvieuw of one week. I count in every
record by day the week that the day is in so now I can search for all the
data of a week by using a query.

Now I want to collect this data in a form so I can get an overvieuw of one
week and so I can count the average and total of that week.

I can only link a text box to the first colom of the query and than scroll
into the query, but I want to have all the data on the same form without
scrolling.

I don't know how to refer to a data in an other record !

I'm sorry, I really don't understand what you want.

What is the structure of your tables? What do you mean by "link a text
box... and then scroll"? Can you create a Totals query and base a form
on that query?

 

[John Vinson]

I try to be more clear this time and put in an illustration

Well, binary attachments are *not* well received here... as a rule you
shouldn't post them.

In this form I putted several textboxes.

In the first row I put the dates of that week. Then I like to put some other
information of that date in the column under it. All this information is
situated in one table and I run a query on the week that the date is in.So
based on the form I get a Query of maximum 7 records (max 7 days) but now I
want the information of all this query's in this form. With scrolling I
meant that I can have this information if I scroll into the (max 7) records,
but then I don't get them in the same form (one page !)

I hope you will understand it better now !

You'll need to either create a Crosstab query which will display (but
not allow you to edit) the data in a "crossways" format like this, or
use an unbound Form and write VBA code to pull data out of each record
in the table and display it in a control on the Form. I'd say the
Crosstab will be simpler; you don't need multiple queries, you only
need one. See Crosstab in the online help.