Pivot Tables, Help?

I am trying to create a pivot table based on an Access table.
when I create the pivot table and link it to the table it asks me to drag 
the column fields, the row fields, and data into the proper area. I don't 
want any row fields, and i dont quite understand what the data area is-or 
what is supposed to go there. I just want to drop the columns in with the 
data in each colum then sum them at the bottom.

CAn you please help because my pivot table looks like a mess?
0
adam1685 (340)
3/23/2005 3:43:03 PM
excel.misc 78881 articles. 5 followers. Follow

6 Replies
255 Views

Similar Articles

[PageSpeed] 24

Hi Adam

the data area is for the information that you want to sum
the columns and rows are used for categories
for example, if you had the following data in an access table
Deptartment............ExpenseType.........Amount

and you wanted a pivot table showing the expenses for each dept you would 
drag
department to the column area
expense type to the row area
and amount to the data area
giving you the following

............Sales..........Accounts...........Production ...Total
Meals...100..............50......................300............450
Travel....1000........................................................1000
total......1100..............50....................300..............1450

also check out www.contextures.com for pivot table info

Cheers
JulieD

"Adam" <Adam@discussions.microsoft.com> wrote in message 
news:04695F2B-0106-4503-8A27-91CC69A6FC07@microsoft.com...
>I am trying to create a pivot table based on an Access table.
> when I create the pivot table and link it to the table it asks me to drag
> the column fields, the row fields, and data into the proper area. I don't
> want any row fields, and i dont quite understand what the data area is-or
> what is supposed to go there. I just want to drop the columns in with the
> data in each colum then sum them at the bottom.
>
> CAn you please help because my pivot table looks like a mess? 


0
JulieD1 (2295)
3/23/2005 4:23:37 PM
I got the sheet to layout correctly..however by putting fields i want to sum 
in the data area sums them per record across in a row and not at the bottom 
of the column like i need. Also when i refresh the data source the records on 
the pivot table dont change...I double checked the source and still no 
change. I purposely edited the source to see if my sheet would reflect it, 
and it does not??

"JulieD" wrote:

> Hi Adam
> 
> the data area is for the information that you want to sum
> the columns and rows are used for categories
> for example, if you had the following data in an access table
> Deptartment............ExpenseType.........Amount
> 
> and you wanted a pivot table showing the expenses for each dept you would 
> drag
> department to the column area
> expense type to the row area
> and amount to the data area
> giving you the following
> 
> ............Sales..........Accounts...........Production ...Total
> Meals...100..............50......................300............450
> Travel....1000........................................................1000
> total......1100..............50....................300..............1450
> 
> also check out www.contextures.com for pivot table info
> 
> Cheers
> JulieD
> 
> "Adam" <Adam@discussions.microsoft.com> wrote in message 
> news:04695F2B-0106-4503-8A27-91CC69A6FC07@microsoft.com...
> >I am trying to create a pivot table based on an Access table.
> > when I create the pivot table and link it to the table it asks me to drag
> > the column fields, the row fields, and data into the proper area. I don't
> > want any row fields, and i dont quite understand what the data area is-or
> > what is supposed to go there. I just want to drop the columns in with the
> > data in each colum then sum them at the bottom.
> >
> > CAn you please help because my pivot table looks like a mess? 
> 
> 
> 
0
adam1685 (340)
3/23/2005 6:17:05 PM
It updates it when there is a delete on the uderlying table in access but 
when i add them back it does not reflect in the sheet?

"JulieD" wrote:

