Form based query/Filter

[Micon]

I am trying to create customized reports based on a 24 field access table.
The reports need dynamically selected columns and need to be filtered and
sorted on the fly. The users of this form (or whatever) are computer novices
so I need to design this to be simple to use. I have been planning to use
access to do this but at this point I am open to suggestions.

I am in way over my head and desperately need help.

 

[KARL DEWEY]

The reports need dynamically selected columns and need to be filtered and
sorted on the fly.
You did not say what the fields contained but it sounds like you might be
using a spreadsheet approach have a field per month or some such. If that is
what you have then you need to change the database to have a field for data
and another identifying the date or whatever divisions you have your 24
fields.

If the above is not the case then you can use a form with unbound object to
select the fields and use a union query to pull it together.

Post your table structure with field names and datatype. Post sample data.

 

[Micon]

Most of the fields contain string data except for one with a date of birth
and one with a year.

Bio: Grantee ID
Bio: Prefix
Bio: First Name
Bio: Middle Name
Bio: Last Name
Bio: Suffix
Bio: Date Of Birth
Bio: Gender
Bio: Country Of Birth
Bio: City Of Birth
Bio: Country Of Citizenship
Bio: Country Of Residence
Program: Initial Fiscal Year
Program: Program Name
Program: Country Of Nomination
Program: World Region
University: University Name
University: Affiliate Name
University: City
University: State Name
Academic: Degree Objective
Academic: Field of Study
Academic: Field Sub-Category

Bio: Grantee ID Bio: Prefix Bio: First Name Bio: Middle Name Bio: Last Name
Bio: Suffix Bio: Date Of Birth Bio: Gender Bio: Country Of Birth Bio: City Of
Birth Bio: Country Of Citizenship Bio: Country Of Residence Program: Initial
Fiscal Year Program: Program Name Program: Country Of Nomination Program:
World Region University: University Name University: Affiliate Name
University: City University: State Name Academic: Degree Objective Academic:
Field of Study Academic: Field Sub-Category
1003 Ms. Chantale Quinn Fuentes 2/17/1986 Female Reunion Ames Rwanda Aruba
2009 In condimentum. Donec Liberia Africa University of California, Irvine
Fuentes Irvine CA Master's Degree Foreign Languages Education
1034 Ms. Kibo Destiny James 9/26/1986 Female Myanmar Dover Czech Republic
Mali 2009 ornare egestas ligula. Guam Central America University of Michigan
James Ann Arbor MI Master's Degree Spanish Comparative and Interdisciplinary
Arts

I am not sure how to post the sample data so I only posted a couple of lines.
Thanks.

sorted on the fly.
You did not say what the fields contained but it sounds like you might be
using a spreadsheet approach have a field per month or some such. If that is
what you have then you need to change the database to have a field for data
and another identifying the date or whatever divisions you have your 24
fields.

If the above is not the case then you can use a form with unbound object to
select the fields and use a union query to pull it together.

Post your table structure with field names and datatype. Post sample data.

I am trying to create customized reports based on a 24 field access table.
The reports need dynamically selected columns and need to be filtered and

[quoted text clipped - 3 lines]

I am in way over my head and desperately need help.

 

[KARL DEWEY]

You should have one-to-many relationships between the following tables --
Employee - Program
Employee - University - Degree

Employee - your Bio fields
Program - your Program fields
University - University
Degree - Academic

I do not see how you can do the 'dynamically selected columns and need to be
filtered and sorted on the fly.'

Maybe someone else can based on the information you provided.

 

[Micon]

All of the fields are in one table and the data is retrieved from an external
source. The user would like to select the sort and filter fields and which
fields will be output to a report and then optionally output to an XLS/CSV
file as well.

Does that make sense?

 

[KARL DEWEY]

I know what you are asking but I do not know how it is possible.

 

[Micon]

I feel a little better. Cause I have been bashing my head trying to figure
it out.

I know what you are asking but I do not know how it is possible.

All of the fields are in one table and the data is retrieved from an external
source. The user would like to select the sort and filter fields and which

[quoted text clipped - 16 lines]

 

[KARL DEWEY]

I certianly am no expert. As I said maybe someone else can based on the
information you provided.

--
KARL DEWEY
Build a little - Test a little

I feel a little better. Cause I have been bashing my head trying to figure
it out.

I know what you are asking but I do not know how it is possible.

All of the fields are in one table and the data is retrieved from an external
source. The user would like to select the sort and filter fields and which

[quoted text clipped - 16 lines]

Maybe someone else can based on the information you provided.