Versions Compared

Version Old Version 7 New Version 8
Changes made by

Former user

Former user

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
{composition-setup} {column:width=60%} # Sort out the stacks by status. _
Wiki Markup
Section
Column
width60%
  1. Sort out the stacks by status. i.e.
  1. Now
  1. in
  1. library,
  1. already
  1. in
  1. library,
  1. etc.
_ #
  2. Access
  1. the
  1. I
  1. Drive.
  1. Go
  1. to
  1. the
  1. Orders
  1. folder
  1. and
  1. look
  1. for
  1. the
  1. bookRequest2new
  1. Microsoft
  1. Access
  1. file.
  1. Open
  1. it.
{color:#000000}{*}
  1. Note:
  1. Make
  1. sure
  1. you
  1. are
  1. using
  1. the
  1. right
  1. file
  1. and
  1. not
  1. the
  1. older
  1. versions.
*{color} # Once
  2. Once loaded.
  1. go
  1. to
  1. queries.
  1. Open
  1. up
  1. the
  1. CheckingOrderStatus
  1. query
  1. in
  1. design
  1. view.
*
  1. Right
  1. click
  1. to
  1. choose
  1. design
  1. view.
* #
  2. Scroll
  1. over
  1. to
  1. the
  1. ID
  1. column
  1. on
  1. the
  1. form.
  1. Enter
  1. the
  1. number
  1. that
  1. corresponds
  1. with
  1. the
  1. status.
_
  1. i.e.
  1. 52
  1. =
  1. now
  1. in
  1. library.
_
  1. Refer
  1. to
  1. the
  1. chart
  1. if
  1. needed.
#
  2. Under
  1. the
  1. disposition
  1. column,
  1. enter
  1. the
  1. date
  1. and
  1. times
  1. noted
  1. on
  1. the
  1. stack.
 It
  1.  It may
  1. be
helpful to go a few minutes under or over the time noted, to make sure that all entries are reported back. *Make sure that you check for A.M or P.M, else you won't get the right results.* # Close the query and click yes to save it. # Go to reports. # Open up the CheckingOrderStatusImproved report. # Once loaded, check the titles on the report against the orders to make sure that all orders are in the report. *Note: Make sure to double check call numbers or vendor notes if noted on the PO or report.* If you cannot find an order in the report, let Jen know.. # Once done with all orders, you may close the report. # Repeat for all other stacks. # Close out Web Order System when you are done. # Put the stacks on Michelle's desk when done. {column} {column:width=40%} \\ || ID \\ || Text \\ || | 50 | No Status \\ | | 51 | Approved, Now on Order \\ | | 52 | Approved, Ordered, and Now in Library \\ | | 53 | Approved, Order Delayed \\ | | 54 | Rejected--Already In Library \\ | | 55 | Rejected--Already on Order \\ | | 56 | Rejected--Misc. | | 57 \\ | Out of Money--Approved but Delayed \\ | \\ {column}
  1. helpful to go a few minutes under or over the time noted, to make sure that all entries are reported back. Make sure that you check for A.M or P.M, else you won't get the right results.
  2. Close the query and click yes to save it.
  3. Go to reports.
  4. Open up the CheckingOrderStatusImproved report.
  5. Once loaded, check the titles on the report against the orders to make sure that all orders are in the report. Note: Make sure to double check call numbers or vendor notes if noted on the PO or report. If you cannot find an order in the report, let Jen know..
  6. Once done with all orders, you may close the report.
  7. Repeat for all other stacks.
  8. Close out Web Order System when you are done.
  9. Put the stacks on Michelle's desk when done.
Column
width40%


ID

Text

50

No Status

51

Approved, Now on Order

52

Approved, Ordered, and Now in Library

53

Approved, Order Delayed

54

Rejected--Already In Library

55

Rejected--Already on Order

56

Rejected--Misc.

57

Out of Money--Approved but Delayed