[AccessD] Create a Search

Ken - I do exactly this with each business process and it works well.
Contact me off-line and I can send you an example.

Dan Waters
ProMation Systems

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Hollis,Virginia
Sent: Thursday, July 29, 2004 6:48 AM
To: 'accessD at databaseadvisors.com'
Subject: [AccessD] Create a Search

Does anyone have an example of creating a report by selecting search
criteria from fields? I had a request today to add a custom report builder
to one of my databases.

 

Some of the fields will be text where they can enter what they need and
other criteria will be from a combobox, they also want a date range field.
Then! they want to be able to save the criteria for later use.

 

For example - Document number - text box, Document type will be a combobox.
I want to know all the documents created during a certain month, quarter,
year, etc.).

 

I have tried something like this several times, but when it comes to having
more than one search criteria, I can never seem to make it work - then
adding a date on top of that - well, I am lost.

 

Thanks,

Virginia

-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com