Results 1 to 4 of 4
  1. #1
    nkuebelbeck is offline Advanced Beginner
    Windows 7 Access 2007
    Join Date
    Mar 2010
    Posts
    91

    for each record in detail section

    I've got a transactions tables. With data that look like this



    id order_number date, qty, uom, item_number
    '1', '1', '2013-05-16', '1', 'bottle', '4'
    '2', '1', '2013-05-16', '1', 'can', '5'
    '3', '2', '2013-05-20', '-2', 'oz', '4'
    '4', '2', '2013-05-20', '-6', 'oz', '5'
    '5', '3', '2013-05-20', '1', 'can', '7'

    I want the report to display inventory, I have it grouped by item_number

    in the detail section I have the transactions

    in the footer I have a running total for qty.

    I want the transactions to convert to all the same uom(The item_number 's) UOM stored in another table.

    how do I access the data in the detail section before it's displayed so that I can do a lookup to see if it's in the correct uom and convert it and display it in the correct qty before it displays?(I would not store the conversion) I'm assuming this would be done via VBA but i really don't know....

  2. #2
    rzw0wr is offline I will always be a newbie
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2013
    Location
    Indiana
    Posts
    479
    You may want to look at Totals query.


    Dale

  3. #3
    nkuebelbeck is offline Advanced Beginner
    Windows 7 Access 2007
    Join Date
    Mar 2010
    Posts
    91
    Quote Originally Posted by rzw0wr View Post
    You may want to look at Totals query.


    Dale
    I'm not sure I follow. I've got a running total in my footer, it's just that the qty is incorrect because it needs to go through UOM conversion. My other thought would be to change the way the record is entered into the table....

  4. #4
    nkuebelbeck is offline Advanced Beginner
    Windows 7 Access 2007
    Join Date
    Mar 2010
    Posts
    91
    for giggles I tried this on the format event...

    I don't get anything in the textbox. It's just blank.

    Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
    If quantity.Value > 0 Then
    Text38.Value = "1"
    Else
    Text38.Value = "2"
    End Sub

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Columns in Report Detail Section only
    By gg80 in forum Reports
    Replies: 10
    Last Post: 08-03-2014, 07:41 PM
  2. height of Detail section in reports
    By Nicola in forum Reports
    Replies: 4
    Last Post: 05-31-2013, 02:46 AM
  3. Replies: 6
    Last Post: 03-26-2013, 12:17 PM
  4. Replies: 3
    Last Post: 01-19-2013, 01:37 PM
  5. Detail Section Keeps Repeating values
    By progamer in forum Reports
    Replies: 6
    Last Post: 07-30-2012, 10:28 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums