query for a particular date in tables

[nosbig]

I'm designing my first Access 97 database and my customer needs to be able to retrieve item(s) that have a particular date entered. This data can be in any one of 4 tables I have established. For example, he needs to be able to find out what brief was presented to someone on 9/13/98. He is unfamiliar with Access and I'm trying to make this as user friendly as possible so he only has to enter the applicable date and Access will give him the information he needs.

 

[kathryn]

Could you give us some more detail?&nbsp;&nbsp;What are the four tables?&nbsp;&nbsp;Are they related in any way?&nbsp;&nbsp;Is the user going to know, in some manner, which table should be searched?<br><br>My first thought would be a form with a frame and four option buttons to allow the user to check the table that should be searched.&nbsp;&nbsp;The form would also have a text box which would be used to enter the date.&nbsp;&nbsp;Finally, the form would have a command button to retrieve the records.&nbsp;&nbsp;Behind the command button, you would write code to create a query &quot;on the fly&quot; and run the query and present the data in whatever form you wish.<br><br>Does this sound like what you are looking for?&nbsp;&nbsp;None of this is particularly difficult, with a bit of help.<br><br> <p>Kathryn<br><a href=mailto: > </a><br><a href= > </a><br>

 

[nosbig]

My four tables are not related to each other but they have many common fields between them. I set up indiv tables due to tracking/data entry differences between them and I did not want to set up one large table. Each of these four tables IS related to a location table that has been established though.&nbsp;&nbsp;It does sound as though what you've suggested might work. I'm also going to try setting up a parameter query that will prompt him for criteria each time it's run.

 

[Guest_imported]

In your query first decide what table the date is coming from.<br>Then simply you can create prompt to ask any dates you want.<br><br><font color=blue>By adding </font><br><b><font color=red>[Enter the date in mm/dd/yyyy format]</font></B><br><font color=blue>To the criteria.</font><br><br>If you need any more info or an example let me know.<br>Good Luck. <img src=

http://www.Tek-Tips.com/images/happy.gif>