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

P

Pandora

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
 
N

Nikos Yannacopoulos

Pandora,

It sounds like what you need is a report, not a form! Check out that option.

HTH,
Nikos
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to get data in a form from different records out of a query ? 2
SUM in a UNION query 2
Running a query when you change a form 7
Combine Duplicates in Query 0
result query on a form 1
Fixed Values in a Query 5
How do I get just the weekday out of a long date 3
Create flexible Query - One instead of dozens 6

Top