Search results

I have included a sample of my database. The query and report in question are: The sort is defined in the query in the last 3 fields. As you can see the report sorts the data properly, and the data is grouped accurately on the DMC num. How do I suppress the duplicate DMC number so it looks like...

I have a lot of reports that use the sort from the query and work just fine. It just doesn't work if I put a prompt in the Report Header or Report Footer. The default sorts from the report don't work with my datat.

I have a query that I have created for a table that will sort text data, including values that look like numbers into a proper sort, i.e., 300, 385 427, 3085,, etc. rather than the default sort. I have two questions about creating a report using this query. 1. I created a report that has a...

Thanks. I will have to study that one a bit, but I like the idea.

Very clever. That's exactly what I need! Thanks.

Yes, it makes total sense, and I am mapping out how I want to do that now. I had thought there might be something quick available like Dlookup, etc. that exists in Excel. I appreciate your help in sorting through all this.

Thanks for your input. That gives me something to think about.

This is just one table from a relational database, but I was trying to do something simple instead of tracking an entire project and the threads. I can certainly create that and read the thread table from that. I just wanted a quick list by providing numbers and looking up the count. Thanks for...

Sorry, if I misled with my original question. I have one existing table that will be used that has the ID, the thread name, and inventory count and is loaded with data. The form I want is not going to update the database in anyway -- it's just pulling existing data of how much of each thread I...

Thanks, that's a wonderful source. There's no relationship diagram that applies for my database. This is one table that has the ID number, the thread name, and the inventory. This application is not as involved as a true inventory control database.

There are over 500 entries in the table that contains the threads. They are stored as text because not all of the id's are numbers, i.e., some have letters. I think it would be too cumbersome to go through that lengthy of a list to find an assortment of id's. The form I had in mind is multi...

No, I can't upload the whole database because of other business info it contains. However, I have attach a database that contains the table that hs the data. Will that help?

This seems like it should be simple, but I can't figure out how to do it. I have a database with a table that contains Id numbers of threads and the inventory on hand of each thread. I want to create a form that allows me to enter an id number and have it look up and display the inventory...

oops - forgot to thank you for the code to list all the queries. It worked perfectly.

Sorry. I mean a list of all the reports and/or form used by the query.

I am using Access 2016, Window 10. Is there a way to get a list of all the queries in the database? Also, is there a way to find out where each query is used and print a report? Thanks, Judy

arnelgp -- I noted your changes to my query also. It looks a lot more elegant than what I did, but I still need to spend some time working my way through it to completely understand it. Thanks again -- Judy

Thank you to the folks that helped with uploading the database and solving the problem. I really appreciate it. Obviously, I am somewhat new to Access and was completely stumped. Thank you again. arnelap -- the database you sent does exactly what I wanted and JHB, thanks for pointing out the...

I finally figured out how to get the database small enough to attach. Sorry to be such a doofus. Thanks, Judy