HomeworkLib
Question

microsoft access hi i am trying to create a query to find employees with the same...

microsoft access
hi
i am trying to create a query to find employees with the same last name as me. in my table, the first and last name are combined under the field employee names.
ive run the query but i get zero results even though there are three matches.
please help


engineering   Computer-Science   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

Use Wildcards using LIKE operator.

Assumption:

  • Table Name: Example
  • Column Name: Name
  • Your Last Name: Doe

QUERY:

SELECT * FROM Example WHERE Name LIKE '% Doe';

0 0
Add a comment
Know the answer?
Add Answer to:
microsoft access hi i am trying to create a query to find employees with the same...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • Lab Assignment – Database Implementation and Security In this lab you will create a Microsoft Access...

    Lab Assignment – Database Implementation and Security In this lab you will create a Microsoft Access database of employee information and secure the table username and password security. Steps Enter data for five employee records. Each record should have fields: Employee ID (5 digits), First Name, Last Name, Home Address, Hire Date Create a query that displays Employee ID, First Name and Last Name. Create a form that requires entering username and password to access employee table. Error message should...

  • Lab Assignment – Database Implementation and Security In this lab you will create a Microsoft Access database of employee information and secure the table username and password security. Steps Enter...

    Lab Assignment – Database Implementation and Security In this lab you will create a Microsoft Access database of employee information and secure the table username and password security. Steps Enter data for five employee records. Each record should have fields: Employee ID (5 digits), First Name, Last Name, Home Address, Hire Date Create a query that displays Employee ID, First Name and Last Name. Create a form that requires entering username and password to access employee table. Error message should...

  • microsoft access i am asked to create a relationship but im not sure how to add...

    microsoft access i am asked to create a relationship but im not sure how to add the second one Create a relationship between the EMPLOYEES and EMPPURCHASES. Create a second relationship between the PRODUCTS table and the EMPPURCHASES table.

  • Trying to run an sql query in VBA but every time I run the macro I...

    Trying to run an sql query in VBA but every time I run the macro I get an error message stating " Run-time error’- 2147217900 (80040e14)’: ORA-00923: From keyboard not found where expected”. I am a newbie with using queries and am wondering if anyone knows what the problem is with the query I wrote and why I keep getting this error in VBA. Everything in my code works except this query so I know the problem has to be...

  • Here is my SQL statement that I am trying to run in order to pull employees...

    Here is my SQL statement that I am trying to run in order to pull employees who were born in 1963, however I'm stumped on how to get it to be ran as ONLY the year 1963, any help would be awesome. SELECT   FirstName, LastName, BirthDate FROM   Employees GROUP BY BirthDate, FirstName, LastName;

  • Microsoft Access 0 database name should be the broad name of what will be inside it....

    Microsoft Access 0 database name should be the broad name of what will be inside it. If I were creating a database on the history of the Pittsburgh Steeler Coaches I would call mine SteelerCoaches.accdb, for example. A. Design one table with at least a. 6 Fields (can have more, but not more than 10) b. Correct datatypes for your fields c. Property changes appropriate to the fields. Have all Field names with more than one word have no spaces...

  • Hello, In Python, I am trying to create a function that will return the domain name...

    Hello, In Python, I am trying to create a function that will return the domain name from any inputted email address. For example, my input of john@domainname.com would return just the domainname. It needs to be done using regular expressions and the map function. I'm still stuck on trying to get the correct parameters for regular expression and also what is throwing it off. Thank you for your help! I am currently working with a list of different email addresses...

  • I need to use SQL in microsoft access to deal with those problems. Have no ideal...

    I need to use SQL in microsoft access to deal with those problems. Have no ideal on how to edit the code. Here is the requirement. Database Design and Relationships 1. Create Primary Key(s) as appropriate for all tables. In TIMESHEETS, employees can only log time to a given WORKCODE once per day (e.g., if someone works on R&D for 2 hours in the morning and 2 hours in the afternoon, it's entered on the timesheet as 4 hours for...

  • Hi, I am trying to solve a problem where I have to find the fourier series...

    Hi, I am trying to solve a problem where I have to find the fourier series for a square wave with an amplitude of one, w = 2pi. How can I show that the An coeffcients of the fourier serie will be zero for a square wave? The square wave is first wave in the picture.

  • In trying to apply my knowledge in the real world, I am trying to create a...

    In trying to apply my knowledge in the real world, I am trying to create a realistic retirement schedule. However, I am running into difficulties using both a financial calculator as well as our equations from class in doing this. I am trying to do the following: plan a retirement schedule between the ages of 25 and 70, in which I would deposit 20% of my income each year. The income starts at 80,000 with an annual growth rate of...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT