Search results

I think I am just plain lost. I am cufused by the normalization that I dont know what do next. Sorry. I have removed all the personal information from my database. (3000+ rows) I have attached it. I am trying to find the proper query to take the data from my tblClientcontacts and put that...

I am a registered Democrat but have gone to the right. The dems and their stances on many topics have lost my confidence. They flip flop a lot on subjects and never really seem to have any true convictions. They more or less just tell you what you want to hear. The republicans may do the...

Yeah, sorry the obvious. I thought I appended the data to that table but it wont let me. Trying to append field 'Eligible' to 'CreditAmount' Here is my tblCallCredit: CALLCREDITID (PK) - AUTONUMBER CALLID - NUMBER CREDITYPEID - NUMBER CREDITAMOUNT - NUMBER I AM TRYING TO APPEND FROM...

Hello, Trying to put together a query that has all my data. However when I get to the this table the query no longer works, has just the titles. When I add tblCallCredit the query stops working. If I remove that table I get the data that the query is supposed to fetch. I am not sure if its...

Thanks pBaldy, never quite used Append Queries before so bare with me. So when I append my new tables I should include the PK from the old table. OldTable Id (pk) Stuff Things Somthing StuffTable StuffID (Pk) Stuff ThingsTable ThingsID (pk) Things Thats a bad example probably, but Do I...

Thanks for your responses. Now in terms of this response will this happen by simply doing the append? I did try to just append the fields without the PK, does this create the FK automatically if database is normalized with relationships setup? I guess I didnt know if append query takes into...

Ok. I have normalized a database I am working on. Now when I append the data from the one table to the several tables do I have to append the PK's in each one? If that even makes sense. I have one table that has several fields. When I append the data to about several different tables does...

Hmmm in regards to my tblCalls I have the following: CALLID ACCTID INTIAL_CONTACT_DATE DATE_ENTERED CALL_NOTES I have changed the following under tblEmployees to the following: EMPLOYEEID EMPLOYEE (aka Entered_By) Your stating if I used "Entered_By" in both tables right? Currently I am just...

I appeciate all the help and explanations. It seems like normalizing is one of the most difficult and most crucial areas of Access since its the foundation. Yes the "ENTERED_BY" employee definately goes on the call. I just need to input other employees who attended the call. Ok so for the...

Ok I think I understand what you are saying now. I have attached the image which is bascially what you had before. So this is all I would need, correct? The employee role would be say like this: 1 = Entered_by 2 = Went on Call The credit type would be as follows: 1 = Normal Call Credit 2 =...

Ok. So I will take a look at yours again, I tried to understand what you were saying. This normalization thing can be tricky. :) So I can use something very similar to what you setup in your picture then add a seperate table for the imported Excel sheet. Then I would be able to use some...

I think this might be right along what your saying or in general what I should do. I attached the image. I will then just import the Excel sheets on a weekly basis and will do the append query to populate the data. Is there anything wrong with this setup? I attempted to to follow your advice...

Thanks for the assistance. See the excel sheet is actually a database query from a purchased database that strores a lot of data from our division. I have tried serveral times to either be allowed to connect via odbc or some other way in order to automatically get the data. The data in the...

Would this be ok, I am not sure if the columns for the imported excel sheet should be kept by itself in a able. tblImport ACCOUNT_NUMBER SHORT_ACCOUNT_TITLE CONTACT_COMMENTS CONTACT_TYPE_TEXT ENTERED_BY INITIAL_CONTACT_DATE DATE_ENTERED tblEmployees EMPLOYEE1 EMPLOYEE2 EMPLOYEE3...

Hello, ACCOUNT_NUMBER SHORT_ACCOUNT_TITLE CONTACT_COMMENTS CONTACT_TYPE_TEXT ENTERED_BY INITIAL_CONTACT_DATE DATE_ENTERED These are fields that are imported from Excel. I have to import 500-1500 rows each week which contain the data I need. Then I must, by using a form, go through these...

Ok. I just started it anyhow last week - Its replacing me doing it on Excel. I thought maybe I could just do that in a bit and things would work out. I wasnt sure what fields I needed to after I made the form and tested to make sure that I had everything I needed. I will normalize it first...

Ok. Well first of all its all in 1 table still. I was going to split it up here shortly when I realized all the fields I needed. (Hope thats not a big issue) I attached an image of what it looks like so far. Basically in these fields: Entered by Officer1 Officer2 Officer3 Are employees...

Hmmm looking around at posts here I am starting to think this isnt possible. Does anyone know if the only way would be to make 4 Crosstab queries and then join them in a 5th? I guess that would work...just didnt know if there was a simplier way.

I just noticed my count isnt working how it should be, or how I would like it to be. SELECT "Count" AS [ENTERED_BY+OFFICER1+OFFICER2+OFFICER3] This is only counting field ENTERED_BY. I have tried different things today and no luck. I have tried using a Count (*) and a few SUM options. I...

Thanks. I was really close but thought I needed a date function of some sort. Geesh sometimes things are easier then they seem. I tried the Where Clause several times but had used it incorrectly. +Rep