Search results

I have two tables, one smaller and one larger. I have an existing personnel entry form that adds records into the smaller table. What I need to do is link the two tables together somehow so that when I enter a name that exists into the personnel entry form it searches to see if there is an...

Hi, I want to update all records with a birth date listed to have an age in a separate 'age' field. I have got the hang of the datediff function but i can't seem to get it to work in an update query. I need the query to search for all records that have a birth date listed which i have done...

Hi I'm trying to create a system for a multiple inputable criteria query and I need to use a toggle button to use as an interface to create a query and input a criteria. any ideas? thanks

Hi, my client has two databases, one smaller one saved as an access database with more complete details of clients and a much larger one saved as an excel spreadsheet with many incomplete entries but many more fields. I need to create a system whereby upon entering a new user in the smaller...

Hi, I know that access can send commands to open word easily but how do I tell access to lift just the addresses field of a record and send it into word as a letterhead? Thanks

Hi, I have different buttons on a form that search for specific individual profile types i.e. age range 16-24, gender male/female, disability, ethnicity etc where each button brings up forms detailing all people conforming to that specific criteria. What I need to do is create a mechanism...