Search results

Hello there, I had create a form and I would also want to include a combo box as a data selection/filtering option. I layout my database in such that it will have a master table containing every piece of information and also a lookup table for profession. Both the lookup tables are available in...

Thanks for the feedback and guides. I'll work with the Union query and see the results at the end :) Thanks

:) Hello I wonder how can I obtain a merged information by filtering datas from two separate tables? The following describes my working above; TABLE 1 - DATE, PART NAME, PART NO., QTY & COST TABLE 2 - DATE, DO NO., PART NAME, PART NO., QTY & COST Output = TABLE 1 data merged TABLE 2 data...

Thanks. It seems suitable for my database. :)

I had used the Command Button Wizard to create a Find Record / search button for my form. How can I customize the search criteria to only search from the field name Tag & User Name? What I mean here was, I do not want the normal pops-up search Window from Access but my own customize Window with...

Thanks for the info. I need a little specific detail on the DateAdd function. I am gonna create a new text box to display the expiry date and this is where the DateAdd function will reside. I appreciate if you could briefly describe how to work with DateAdd on my scenario? Thanks

Hello I am a newbie in this forum. I had designed a database with an input form for data entry. I would want to have a field that could perform a year calculation to calculates an expiry date for something. Eg; Date of Purchase -> 01/01/2004 Expiry Date -> **to be calculated 5-years from...