> Hi Adam
> 
> the data area is for the information that you want to sum
> the columns and rows are used for categories
> for example, if you had the following data in an access table
> Deptartment............ExpenseType.........Amount
> 
> and you wanted a pivot table showing the expenses for each dept you would 
> drag
> department to the column area
> expense type to the row area
> and amount to the data area
> giving you the following
> 
> ............Sales..........Accounts...........Production ...Total
> Meals...100..............50......................300............450
> Travel....1000........................................................1000
> total......1100..............50....................300..............1450
> 
> also check out www.contextures.com for pivot table info
> 
> Cheers
> JulieD
> 
> "Adam" <Adam@discussions.microsoft.com> wrote in message 
> news:04695F2B-0106-4503-8A27-91CC69A6FC07@microsoft.com...
> >I am trying to create a pivot table based on an Access table.
> > when I create the pivot table and link it to the table it asks me to drag
> > the column fields, the row fields, and data into the proper area. I don't
> > want any row fields, and i dont quite understand what the data area is-or
> > what is supposed to go there. I just want to drop the columns in with the
> > data in each colum then sum them at the bottom.
> >
> > CAn you please help because my pivot table looks like a mess? 
> 
> 
> 
0
adam1685 (340)
3/23/2005 6:21:02 PM
Hi Adam

i've not had much experience with pivot tables using MS access, but i set up 
a quick one to test out your problem ... i'm using access 2003 and excel 
2003.

my db has staff and training courses.  When i added a training course to an 
existing staff member the pivot table was updated when i pressed the refresh 
icon (red exclaimation mark) ... when i added a new staff member and 
training course it was again updated when i pressed the refresh icon.  - to 
create the pivot table i used the create pivot table option on the bottom 
left of connection dialog box (data / import external data / new database 
query ........ found db, chose tables, said return info the excel and then a 
dialog came up and said which cell - on this on was the create pivot table 
report link which i pressed).

so what is it that you're doing differently to me, or are you using a 
different version (this behaviour may have changed between versions) - i can 
test on other versions.

Cheers
JulieD

"Adam" <Adam@discussions.microsoft.com> wrote in message 
news:E2ED95EF-9C38-4E7A-9D48-27673C8634D9@microsoft.com...
> It updates it when there is a delete on the uderlying table in access but
> when i add them back it does not reflect in the sheet?
>
> "JulieD" wrote:
>
>> Hi Adam
>>
>> the data area is for the information that you want to sum
>> the columns and rows are used for categories
>> for example, if you had the following data in an access table
>> Deptartment............ExpenseType.........Amount
>>
>> and you wanted a pivot table showing the expenses for each dept you would
>> drag
>> department to the column area
>> expense type to the row area
>> and amount to the data area
>> giving you the following
>>
>> ............Sales..........Accounts...........Production ...Total
>> Meals...100..............50......................300............450
>> Travel....1000........................................................1000
>> total......1100..............50....................300..............1450
>>
>> also check out www.contextures.com for pivot table info
>>
>> Cheers
>> JulieD
>>
>> "Adam" <Adam@discussions.microsoft.com> wrote in message
>> news:04695F2B-0106-4503-8A27-91CC69A6FC07@microsoft.com...
>> >I am trying to create a pivot table based on an Access table.
>> > when I create the pivot table and link it to the table it asks me to 
>> > drag
>> > the column fields, the row fields, and data into the proper area. I 
>> > don't
>> > want any row fields, and i dont quite understand what the data area 
>> > is-or
>> > what is supposed to go there. I just want to drop the columns in with 
>> > the
>> > data in each colum then sum them at the bottom.
>> >
>> > CAn you please help because my pivot table looks like a mess?
>>
>>
>> 


0
JulieD1 (2295)
3/24/2005 5:01:16 AM
Thanks for your help but i figured it out...the problem was that there were 
duplicates in the underlying table, the pivot table in excel doesnt show or 
count the duplicates...BUT can you help me with another issue?

I'm trying to sum my columns and when i choose table options in the pivot 
table options list i check it on to sum - the words "grand total" show up but 
not total. What i did then was sum them up manually by highlighting the 
entire column and clicking the sum formula button - this works but only 
temporarily. Because the total is summed outside the pivot table, when ever 
the table grows it total clears out the formula or pushes it down (the 
problem with that is if the table shrinks again you cant see the sum because 
it was pushed down out of view so you wont even know there is a sum there).

"JulieD" wrote:

