Search results

Pat - Oops! maybe i sounded a bit ungrateful! I feel that programs should do what you want them to rather than make you do things a specific way - I was just trying to get over the 'you shouldn't do that because...' and try and get to the 'well if you do insist on doing it that way then try...

Thanks everyone - I'm going to carry on without the spreadsheet look for now. I would like to acheive this method of data entry though - and i don't think it should be impossible so if anyone feels like pointing me in the right direction instead of talking me out of it then pls post.

The reason i want a spreadsheet look is that I want to eventually add this db to an existing db - this bit has always been done as a spreadsheet traditionally - and there were always incosistencies between the project DB and issue spreadsheet - obviously just because the data has been...

wow! thanks for the quick reply - now that you've confirmed that i can't enter the data through a crosstabQ - I've managed a bit of a workaround and could do with some help refining it If I can populate a table with the results of a select query that produces a record for every...

Access 2003 - Windows Vista - Novice programmer (so be nice) I have 3 tables: documents Issues Revisions I need all 3 values to be user expandable. I have a central table that has lookup fields for all 3 values - I can then do a crosstab query that shows them in a nice matrix with...