horizontal filter

[AND]

Hi,
I've a sheet, named "TUTTE", by 70 text fields.
the first fields are name, surname, age, city, etc....the last 54 are week1,
week2, week3, etc....
So I created "form1" where I created 2 combo boxes("WK1" and "WK2") + Button1

Here I need to selece by comboboxes from......to weeks... to get a form that
shows the first 16 fields from sheet "tutte" and only the weeks/columns
selected by combo box.

please can u help me? I'm getting me crazy.

Thanks a lot to everyone can help me!

 

[Jeff Boyce]

Stop! You've just described a spreadsheet, in which you add another column
for the next "week".

Access is a relational database ... while you can use 'sheet data in Access,
both you and Access are going to have to work MUCH harder than you need to.

If you aren't familiar with "normalization" and "relational database" as
terms, plan on working your way up the learning curve before proceeding. Or
plan to put the data in a spreadsheet and work with it there!

Good luck

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[AND]

Hi Jeff, thanks for your support.
Yes It's a spreadsheet
yes, I know the normalization or relational database terms, and i'm working
by access since about 1 year.
I think it has to be a method there.
But I was thinking access is a right tool to manage this issue.
therefore can u reccomend me a tools different from access to solve the
question?

thanks a lot for ur support

 

[Jeff Boyce]

You need not leave the data in the format you received it.

If you want to use the features of Access, like the comboboxes, consider
figuring out how to convert the data from the spreadsheet you start with to
something Access knows how to use.

Otherwise, I'm not familiar with tools that would do what you're describing
on a spreadsheet... (but maybe other newsgroup readers have found a
solution!).

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[John W. Vinson]

You need not leave the data in the format you received it.

If you want to use the features of Access, like the comboboxes, consider
figuring out how to convert the data from the spreadsheet you start with to
something Access knows how to use.

Otherwise, I'm not familiar with tools that would do what you're describing
on a spreadsheet... (but maybe other newsgroup readers have found a
solution!).

Regards

Jeff Boyce
Microsoft Office/Access MVP

You can massage the data into a normalized tall-thin structure for searching
using a Normalizing Union Query:

SELECT primarykey, Week1 FROM yourtable
WHERE Week1 = Forms!YourForm!comboboxname
UNION ALL
SELECT primarykey, Week2 FROM yourtable
WHERE Week2 = Forms!YourForm!comboboxname
<etc for all 52 weeks... don't some years have 53 or 54?>

This will filter the records to match your search criterion, and you can join
this table to your original table to pick up the rest of the data.

 

[AND]

thanks a lot Jhon.

But when I'm going to play the query it asks me the primarykey.. what's
value is it?
I think I have to change primary key to an other value.. but what value I
have to fill in?
thanks for your precious help

 

[John W. Vinson]

thanks a lot Jhon.

But when I'm going to play the query it asks me the primarykey.. what's
value is it?
I think I have to change primary key to an other value.. but what value I
have to fill in?
thanks for your precious help

Does your table HAVE a primary key?

If not, replace primarykey by some fieldname, or several fieldnames, that
uniquely identify a record.

if there is no such field or combination of fields you're out of luck. If
there might be several records in your table all with the same data (except
for the week1-week52 fields) how can Access, or you for that matter, tell
which is which?

 

[AND]

ah ok..thanks.
unfortunately the data are too much long for accesswhether I want fill in
the data in a unique query.
But thanks a lot for yiour help.
u've solved my trouble. I'm going to sign in my rate for this discussion.
thanks again