Search results

I have a query which returns the top 10 contract numbers based on a predetermined rank. Right now the report is very detailed which ends up with one contract per page. Does anyone know a way to list the top 10 in the report header so it would look like this? 1. Contract A 2. Contract B 3...

For work I am designing a query the refers to a form for answers to parameters. I need the entries to allow null entries. There are 11 different parameters. I know how to put in the code and everything, but the query is so large that the computer doesn't have enough memory to run it....I...

Hello! I'm new to the forums but have already found it to be very useful! I'm about to graduate college and not an expert in the least, but I'm on my way (thanks in part to help from this forum)! Currently working for the state and working on a database for our procurement system. It's been...

I've been trying to figure this one out, and I'm not sure if it's possible, but rather than create a combo box for the form can I get this to work with just a text box? I have not had any luck thus far. I want it to be like when it asks for a parameter value, and you just enter something...

I had one query I sorted as as ascending and it returned the way I want sorting as 1,2,3 I did it on another query and the order cam back 1,10,100...How do I get it to go with 1,2,3 as well? Why did it change they way it sorted? I didn't click anything different...