Search results for query: *

Hello, Is it possible to use a text field as the value part of a cross tab query? i want to combine two crosstabs into one with an amount and a comments field. I will be using ID numbers to match the coments to the figures in the main table. every time i try to add the text field as a value i...

Hi, Me again. scratch the northwind thing, i saw the error. i have doen as you suggested and it is brilliant. the only question i have is : Can i use two seperate sources for the Value part of the cross tab? i figured that is i perform an IF question based on the title of the column so that it...

Thanks for your help. I want access to store the comments so that when i enter the data each month the comments will stay against the relevent row. the reasons i have been unable to just use excel is that every month the row details (which are spendcodes) will be similar but different ones...

JONFER! I have the table perfect now. i still do not understand the updating query though. the append adds records but then i get a duplicate set of records (minus the comments). how do i go about updating the information and keeping the comments with out having duplicates everytime i run the...

I have no idea what you have done but you are a genius! I now have the the table exactly how i need it. I am just going to try the appending thing to see how that works but I thought i would reply while you might still be online, Thank you so much!

I am fairly new to access. I have been tasked to make a financial db which will output to excel. I have raw data grouped in tables by Accounting period. I have made a union query to select the info from all of the periods which totals the amount and groups against the spending code. I then have...

Many thanks for helping me out JonFer, here is the SQL of my Main union query and my cross tab query that runs off of it. i realise that i have probably set out the tables wrong as i have created one for each period and thats probably useless. many many thanks again, here we go.... MAIN UNION...

I am fairly new to access. I have been tasked to make a financial db which will output to excel. I have raw data grouped in tables by Accounting period. I have made a union query to select the info from all of the periods which totals the amount and groups against the spending code. I then have...