Search results for query: *

Hi there everyone! I am just curious to know if there is any way to speed up queries. I currently have one that is taking a few minutes rather than seconds to complete. It is an append query that appends another table in the database. Any suggestions? All tables are indexed. Thanks for...

Thanks a ton Rick! I really appreciate the help. It works great! I totally forgot about the IN operator! DUH! Thanks again. MK

Rick, Thanks for your input! Below is the sql for the queries. SELECT Receive.[PO Number], Receive.[Part Number], Sum(Receive.[Quantity Reveived]) AS [SumOfQuantity Reveived], [PO Detail].[Quantity Ordered], [PO Detail].RIF, [Purchase Orders].RIF FROM [Purchase Orders] INNER JOIN (Receive...

Currently, I have a database that tracks the inventory of parts. This includes the receipt of parts that were ordered via a purchase order. I have a Purchase Order table, Receipt table, and a PO Detail table. For each part ordered on the po, there can be multiple receipts, this covers parts...

YOU ASSUMED CORRECT. THE LESS VISIBLE THE BETTER! THANKS A MILLION JERRY! I WILL TRY THIS. I REALLY APPRECIATE THE GOOD INFO!

I have a form with chkboxes for each field of the table to be queried as well as common operators (=, <, >, ect...) and then a txtbox where the user can enter what they want to query for. I can extract all of the info from the form but i am not sure how to go about making the query. I know that...

I am working on a database in which I need to exclude a column or columns of a report(they come from a table) based on which report choice the user chooses from the switchboard. Any suggestions? Thanks a bunch.