Index

[James B.]

OK. Here is my problem, I have a report thats printing out AC unit inspection
sheets. The report is grouped by area then location and within each location
its grouped by ID numbers for the equipment. I have all that working great.
My problem is the client is making me file the reports by id numbers with in
an area. So my idea is to some how create a table at time of report
generation the table is sorted by id numbers and has two fields IDnumber and
index, I can then read in the index number and print it on my report , the
admin can then use that number to order everthing. Does this sound like it
would work. PS! everthing I have done in access so far as been from examples
from this site. I have only been using it now for 3 weeks.

 

[John Griffiths]

OK. Here is my problem, I have a report thats printing out AC unit inspection

The report is grouped by area then location and within each location
its grouped by ID numbers for the equipment.

Sounds like :-
ORDER BY tblName.Area_ID, tblName.Location_ID, tblName.Equipment_ID

but something like :-
ORDER BY tblName.AreaName, tblName.LocationName, tblName.EquipmentName
:- would be less user hostile.

I have all that working great.

My problem is the client is making me file the reports by id numbers with in
an area.

Isn't that just another report based on your current one?
ORDER BY tblName.Area, tblName.Equipment_ID

Without any breaks for location although not sure what "file the reports"
means.

Help needed here - John

 

[James B. via AccessMonster.com]

The army makes us hard copy file all forms in ID number order, thats why I
was trying to make some kind of index of the filing order and print it on the
form. Which would make filing easier. I can have as much as 1000 pages to
file in one day.

OK. Here is my problem, I have a report thats printing out AC unit inspection
sheets.

The report is grouped by area then location and within each location
its grouped by ID numbers for the equipment.

Sounds like :-
ORDER BY tblName.Area_ID, tblName.Location_ID, tblName.Equipment_ID

but something like :-
ORDER BY tblName.AreaName, tblName.LocationName, tblName.EquipmentName
:- would be less user hostile.

I have all that working great.

My problem is the client is making me file the reports by id numbers with in
an area.

Isn't that just another report based on your current one?
ORDER BY tblName.Area, tblName.Equipment_ID

Without any breaks for location although not sure what "file the reports"
means.

Help needed here - John

So my idea is to some how create a table at time of report
generation the table is sorted by id numbers and has two fields IDnumber and

[quoted text clipped - 5 lines]

from this site.
I have only been using it now for 3 weeks.

 

[John Griffiths]

The solution is in the tables used in your SQL, whether they are based on an
identifying primary key or not.

If you have a table to record each inspection an autonumber PK will suffice.
I assume that each equipment record stores
(last inspection id, last inpection date, next inspection due date, ...)
to generate new inspection records to act as a list of todo items.

NE Help - John

The army makes us hard copy file all forms in ID number order, thats why I
was trying to make some kind of index of the filing order and print it on the
form. Which would make filing easier. I can have as much as 1000 pages to
file in one day.

OK. Here is my problem, I have a report thats printing out AC unit inspection
sheets.

The report is grouped by area then location and within each location
its grouped by ID numbers for the equipment.

Sounds like :-
ORDER BY tblName.Area_ID, tblName.Location_ID, tblName.Equipment_ID

but something like :-
ORDER BY tblName.AreaName, tblName.LocationName, tblName.EquipmentName
:- would be less user hostile.

I have all that working great.

My problem is the client is making me file the reports by id numbers with in
an area.

Isn't that just another report based on your current one?
ORDER BY tblName.Area, tblName.Equipment_ID

Without any breaks for location although not sure what "file the reports"
means.

Help needed here - John

So my idea is to some how create a table at time of report
generation the table is sorted by id numbers and has two fields

IDnumber and
[quoted text clipped - 5 lines]

from this site.
I have only been using it now for 3 weeks.