Finding Current_Date?

[Connor]

I have a table, with 4 records in it. 2 records have the "date" field for 01/11/2005, and 2 dates are for 02/11/2005.

Is there a way to just query the "current" date? Weather it be in a pop-up box once the query is selected, asking for the date? or is there a restricted word within access2003 that lets you find the current date?

I would essentially like a command button within a form to allow the user hit teh button, and it will automatically find those records within the DB with the current date(set to system clock) and export it to excel(i have this portion, the exporting to excel complete)

Any help would be greatly appreciated.

Connor

 

[Ian Mac]

Use:

=Date()

In your query Criteria

 

[Connor]

thanks

is there any way to question the user on what date she would like to input?
and i take it we cannot add a query into a switchboard can we? anyway of doing it?

 

[neileg]

You need a parameter query to get user input. Look in Access help for this. The most elegant way is to use a form to capture the user input. You could set the default value of the control that is used to capture the user input to Date() but allow the user to overtype this with their own date.

You can add a query to a switchboard, but users shouldn't be presented with a query. Better to use a form or a report that is based on your query. When you open the form or report it will run the underlying query automatically.

 

[Connor]

can u give some insight on how to do this?

 

[Pat Hartman]

When you open the form/report designer, notice that you can choose from a list of tables or queries. You can use queries and tables interchangably in most cases.

 

[Connor]

Pat, thanks for your help, i really appreciate it.
Do u think if you have some time, and if i post or email you my database, you could take a moment or two and point me in the right direction as to normalization, if i need more tables and so on? Im starting to think that i need an extra table or two to make the program a little more efficient, and productivity wise, better.

I understand if you havent got teh time, but please get back to me.

Thanks again

Connor

 

[Pat Hartman]

I can't provide private consulting services except on a fee basis. Post your structure here and lots of people will look at it and offer suggestions.