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...
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...
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.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.