Dynamic Report From One Table . .

[Evagrius]

Hello all,

I would be grateful if anyone can guide me on this. I have one table I also have a report based on that table.

What I would like to do now is have a from with a multiselect list box that contains all the fields in my table. Then A user would choose multiple selections from the list box, and a report would be created with just those fields.

I know this is possible, but I need guidance on how to begin. Thank you for any help!

 

[vbaInet]

Just before we propose a solution can I just understand something. When you say you have one table does that mean you have just one table in your database or just for that report?

 

[Evagrius]

Hi vbaInet - sorry for the delay in response. I have only one table in the entire Database. The existing report references that one table. Thank you!

 

[vbaInet]

Oh dear! Sounds like you have a normalisation problem. How many fields do you have as well?

 

[Evagrius]

I have 14 fields including one AutoNumber as Primary Key . .

 

[Evagrius]

vbaInet - I have a question. I am still learning so please forgive my manifest ignorance. Is a database necessarily NOT normalized if there is only one table? In other words, can a database be normalized and have only one table? Thank you!

 

[vbaInet]

Is this just a basic database and are you familiar with normalisation?

In any case, in the following link, look through the list and you will find an example of what you're trying to do:

http://www.btabdevelopment.com/ts/samples

It's called Open Generic Report with Various Criteria

 

[vbaInet]

vbaInet - I have a question. I am still learning so please forgive my manifest ignorance. Is a database necessarily NOT normalized if there is only one table? In other words, can a database be normalized and have only one table? Thank you!

Not necessarily but I would imagine that you've followed the spreadsheet way of a database (i.e. a flat file) and it may well be lacking normalisation. In most cases it holds.

 

[Evagrius]

Thank You vbaInet!!

 

[vbaInet]

You're welcome.

In case you want to read about normalisation:

http://r937.com/relational.html
http://support.microsoft.com/kb/209534