> Hi Adam
> 
> i've not had much experience with pivot tables using MS access, but i set up 
> a quick one to test out your problem ... i'm using access 2003 and excel 
> 2003.
> 
> my db has staff and training courses.  When i added a training course to an 
> existing staff member the pivot table was updated when i pressed the refresh 
> icon (red exclaimation mark) ... when i added a new staff member and 
> training course it was again updated when i pressed the refresh icon.  - to 
> create the pivot table i used the create pivot table option on the bottom 
> left of connection dialog box (data / import external data / new database 
> query ........ found db, chose tables, said return info the excel and then a 
> dialog came up and said which cell - on this on was the create pivot table 
> report link which i pressed).
> 
> so what is it that you're doing differently to me, or are you using a 
> different version (this behaviour may have changed between versions) - i can 
> test on other versions.
> 
> Cheers
> JulieD
> 
> "Adam" <Adam@discussions.microsoft.com> wrote in message 
> news:E2ED95EF-9C38-4E7A-9D48-27673C8634D9@microsoft.com...
> > It updates it when there is a delete on the uderlying table in access but
> > when i add them back it does not reflect in the sheet?
> >
> > "JulieD" wrote:
> >
> >> Hi Adam
> >>
> >> the data area is for the information that you want to sum
> >> the columns and rows are used for categories
> >> for example, if you had the following data in an access table
> >> Deptartment............ExpenseType.........Amount
> >>
> >> and you wanted a pivot table showing the expenses for each dept you would
> >> drag
> >> department to the column area
> >> expense type to the row area
> >> and amount to the data area
> >> giving you the following
> >>
> >> ............Sales..........Accounts...........Production ...Total
> >> Meals...100..............50......................300............450
> >> Travel....1000........................................................1000
> >> total......1100..............50....................300..............1450
> >>
> >> also check out www.contextures.com for pivot table info
> >>
> >> Cheers
> >> JulieD
> >>
> >> "Adam" <Adam@discussions.microsoft.com> wrote in message
> >> news:04695F2B-0106-4503-8A27-91CC69A6FC07@microsoft.com...
> >> >I am trying to create a pivot table based on an Access table.
> >> > when I create the pivot table and link it to the table it asks me to 
> >> > drag
> >> > the column fields, the row fields, and data into the proper area. I 
> >> > don't
> >> > want any row fields, and i dont quite understand what the data area 
> >> > is-or
> >> > what is supposed to go there. I just want to drop the columns in with 
> >> > the
> >> > data in each colum then sum them at the bottom.
> >> >
> >> > CAn you please help because my pivot table looks like a mess?
> >>
> >>
> >> 
> 
> 
> 
0
adam1685 (340)
3/24/2005 2:21:03 PM
Hi Adam

just to clarify you have a list of categories down the rows and across the 
columns and assoicated values in the data area - and when you tick the Grand 
Total for columns and grand total for rows the row and column is created 
with the heading but no values are shown?

this is most weird ... as in all my tests it shows the grand totals 
correctly ... what version of excel are you using?  does the same thing 
happen if you build a pivot table from "normal" excel data (although i've 
tested it successfully on a link to access)
what happens if you apply a report format to your pivot table (the 
lightening bolt icon on the pivot table toolbar) does it work then?

Cheers
JulieD



