Cause query to ask for name at startup

[sephiroth2906]

Hello all!

I have a form that reports to a table specific information about employees. When I want to view the information, I am only going to be interested in viewing a single employees entries over the course of the last year.

I used the criteria "Like [" to ask for a name at startup, but I was wondering if there was a way to make that selectable from a combo box or some other way to avoid having to type the entire name exactly.

The second part is a bit tougher. Instead of putting in a date range here, what I would like the query to do is automatically look at the last year ending on whatever today's date is. I could create a between criteria, but I assume that this is possible.

I really appreciate the help!

[orange]

This will give this date a year ago

dateserial(Year(date)-1,Month(date),Day(date))

If you could identify an employee by some characters in the lastname. For example, you could try something like this

PARAMETERS [What Lastname] string;
SELECT YourTable.*
FROM YourTable
WHERE (Table.Lastname Like [What Lastname] & "*") AND
YourDate Between dateserial(Year(date)-1,Month(date),Day(date)) and Date;

This would search for a Lastname such as Johnson using John but would also find Johnnson or Johnsville
You would have to type in enough characters for a unique lookup (from the left)


And to answer your question, yes you could use a form and a combobox.
You could also tailor the query to select specific fields.

[sephiroth2906]

Thanks for the advice orange!

Unfortunately, I have not progressed far enough in my Access studies to utilize those suggestions. That is my fault and not yours.

I did, however, find something I can wrap my head around, and thought I would put it in here in case someone else finds it useful.

For the date, I can put this in the criteria:

>=DateAdd("m",-12,Date())

Which will give me only the last twelve months.

As for the name, I did figure out I could put a wild card in, and as long as I typed enough to match one name, I was golden.

Example, john* would find Johnson, Michael

So I can still use the criteria

Like [Lastname, Firstname]

I hope to someday move beyond this, but it will do for now.

Thanks again!