Search results

Hi, I have a field (Field A) that always has the numbers 1 thru 8 in it. The next field is just a numeric field 1 thru 100 (Field B). In the field I would like to create (Field C) I need it to add "Field B to a calculated number from (Field A). That calculated number would be ( IF the...

Hi Pat, Thanks for your help I will start working on this monday. Bill

Hi, Thanks for all of your help. I wasn't to clear on the first post so I am going to try to clear this up a little. I will explain things a little more in depth. - I have just 1 table that I am running these queries on. - The table has every name in it already (plus I also have a list of...

Hi, I have a table that I run a query on that using only 5 fields from the table. One field in the table is “Name” this is the only field that I define a criteria for. All of this works fine but it is very time consuming because I have hundreds of names that I need to run queries on each...

Hi, This is what I am trying to do in Access. Field#1___Field#2___ Field#3___Field#4___ Field#5___Field#6___ Field#7___Field#8 __5________6_________7_______8_________4________3_______2________1 Ref.#1____Ref.#2____ Ref.#3____Ref.#4___ Ref.#5____Ref.#6____ Ref.#7____Ref.#8...

Hi, This is a calculation that I use in Excel =INDEX($AJ$2:$AQ$2,1,OFFSET($AI$4,-2,MATCH(COLUMN()-19,$AJ4:$AQ4,0),1,1)) Is there a way that I can perform this calculation in Access? Thanks Bill

Hi, I am importing from Excel. In Excel I have a column formatted as dddd, that way the date will show up as the day of the week. When I import to into Access I lose that format and just get the date. How can I get I get the day of the week to show up in Access like I do in Excel? Bill

Hi John, Thanks for your help. I made sure that I didn't have any primary keys but still no luck. Any suggestions? Bill

Hi, Thanks for your help but I got the answer to the following question. You need to import from Excel into a new table then run a append query. Hi, I imported a worksheet from Excel to a new table in Access without any problems. Next I tried to import more new data from the same...