"Adam" <Adam@discussions.microsoft.com> wrote in message 
news:F092856A-5015-4C8E-9111-BF2C17FC5244@microsoft.com...
> Thanks for your help but i figured it out...the problem was that there 
> were
> duplicates in the underlying table, the pivot table in excel doesnt show 
> or
> count the duplicates...BUT can you help me with another issue?
>
> I'm trying to sum my columns and when i choose table options in the pivot
> table options list i check it on to sum - the words "grand total" show up 
> but
> not total. What i did then was sum them up manually by highlighting the
> entire column and clicking the sum formula button - this works but only
> temporarily. Because the total is summed outside the pivot table, when 
> ever
> the table grows it total clears out the formula or pushes it down (the
> problem with that is if the table shrinks again you cant see the sum 
> because
> it was pushed down out of view so you wont even know there is a sum 
> there).
>
> "JulieD" wrote:
>
>> Hi Adam
>>
>> i've not had much experience with pivot tables using MS access, but i set 
>> up
>> a quick one to test out your problem ... i'm using access 2003 and excel
>> 2003.
>>
>> my db has staff and training courses.  When i added a training course to 
>> an
>> existing staff member the pivot table was updated when i pressed the 
>> refresh
>> icon (red exclaimation mark) ... when i added a new staff member and
>> training course it was again updated when i pressed the refresh icon.  - 
>> to
>> create the pivot table i used the create pivot table option on the bottom
>> left of connection dialog box (data / import external data / new database
>> query ........ found db, chose tables, said return info the excel and 
>> then a
>> dialog came up and said which cell - on this on was the create pivot 
>> table
>> report link which i pressed).
>>
>> so what is it that you're doing differently to me, or are you using a
>> different version (this behaviour may have changed between versions) - i 
>> can
>> test on other versions.
>>
>> Cheers
>> JulieD
>>
>> "Adam" <Adam@discussions.microsoft.com> wrote in message
>> news:E2ED95EF-9C38-4E7A-9D48-27673C8634D9@microsoft.com...
>> > It updates it when there is a delete on the uderlying table in access 
>> > but
>> > when i add them back it does not reflect in the sheet?
>> >
>> > "JulieD" wrote:
>> >
>> >> Hi Adam
>> >>
>> >> the data area is for the information that you want to sum
>> >> the columns and rows are used for categories
>> >> for example, if you had the following data in an access table
>> >> Deptartment............ExpenseType.........Amount
>> >>
>> >> and you wanted a pivot table showing the expenses for each dept you 
>> >> would
>> >> drag
>> >> department to the column area
>> >> expense type to the row area
>> >> and amount to the data area
>> >> giving you the following
>> >>
>> >> ............Sales..........Accounts...........Production ...Total
>> >> Meals...100..............50......................300............450
>> >> Travel....1000........................................................1000
>> >> total......1100..............50....................300..............1450
>> >>
>> >> also check out www.contextures.com for pivot table info
>> >>
>> >> Cheers
>> >> JulieD
>> >>
>> >> "Adam" <Adam@discussions.microsoft.com> wrote in message
>> >> news:04695F2B-0106-4503-8A27-91CC69A6FC07@microsoft.com...
>> >> >I am trying to create a pivot table based on an Access table.
>> >> > when I create the pivot table and link it to the table it asks me to
>> >> > drag
>> >> > the column fields, the row fields, and data into the proper area. I
>> >> > don't
>> >> > want any row fields, and i dont quite understand what the data area
>> >> > is-or
>> >> > what is supposed to go there. I just want to drop the columns in 
>> >> > with
>> >> > the
>> >> > data in each colum then sum them at the bottom.
>> >> >
>> >> > CAn you please help because my pivot table looks like a mess?
>> >>
>> >>
>> >>
>>
>>
>> 


0
JulieD1 (2295)
3/24/2005 2:35:17 PM
Reply:

Similar Artilces:

Access 2003 Help Needed!
Hello, I work at a university and we are trying to input all the professor's research titles into a database for students who want to do a special project with that professor. We need to print off these research ideas for various uses. Whenever I try to print them off, if there is more words than can fit on a page, it just cuts them off. Can I somehow tell the program to text wrap? Also if the titles are really long, Access won't let me enter over a certain amount of characters - can I change that as well? thanks :) Dana On Tue, 8 Jan 2008 08:30:00 -0800, Dana <Dana@disc...

macro help #17
Hi All, 3*2 3*3 3*2 3*4 3*4 3*4 3*2 3*2 3*5 3*5 3*4 3*4 3*4 3*4 3*5 3*5 3*5 3*5 3*4 3*4 3*4 3*4 3*4 3*4 3*2 3*2 3*3 3*3 I have following kind of data i want to convert the above column into following , how can i do that =3*2 =3*3 =3*2 =3*4 =3*4 =3*4 =3*2 =3*2 =3*5 =3*5 =3*4 =3*4 =3*4 =3*4 =3*5 =3*5 =3*5 =3*5 =3*4 =3*4 =3*4 =3*4 =3*4 =3*4 =3*2 =3*2 =3*3 =3*3 Can i do it using the help of macro ? Regards, Raan Sub multiply() For Each cell In Selection cell.Value = "=" & cell.Value Next cell End Sub Gord Dibben MS Excel MVP On Sat, 17 Nov 2007 08:25:09 -0800 (PST), ...

