Search results for query: *

I agree that SQL is a mess to look at! I about had a heart attack once I figured out how to find it and got a good look at it!! Where do I create these aliases? I'm assuming I have to name them somewhere so Access knows which tables I'm talking about. Thanks to everyone for the assistance...

Finally! The field [ Tech Tool Attempt] has been eluding me for a week! I added a table, realized that I hadn't changed the column names and removed it. Because I added and removed it, everytime I'd go to view the report, I Access would ask me for the values of those fields. I've got them...

I'm using Access 2010. Using your method, I found the SQL....Thanks! Even though I found it, I think I'm more confused than I was before! Anyways, here it is: SELECT TechProfile.TECH_ID, TechProfile.SUPERVISOR, VOC.COMCAST_TOTAL_SCORE, METRICS.TECH_ID AS TECH_ID_METRICS, METRICS.TOTAL_JOBS...

Where would I go to find the Reports record source property? Significant Table #1: EmployeeProfile (Table Name) Employee_LastName (Field Used) Employee_FirstName(Field Used) Employee ID (Field Used) Supervisor (Field Used) Significant Table #2: METRICS_9_22-10_21...

When I click on the field in the report and select Control Source, it shows PASS_RATE_METRICS_9_22-10_21 "PASS_RATE" is the field and "METRICS_9_22-10_21" is the table. For the Current Pass Rate it is PASS_RATE I'm thinking it doesn't name the table because it was the first field I entered...

As of now, each monthly metric has it's own table. To get the text box to reference the field, I drag it into the report from the right side "add existing field list" How do I get the SQL view of the report? I tried to right-click the Report's tab, but it only gives Report View, Layout View...

I'm thinking this will come into play with my new database as well. I'm trying to run a query to pull the prior 90 days of data, sum one field and sum another so when I add it to the report, I can create a field that will divide the two to create a percentage. The same goes for the query, if...

I'm currently combining all of the tables via import. The way it's setup now is I have SEVERAL different tables. Each metric has it's own table for every month. For example, I have Metrics_12_22-1_21, VOC_12_22-1_21, Efficiency_12_22-1_21, Metrics_1_22_2_21 and so on..... On the Report, I...

I've spent hours trying to research this before asking a forum. I've read a few books and went through many tutorials. What I'm trying to do is develop a weekly progress report for employees. I get data from 3 different data sources. One reports their usage of their self-reliance tools, one...