Search results

Thanks a lot to all who helped me in the past few months, I now feel somewhat comfortable with this program, and I owe it all to members of this message board. Thanks again! Mike St. Louis MO

I have a simple question that could make or break my database, Is it possible to have auto calculations in a table? And if so, how do I do it? Just like in excel: Unit Cost Current In stock Total Value $12 4 =(Unit...

Is that really what I want to do? This may help... This particular part of my program is being used for an annual inventory. My user needs to be able to enter in correct numbers of products whenever they are finished counting them. I dont want them to have to put in 3000 new quantities, and...

But.. I still have a problem, I am trying to get the changes that my calculation made in form view to be reflected in the actual table. How come this is not working? Mike Thanks again

I am new to access this year. I am finishing up an Access 97 db that I need one more feature out of. 3 Fields in my table are the following. Current, UnitCost, TotalValue. (Current being the current number of an item in stock) I have to be able to make the database autocalculate the Total...

I have a dB that I designed last June. It is a program that holds product information in a storeroom. My users have requested a way to search the ENTIRE dB, with only one search string. I have one main table that contains my parts data, and I have select queries that control all my searches...

Hello again, one more issue. All of my reports are based on queries. I sort the datasheet that my query produces, and then run my report. How come I sort the query and sort the report by the same fields, but they do not match? Any Ideas?? Mike Fischer

Thanks Thanks a lot, your example took care of me. I really do appreciate it!

HELP! Total Value Report I don't understand, what do you mean by Group Header? Sorry for being so ignorant of Access, I only work with it one day a week on an internship. Thanks I understand the usage of the =Sum([TotalValue]) Function, but I don't know where I need to place it in order to...

I have finished up my db except for this one report I HAVE to find a way to create. What I have is: -ONE Table, with all my information (I know this is usually frowned upon) -I have 9 classifications of parts that my user breaks data up into. eg.. Administrative, Electrical, Mechanical...

I have a db that keeps track of storeroom inventory. I have one table that includes all of my data, and I have searches, controlled by select queries that allow my users to search through and find parts by a certain classification. (Eg... Search by Vendor, Search by location, etc....) These...

No, it is based directly from my table... Should I be using a base query to make it? Thanks Mike

I know this is very simple, but I am new to the program. I have an Access 97 database with three four reports that will be used on a regular basis. One of these reports is named "Count Sheets" It is a item by item listing of all the items in the storeroom. My problem is, at the beginning of...

I have user level question for Access 97. My database contains information about a specific item, and also the Vendor information for the supplier. In quite a few instances, my user would like to be able to add new parts to the database, but keep the same Vendor. How can he copy the Vendor...

Thanks a lot I appreciate the help

Hello, I recently wrote a database that keeps track of storeroom inventory in a chemical plant in St. Louis, MO. My user has a couple questions that I hoped someone would be able to help me with. 1. Is it possible, in datasheet view, to enter a new record ANYWHERE in the datasheet, not just...

I have a part inventory database that I am working on. I have to create all the reports that the store room's old program had in it. One of these was a Total Value report. This report has all of my part classifications on it, the total value of each of those classifications, and the number of...

Is it possible to search through all fields of my table with a query? I have several searches by certain fields, but my user wants to be able to search through ALL of the available fields, is this possible? thanks Mike camaroltd82@msn.com

I have a store room part inventory database I just implemented. My users have requested a search query that will search for anything in a string of words (Their part descriptions) I use the following criteria in all my other queries, but this only works if they type the first few letters of...

Thanks a lot, I get it perfectly now.