Search results

Hello, I am having issues with a linked table (in excel) not formating a date field as a date field. I have an online program that outputs all the information in One Excel Spreadsheet with Tabs. That Spreadsheet is linked to it's corresponding table in my database. Most of the Date Types are...

So I have a new query in design view. I add the Tables That I want, then I add the fields that I need. Next, I know that I need to paste the Expression that I built in the Expression builder. I put my curser in the Criteria row of the first Field (Named ContractorName) I then get the same...

Which field do I put the query in? When i put it in the ContractorName field, it gives me the same error as before: You have written a sub query that can return more than one field without using the Exists reserved word in the main query's From clause. Revise the SELECT statement of the sub...

:banghead: I Created the new query as you recommended, in the field selector, do I need to have the ContractorName, the JobID? When I paste the expression in a new query, I get the same results

Here is a screen shot. The database is larger than this forum will allow for an attachment. Thanks again for your help.

Thanks for your reply, I have this expression in the Criteria box of a select query that I have named "EmployeeReviewJobsiteSelector" There are 2 tables in the querry: Access_TimeClock & Access_JobsiteProfit. There is a one to one relationship created between the 2 using JobID The Query...

Hello Plog, I am using the Expression Builder in Access and have reviewed several tutorials on the w3schools site. I am unfortunately, not a very good programmer. Here is the updated code: (SELECT [Access_TimeClock].[ContractorName],SUM( [Access_JobsiteProfit]![Profit]) AS PROFITTOTAL FROM...

So I changed it up to get rid of the name and now have 2 tables, One has the Time sheet, the other The Jobsite Profit and Financial info. I am trying to use the right expression, but keep getting the same errors: SELECT [Access_TimeClock].[ContractorName],SUM([Access_JobsiteProfit].[Profit] AS...

Thanks for the assistance. It is very helpful. I agree about the word Name, it is very common and not descriptive at all. I will see about changing it.

Here is the syntax that I used in the Espression Builder Dialog box. It keeps giving me errors so I am almost sure that I am doing something wrong SELECT [Access_TimeClock].[ContractorName], [Access_JobsiteTable].[Name] FROM [Access_TimeClock] INNER JOIN ContractorName On...

I am not use to using code so I apologize if this question seams simple but do I use the expression Builder in my query to put this string in?

Thanks for your advice, Since the issue seamed to be stemming from an import query and calculated values in the append table, I decided to skip that data calculation all together and create a new table with the correct data type selected. Now my calculations all work and i have no rounding...

I am actually using this method to get the data into my report. I have dynamically linked several Excel Spreadsheets. I append the records using an append query and this is is were the decimal places disappear.

I changed them from Long Integer to Double, with 2 decimal points in the currency Format. When I do this I also change the corrisponding data types in all my tables, queries and reports. That is when I get the error.

Hello, So I started creating a data base that has a number of calculated values to get Profit, Margins and Overhead. The Excel Spreadsheet that I get the data from includes decimal points, however, when I imported the data, it created it to be a long interger. Since Integers do not have...

Sure, No Problem. Please see the attached files

Hello, I have several design issues with a report that I am creating. This report has the following: Project Name and Data at the top 3 subreports in the main body, 2 that are above and below each other Project Financials and Invoices at the bottom The Problem that I am running into is that...

Thanks for the right Syntax, The Information is in 2 tables, one Titled: Access_JobsiteTable has the list of Projects and their Financials, The Other is Titled: Access_TimeClock It has the Contractor's and Their Timesheets for each Job They both use the Field: JobsiteID as the reference Key...

Thanks for your help, I understand that part, but what is the correct SQL Statement to tell it to give me results A if B is "present" I tried several combinations and could not get it to work correctly.

So this seams to be an easy request, but I can't figure out how to word it. My boss is doing Performance Evaluations for everyone and wanted to Cross Reference Each Contractor with the Job That they worked on. The only way I know for sure is by checking to see if they have a time clock record...