Macro to filter data

[Tursas]

Hello, a newcomer here.

I am developing a client database with Access 2007, of which I have little experience. Let me give some background info first.

I have a table which is supposed to show booked dates and the clients who this date have been booked to. Only problem is, it also shows the clients who doesn't have any dates booked for them.

My knowledge in macro limits to RunCommand and that's it. Do you guys have some idea how I would be able to implement a macro that filters out all the clients who doesn't have a booked date.

And apologies if my explanation is a bit unclear, because my native language isn't English. If there is any confusion, then ask and I'll try to be more specific and articulate.

Thank you.

 

[Trevor G]

Welcome to the forum,

You dont need a macro you need a query which will use your parameters then filter based on them, one suggestion is to create a form that is unbound set a few text fields in and name them then create a query which uses the fields as the parameters and then send the result to open the query from the form.

 

[ABeepath]

can you place a sample of your table data and exactly what you are trying to filter by? I can try to assist with procedure to get it done.

 

[SteveSchapel]

Tursas,

I agree with Trevor, this is a job for a query, not a macro.

And from your description, I suggest all you would need is to make a query, based on your table, and in the Criteria of the booked date field, enter like this:
Is Not Null

 

[Tursas]

Heh, thanks guys. I have a tendency to think too complexly. I should be able to manage this now. Thanks again.

@ABeepath
Thanks for your friendly offer but no need for it anymore