Help with VBA for document formatting.
Dear all: I am currently working on a rather large document that I need to format a certain specific way. The document includes nearly 57,000 lines of plain text that need to be indented according to a simple rule so that it can then be imported into an application as a tab- delimited file. A member from another forum suggested this might be more easily done with Word instead of Excel so I decided to post this questions here. My system is a Mac G5 running the latest version of Leopard (not Snow Leopard) which is 10.5.8 and I have Microsoft Office 2004 installed (haven't upg...

Help with AVI files!
Hi guys, I need some help figuring out some stuff about avi files.I have this Class CAviDlg which extracts bitmaps from Avi files and displays them on the dialog box. Im using threads in order to display these bitmaps as continuous stream of images for some purpose in my application. //this function is called by the thread UINT ShowAviFile(LPVOID pParam) { //code to draw on the dialog box CAviDlg *tdlg = (CAviDlg *)pParam; tdlg->OnShowAviFile(); return 1; } //mesage handler for the ply button in the CAviDlg class void CAviDlg::OnPlay() { thread = AfxBeginThread(ShowAviFile,this,0,0,0...

Help with design structure
i want to create a database for my makeup shop. I know i would have a table for all the products but i want to also track customers who buys what product so that i can always inform them of new itmes. i want to now if i need just one table or i need more than than. my table will have fields for prices and total amount. this will be and invetory for the shop that should show what we have as orders and what is Purchase orders. Hi Can I make a suggestion. If you go to the microft site you can download (free) databases that will just what you want. Much better than spending a...

help help
Hi All, Need help in formulae.. I have one master sheet , In which one tab is contain name , Id etc,, and reason of leaving organisation and in another tab I have to show no. of person leaving for this reason .. for e.g ABC left for better opportunity , so headcount of better opportunity = 1 Thanks in advance regards Dush The sumif formula is explained in the help files. :) **** Hope it helps! **** ~Dreamboat Excel VBA Certification Coming Soon! www.VBAExpress.com/training/ www.Brainbench.com Word Test Developer 2000,2002,2003 ******************************** "Dushyant Rajput&qu...

Cell Reference help required
Hello All, I have a problem with Cell reference between spreadsheets. Help would be highly appreciated. Here is what I need. I have 30 different spreadsheets in a workbook. Worksheet names (Aug01, Aug02, Aug 03�.Aug30). All the sheets are similar. I need to refer the totals of the previous worksheet in the current one. Example: D5 of sheet Aug30 to D4 of sheet Aug29, ('Aug29'!D5) D5 of sheet Aug29 to D4 of sheet Aug28, ('Aug28'!D5) hi, on sheet Aug29 at D4 put this =Aug30!D5 REgards FSt1 "Raja" wrote: > > Hello All, > > I have a problem with...

Help with SUMPRODUCT
I'd like to calcluate a range based on 3 different conditions: Area="Northeast" Closed Month="OCT","NOV","DEC" Sales Stage="02 - Qualified" Range to calculate: Total Sales (times 25%) The formula I used is this: =SUMPRODUCT((A13:A68="US-Northeast")*(I13:I68,{"OCT","NOV","DEC"})*(K13:K68="02 - Qualified")*((F13:F68)*.25)) Yet it's giving me an error. The thing that is raising my eyebrow on it is, when the formula is getting written, you can see the ranges selected in the color-code...

Help with Absence sheet formula.
Hi, I manage a monthly absence sheet, we have 4 types of absences "sick; a/l; bev; dom" and "late or Early finish" All of these types of absence are entered in one row for a certain person on a certain date. (calendar type of row,31 cells ). At the end of that row I need to calculate and divide them monthly for each day of the week how many absences were there(Mon2; Tue-o; Wed-3 etc...) but excluding the "Late" or "early" inputs. I do have a formula and I thought if there is an simple one that I can use? Here is a copy of the formula I use for eac...

