Search results for query: *

I have a query that pulls projects and lists hours worked on by different people on a report. I would like the user to be able to open this query, through a report, and be able to type in the project number to get that project its hours worked only, like a parameter query with dates. What do I...

I have a query that pulls projects and lists hours worked on by different people on a report. I would like the user to be able to open this query, through a report, and be able to type in the project number to get that project its hours worked only, like a parameter query with dates. What do I...

thanks for the help, I needed to join through a query. For some reason that worked... And I finally got the reason why, joining number and text. Andy b, ---And Then Nothing Turned Itself Inside Out---

SELECT Employee.E_First, Employee.E_Last, Employee.E_Manager, Hours.Hours_Spent, Hours.Date, Hours.Project, Hours.Type FROM Employee INNER JOIN Hours ON Employee.E_ID = Hours.FristLast E_manager is what I want it to be grouped by, and this is a lokoup Andy b, ---And Then Nothing Turned...

What do you mean, where is the query? Andy b, ---And Then Nothing Turned Itself Inside Out---

I am getting a "type mismatch" error when I try to run this query that is pulling info from a lookup table. Access help told me it was a problem, but not how to fix it. It told me I should use them (foreign keys) when you specify criteria for a field. How do I do this? Do...

Thanks! easy enough Andy b, ---And Then Nothing Turned Itself Inside Out---

In have a parameter query looking up specific dates. How do I show these begining and ending dates entered in the parameter on the report? Andy b, ---And Then Nothing Turned Itself Inside Out---

In have a parameter query looking up specific dates. How do I show these begining and ending dates entered in the parameter on the report? Andy b, ---And Then Nothing Turned Itself Inside Out---

The column that it is looking up is a lookup table of 4 names, first and last. I am getting this error even without anything in the criteria field???

I am getting a "type mismatch" error when I try to run this query that is pulling info from a lookup table. Access help told me it was a problem, but not how to fix it. It told me I should use them (foreign keys) when you specify criteria for a field. How do I do this?

Where does that go into this expression? SELECT Hours.FristLast, Hours.Hours_Spent, Hours.Date, Hours.Project, Hours.Type FROM Hours WHERE (((Hours.Type)="over-time"))

I know you probably get this one all the time, but I need to know what I can put in the criteria of a query that will bring up dates from 14 days ago to the current.