Search results

IS there a way to pass a global variable into a simple select query?

I have a subform that displays one field of data called Renew Date. There are multiple renew dates that are listed in the sub form. How do I go about searching each one of those Dates and checking to see if there is one that is between 2 dates that a user enters. The If statement that I have...

Thanks Worked Great!!!

Thanks, I tried the different joins and I got the same result, I am trying the sub reports now. I will let you know how it goes.

I have the following SQl statement that returns a number of aspects about a certain record. However each record may have more than one date associated with it that is stored in another table. I receive all teh dates that are associated with it but I also get hundreds of other lines of the same...

I have a button that runs a SQl statement. How do I get the output from the SQL statement into a text box OR how could I get the output to a report. Either one will work.

what am I attempting to do? I am not sure. Yet... I will get back though.

I am having the same problem that you did were you able to fix it? If so How did you do it?

I have a database that I have created for a few users and they need to be able to access the query wizard or a SQL prompt from the user interface. I have set up security on the database to allow the users to create queries, but I have no Idea how to allow a user to get to the query wizard or to...

I have a user that occaisonally needs to do her own querries, Other than the ones I have already created for her. Is there a way I can create a button that will take her directly to the query wizard? Any help would be greatly appreciated.

I have a user interface that I have created in Access 2000, I would like the user to be able to query the data stored in the tables at any time he or she wants. I have already turned all the built in toolbars and menu bars off and I just want my toolbar that I created to show on top of the...

Thank you very much worked great.

I would like to type in a ID number and check to see if it exists in the database. If it does I would like to display another form that shows the rest of the information relating to that specific ID number. If it does not exist I would like a message box to pop up and let the user know that he...

I am trying to create a interface where the user enters in a specified number which is linked to another form that brings up more information on that specific number. I have no problem creating a button to do that, but I need to add code so if the specific number that user types in is not in the...