Physical Inventory Form - re-request

Physical Inventory Form - re-request

Post by Lou » Sat, 17 Jan 2004 01:48:15


I am trying to build a form that will show each [type] of
coupon with a total amount of that type and the beginning
number and ending number.

Table name is "Master Table"
Fields are as follows;
[Log Number] - Auto number
[Type] - Type of coupon, text field
[Coupon number], number field
[Issued] - has it been issued, number field
[Issued date], date field

The query I have built "qryAudit" draws of the "Master
Table" from the following fields, [issued], [type] &
[coupon number]. Criteria in the [issued] field are set
for 0 identifying only coupons that have not been issued.

I have a report built that gives me inventory sheets with
this information currently, I want to be able to go take
an inventory with my report then open a form which looks
almost identical to the report where I can enter my
physical inventory count of each coupon. Then I want to
formulate a text box to take the system reported total for
that coupon and calculate the variance against the
physical inventory.

I hope this makes sense.

Lou
 
 
 

1. Physical inventory by inventory dimension report

2. Missing physical inventory data in on hand inventory report

Most of the informations are shown in on hand inventory report, but "Physical
inventory" is missing. This is one of the important figure should be achieved
from this report and should not be missed.

Thanks,
Thomas Chan


----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.yqcomputer.com/

3. Physical Inventory or Inventory Value By Dimension Report

4. Re-request: valuesfolder with listbox

5. re-request for PoP up authentication fix

6. Re-request for Info: Rule

7. Why does IP re-request ASPX page?

8. OT - Re-Request Info on Free firewall - anti-virus apps?

9. Important Feature Re-Request: Array indexing on any data type.

10. NTBACKUP vs RSM Mount, Dismount, Eject, Re-Request Same Tape

11. How do I re-request a read receipt to a contact once refused?

12. physical hd size.. Inventory needed

13. Physical remaining quantity in the inventory unit 'XXX' must be other than zero

14. Updating inventory model group to include physical value

15. physical inventory sampling