Excel formulae + drop down table
I am trying to recreate a really big excel sheet filled with formula and was wondering if there was any way i could see all the formulae o that sheet without having to click on each cell. Also, there is a drop down table that has specified values in it tha you can choose from. Any idea on how i can recreate that? Thanks Rub -- rubyn1 ----------------------------------------------------------------------- rubyn15's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=3148 View this thread: http://www.excelforum.com/showthread.php?threadid=51164 Go to tools > optio...

Public Folder access after migration NEED HELP!
I have a user who's mailbox was recently migrated from Exchange 5.5 to Exchange 2003. After the migration she no longer has access to 2 public folders that she previously had access to. Permissions have her as Custom on the folder being able to Read, Create and edit all items in this calendar. I have set and reset these permissions to no avail. Any reason why she cannot gain access even though permissions for her to have access are specified??? ...

Need to keep reattaching tables
I migrated a FE-BE database to Access 2007. Now, everytime the computer is shut off and turned back on, we have to keep reattaching the tables through the linked table manager. This is annoying. How can I insure that the link stays each time? Thank you for your help. ...

Publisher tables & Adobe Acrobat
Hello Folks, Using Pub 03 and Adobe Acrobat Pro. When sending a Publisher file that contains a table to be converted to a PDF in Adobe Acrobat Pro, all the lines that make up the table are converted to dashed lines in the PDF. Normal lines convert OK. Is this a Publisher or Adobe issue. You help in resolving this matter will be greatly appreciated. Looking forward to you answer in anticipation. <-><-><-><-> Big Rick I use the pdf creating program PDF-Exchange and it renders lines correctly. I'm guessing it is Adobe causing the problem. -- Don - PDF-XChang...

HELP!alert when negative number comes in?
Hi, I am trying write a code that alerts the user when a negative number i in a cell. This may sound basic but i am just a beginniner at vba's. Can anyone help??;) ;) ; -- Message posted from http://www.ExcelForum.com I am not sure about VBA. However, You can use the cell validation and set an alerts. To do this click the cell. Click Data on the menubar, Click Validation, On the settings tab Allow whole numbers or Decimal, Set data to Greater then or equal to 0, Set minimum to 0. On the Error Alert type the Tille and error message that you want. Hope this helps Judi >----...

v6-What tables effected by Year-End close for Inventory
It seems we failed to run "End of Year" for our inventory. Our Last Year is still reflecting 2004 and Year to Date is carrying over from last year 2005 into 2006. So far I see tables IV30101 and IV30102 hold the totals. Would anyone be able to tell me what other tables would have been effected. Also, if we were to run the "End of Year" now would that be a good solution. We just dont know if it will only transfer as of a certain date. Thanks for your help. ...

Soccer Draw File help
I run a competition for over 300 people with 4 grades of teams in local soccer competition. I have an extensive file I have made t record results etc. One area I have trouble with is an easy way t generate a draw. At the very least I would like to be able to input th team names, number of rounds and have it generate the draw for eac grade in turn or all together. Ultimately I would like it to be able t put certain grades on certain days but this is a bit more complicated one step at a time. If anyone would like to look at the file to see what can be improved will send it to you. I would app...

need help to change default color setting in Publisher 2003 worksp
The background/workspace color for my copy of Publisher 2003 is pink (and very annoying). To clarify what I mean by background/workspace, when I open up a new project in Publisher, I have a plain white sheet surrounded by bright pink rather than the dark gray background/workspace of all my other MS Office programs. Other than unloading and reloading the software, which may not even work as I did the initial install, I can't think of any way to change the color. I'm hoping someone out there can point me in the right direction so I don't have to go through that process. Th...

Pivot Table
Hello I'm trying to create a pivot table which identifies the stock leve changes every month by customer against stock incoming. I however hav to provide a monthly report with the previous months stock level as starting point for any input/output of the following month. Doe anybody know how to create a pivot table that allows this particula functionality. Thank yo -- Message posted from http://www.ExcelForum.com ...

