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, 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 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, 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...