Search results

I have a excel spreadsheet with a header row and 8 columns Column A-C are set to text format Column D is set to Date format (3/14/2001) Column F is text format Column G & H are set to Date format (3/14/2001) When I try to import this into a new table it changes the date to a 5 digit number...

Thank you all!

I thought that there may be another way of doing this short of a pivot table or report. If I pulled it into Excel is there a way?

I have two tables (One table named Customer Info has address, phone #...etc and the other table named Customer Order has order info) I have joined the Customer # field from both tables and set it to include all records from 'Customer Info' and only those records from 'Customer Order' where...

Thanks! I also found a solution here. http://support.microsoft.com/kb/304408

I am looking for a way to force a shutdown on a database. I have reviewed the post http://www.access-programmers.co.uk/forums/showthread.php?t=103278 and follow this example with no luck. After following this step by step when I open the Shutdown.mdb (without holding down the Shift key) the...

They are 1-1. How do I set PK of one table and the Foreign Key of the other table? They do have to be in the same table if at all possible

I am trying to create a form with fields from two tables. The Table Names are HCF and IRR. HCF has the following fields: Ref Number (Primary Key)-Relationship set Date Comment IRR has the following fields: Ref Number (Primary Key)-Relationship set Phone Address The problem that I am...

And both of you keep on drinking if it helps provide solutions. I would prefer a drunken solution any day over a sober attempt. Just kidding :)

Excel is where I normally work so I understand. :D It worked like a charm. Thanks so much for all the help.

Going forward I will not include any spaces in the table names or field names. That is good to know. So I pull up a new query and did not select any fields...I then selected SQL View and input the folowing SELECT Sum(If([Correct Name]="no",1,0)) AS TotalN0CorrectName FROM [Note Table]; I...

So I post this in the SQL View? Do I just paste this in the SQL View? TotalN0CorrectName:Sum(If([Correct Name]="no",1,0)) Or do I add the Select and From? I do apologize for my ignorance I am new to using SQL.

I pasted in SELECT SUM(CNT1) AS FAX, SUM(CNT2) AS INTERNET, SUM(CNT3) AS PROVIDER FROM (Select Count(First Name) as cnt1, 0 as cnt2, 0 as cnt3 From Note Table Where [FAX NOTE] = "No" UNION ALL Select 0 as cnt1, Count(First Name) as cnt2, 0 as cnt3 From Note Table Where [INTERNET NOTE] =...

I inputted this and changed the field names and added my table name and picked a a field name from my table for the "SomeField" When I did ran the query I got a error message stating "Invalid bracketing of the name 'Select Count(First Name) as cnt1, 0 as cnt2, 0 as cnt3 From Note Table...

This did work great to sum all of the three together. I am looking to make the 3 fields sum into 3 seperate fields..... I apologize I should have put that in the first post. Is it possible to have the query run without pulling up a prompt box and asking for "SomeField"?

I have three fields Correct Name-contains "Yes", "No", or "N/A" Correct Color-contains "Yes", "No", or "N/A" Correct Request-contains "Yes", "No", or "N/A" I am trying to create a query that will do a count of each time that "No" is displayed in one of the three fields.

Yes I am trying to set the overall score in the table. I am pretty sure that it is bound...I know this may be a dumb question but how do I tell if it is? The Overall Score field is specific to each record and would need to change each time I move to a new record.

Yes the field is bound. So I can not assign the value to the control source or the default value since it is bound. Instead of adding this to the Current Event can I add it to something else? Is there a work around? Any suggestions? Not sure if it helps but all 3 fields are set to Number data...

I had put this under the current action so that it will update the underlying table on the OverallScore field. I first tried putting =[TotalPoints]/[TotalPosPoints] into the text box and when I look at the record in the table it shows 100% and the form shows 96%

I am trying to write a function and need some input The three fields I have are: TotalPoints TotalPosPoints OverallScore I am trying to take TotalPoints/TotalPosPoints and display the results in the OverallScore Field. I have written the code but I keep getting a "Runtime error '6'...