0x8004210B
On Windows XP Professional with Outlook 2002 SP2, I was getting the above error. This occurs when sending or forwarding mail with attachments. This was a brand new system fully patched (Windows and Office updates applied and Trend Micro Internet Security 2004) Since I had come across this before - I tried following the same procedures to workaround but had no success. I tried the following articles: http://support.microsoft.com/default.aspx?scid=kb;en-us;329923&Product=ol2002 http://support.microsoft.com/default.aspx?scid=kb;en-us;823663&Product=ol2002 http://support.microsoft.com/d...

Formula to match Cell with table of contents
I currently have a Hyperlink table of contents listing each tab. This is listed in column C. I would like to match a cell (example E400) of each tab with each Table of Contents in column D. This would give me a summary of each tab next to the TOC list. This would help looking up any tab with significant balances. Thanks!! something like: =INDIRECT("'"&C2&"'!E400") -- Best Regards, Luke M "Terry" <Terry@discussions.microsoft.com> wrote in message news:CD053CC9-8ED8-487E-BFB1-D590749C469C@microsoft.com... >I...

Updating multiple tables using a query driven Form
I have three tables - Staff table - Questions table and a Score table the relationships are Staff to Questions 1 to many; Questions to Score 1 to many when I run the query it does show the junk data I added, When I bring up the Form, it shows the all fields correctly but it will not allow me to add records or update the junk record I added. I want the Score table to be updated/added and to just display the questions and Employee information. Where am I going wrong? Hi Bunky, Many times queries are not updateable - you can't add records to them. In your case, with one-to-many rela...

Copying Formulas in 2003 HELP HELP HELP
My question is a little unique. My formula is G1*1.1 I put the result in H1. I can drag a formula down in a column, and it increments the row number, but the resulting answer is the same in H2 as it was in H1. If I press F2 in H2 then enter, the answer is correct. My spreadsheet is almost 15,000 lines, and I do not want to have to F2 each cell in the H column....... Any ideas or suggestions? Thanks...... Roxy Hi Roxy check tools / options / calculation - ensure that it is set to automatic Cheers JulieD "RoxyB94" <RoxyB94@discussions.microsoft.com> wrote in mes...

Arrrrrrrrrrrrrrrrggggggh! Please help me!!!!
If: B2=56; I want want a formula that uses the value of B2 as the row number for B3. Therefore, the cell address for B3 would be ($A[value of B2]). I have a huge number of columns from which I need to extract data at specific points, but those positions change from column to column and sheet to sheet. Therefore, I need a formula that automatically gives me the value for the cell address I want using the value in one cell as the row number for another cell. I hope that somebody can help me. Thanks -- D. Hay Hi try the INDIRECT function in B3 =INDIRECT("A"&B2) Cheers ...

Use fields in table as part of hyperlink
Hello, I want to include a hyperlink in a report based off of two fields in a table. Essentially I want to dynamically build the URL such as: http://www.abc.com/group/[TABLE1].[FIELD1]&[TABLE1].[FIELD2]/post.php I've searched high and low and can not find this capability in Access. Thanks for any help on this! -Chris That should work. You may want to add the # around the actual address, i.e. use: http://www.abc.com/group/[TABLE1].[FIELD1]&[TABLE1].[FIELD2]/post.php#http://www.abc.com/group/[TABLE1].[FIELD1]&[TABLE1].[FIELD2]/post.php# -- Allen Browne - Microsoft MVP....

URGENT: Print preview help
when i normally click print preview i get a small dashed line showing me the edge of the pages, however suddenly its gone! how do i get it back as im trying to line some stuff up but cant now :( quick replies appreciated :) -- Zapp Brannigan ------------------------------------------------------------------------ Zapp Brannigan's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=15498 View this thread: http://www.excelforum.com/showthread.php?threadid=319274 Hi Zapp try clicking on the margins button or maybe better yet use Page Break preview (under the view...