Query sorting

[Kim Jackson]

Hi All,
I am designing a database for tracking projects and I
have different forms for each projects. I am using
quiers to sort data in my [MasterData] table by project
for each form. Is there a way to create one query or
another way that will sort by project?
Thanks in advance

 

[Jeff Boyce]

Kim

I'm not sure I understand. Why (i.e., what business need are you solving)
are you using "different forms for each project..."? If your situation,
tracking projects, is like many, you would only need one form to display
multiple projects.

Please describe your data structure, as this will drive any queries you
would write.

Jeff Boyce
<Access MVP>

 

[Kim]

Jeff,
All my information is located in as [MasterData table],
65% of the information is the same on each form the other
35% is unique to each project. There are some fields
that some end users did not want on their forms and some
information is sensitive and financial and only needs to
been seen by certain departments, so the only way I knew
of was to build separate forms and grant access at form
level. There is a main form that has all information
that myself and another project mangers accesses. If you
have any suggestions on anything that will make this
easier please let know as this has been a nightmare for
me.
Thanks Kim.

 

[Jeff Boyce]

Kim

You are describing using forms to present different views of the data. And
you use different views for "permissions". You said "all my information is
located in as(?) [MasterData table]". I'm not sure I understand.

Are you saying that you only have one table in your database? If so, you're
not getting much of the benefit of using Access, a relational database.

If "65% of the info is the same" for all projects (notice I didn't use
"form"), and the rest is unique to each project, are you saying that there
are different fields needed for each project's unique data, or that each
project needs a separate record (row) for its unique values of the same data
that all projects have.

For example, in my world, all project have, sooner or later, a project
manager. This "fact"/field (project manager) is common across all projects,
but each project contains an indication of just who the project manager is.
In my world, the same person can manage more than one project, so I'd have
to allow for the same person to show up in the "ProjectManager" field of
more than one row (i.e., more than one project).

Or have I totally misunderstood?

Good luck

Jeff Boyce
<Access MVP>

 

[kim]

Jeff,
I am sorry that I have not been clear so, please bear
with me as I try explain.
We are currently using spreadsheets to keep track of what
stage of completion a project is in and to generate
revenue numbers. The main purpose of is database is to
control changes of the data and to generate numbers for
our reports but most of all to keep people from one
department assuming that something is done and changing
the data, when it has not been completed.
I made a mistake when saying the 65% was the same data,
they are the same fields with different data the other
35% are unique to the type of project it is.
I understand what you are saying about the project
manager having different projects, in my case myself and
another project manager are doing clean up we are making
sure that the project steps are being completed so that
we can find lost revenue.
I sure hope that is explanation help.
Kim

 

[Jeff Boyce]

Kim

I'll return to your original question, about sorting by project.

If your master table has a field that contains some kind of "project"
identifier, you can use that field to sort.

You may already have this, so what, in addition to sorting, do you want your
query to do?

Jeff Boyce
<Access MVP>