Recent content by rythem

  1. R

    Display on Reports

    I have 2 tables with the same kind of data. The transaction table is for employees who manually enter data and the second is for employees who will use a scanner. I want to be able to show the information (as it is) from both the tables on the report. Will i need to make a query or can i do...
  2. R

    System Date and Time

    that works thanks a lot
  3. R

    System Date and Time

    Hello, I have a form that displays the system date and time for every entry. When the data gets stored in the table, the date and time do not get stored. How can i save the date and time with all the other information. Also, everyday when i open the form, it shows me all the data from the...
  4. R

    result of a query in another query

    results hi, The query works for the most recent date. All i need more now is to do it for every product ID and now it works fine. Thanks a lot, you have been a great help
  5. R

    result of a query in another query

    Date with product ID Hi, I did try doing this the output gives me the records for the date that fall under the condition. I want to do it for each product id. In my report, i need the most recent date transaction FOR each Product ID. Hope you can tell me how do i do this Thanks !!!
  6. R

    distinct entries

    Report Display Hi, well that just hides all my records. I just want to diplay the most recent one. The report must show the latest transaction (the one thats from the latest date). Thanks
  7. R

    result of a query in another query

    Query Result Hi, Thanks a lot for the help. These queries gives me the exact result that i wanted. They also give me individual entries for each transaction like multiple "Issues" and multiple "Receipts". so when i use this query to display the report, it gives me multiple values of the...
  8. R

    distinct entries

    I have a table where i enter all my transactions and then use a query to differentiate and calculate the final result. the query alculates for each transaction and gives me the final result but with an entry for each transaction. each of these calculated by my query is shown in the report. i...
  9. R

    result of a query in another query

    Question for the query Hello, Thankyou so much, thats what i exactly wanted. In the query called Query1, where did the table a coem from. I cannot figure that out. Please let me know thanks
  10. R

    Query gives me way too many entries

    Query Thankyou so much for all the help. There is another concern that arises here then, My inventory shows a certain amount right now. Every time i run this query, it will take that amount as my initial quantity. after every transacton that changes. How do i get the query to do that cuz i...
  11. R

    Query gives me way too many entries

    Hello, I was writing a query in order to subtract all the requisitions from my invnetory. I have a query to add all the requisitions. Then i use that sum and subtract it from the total inventory. (the query below is the second one) I may have many requisitions for the same product in one...
  12. R

    Search in reports

    Report Hello, this works thankyou so much.
  13. R

    Search in reports

    date Should it be unbound? I will need to write a code for it to check and display the reprot for that date? how do i do this. I hope i am getting it right. thanks
  14. R

    Search in reports

    When i get a report, it has pages full of information. I want to be able to display a selective report based on the date. Is there any way that i can enter the date and the report shows me information based on that date alone. Thanks
  15. R

    help with updating the records

    Query So do u think that i should just have one table and enter +ve and _ve values in it. Then sum it up to display on the report. Sory about that, but my structure is something like this. I have an inventory table where i enter any item that comes in specially that does not exist in the...
Back
Top Bottom