Search results

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...

that works thanks a lot

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...

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

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 !!!

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

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...

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...

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

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...

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...

Report Hello, this works thankyou so much.

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

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

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...

I have the following query: SELECT Inventory.[Product Number], Inventory.[Make/Model], Inventory.[Stock Quantity], Requisition.Quantity, [Update Inventory].[New Quantity], [Check Stock].[Avaliable Quantity], [Check Stock]![Avaliable Quantity]+[Update Inventory]![New Quantity] AS [Net Quantity]...

I have trouble adding pictures to my forms. On the form when I add a picture, it just shows me the link and when I double click on it, it displays the .gif file. ( I did define it as an OLE object in the table) I am not sure if there is something specific I need to do in order to display the...

This is what i am trying below is something that i am trying to do. I am not too sure if thats the best way or if there is a better or a simpler way to do it. I have an inventory table with the fields such as stock quantity, threshold quantity. I have the requisition table with the fields...

display results in report i am trying to use th result of a query in another and display the results in the report. i have a check stock report that uses a query that subtracts the inventory input and the requisitioned quantity. in this report i want to be able to use that result and...

can i use the result of one query to calculate something in another query