Search results

I have a database at a stage where I want to give it to other people for testing etc. What I don't want is for the people who test it to be able to see the structure or be able to make any changes. I'm thinking that the answer is 'Runtime' but I'm not sure. I'm using Access 2003 and the...

More genius! That was the last piece of the puzzle, it's forms and fluff now and we are ready for real testing. Thanks for input.

I'm struggling because the update query doesn't seem to want to update the table from within itself. I usually find a way round these things but this has me stumped....

I have a table, and all I want to do is take the number from one field and insert it into the other. My table simply has 'opening' and 'closing', they are dates, and I want the figure from 'closing' pushed across to become 'opening', I then insert a fresh date via a form into the 'closing'...

Cracked it, thanks :)

So presumably the 'closing' to 'opening' first and then the 'zeros'? Any idea how I move the 'closing' to opening'? That's the bit that has me stumped.

Ok, dumb question time again. I need to make an update query to change 4 fields, three of them will become 'zero' which seems pretty straightforward, but the other one needs to become what I'm replacing with one of the 'zero' figures. To try and be a litle clearer, my columns are 'opening'...

More genius, I love this forum, thanks a million!

I need to open a from in datasheet format to enable me to tab through columns of figures. I can do this easily enough, but when I use a command button from another form that I am using as a menu it opens in a single form format that I really don't want. Any ideas? As usual, all help appreciated.

Genius! That worked straight off the bat, thanks.

Thanks, I will give that a whirl and report back

I've tried, really I have, but I can't find the answer so please excuse if the question has been asked and answered a gazillion times already. I'm running a query that reports a profit margin on consumption with the answer expressed as a percentage: GP %: ([GP Amount]/[Cons Ex VAT]) The...

If I'm working out percentages on a calculator then I have to multiply by 100 to move the decimal point across, but spreadsheets and databases seem to know where to put the decimal when you use percentage as the number format. I sorted this out myself, it was a simple case of missing brackets...

Sorry to take so long coming back, been working today and not had chance to sit down to this. I do appreciate help. This is the calculation: =Sum([SumOfGP Amount]/[SumOfCons Ex VAT]) My ignorance runs pretty deep, so 'scuse if I get any terminology wrong. But the two amounts I want to use...

Another dumb question; sorry :o I'm running a report which produces a percentage. When I do the calculation myself it comes out at 60.81%, when I run it in Access it comes out at 601.81%, any idea where I'm going wrong? Thanks in advance.

That's brilliant, sets me on the right path. Thanks.

Ok, I have attached what I have done so far. I'm happy-ish with the inputting side with the simple forms I have, and the tables/query side seems to be doing the calculations I need but the whole thing is a learning curve. I think that all the information I need is there, it's really a case of...

Edit: I would be happy to give up the box / border part of the presentation if I need to. That's not so important as getting the actual rows and columns in the right place. Forgot to say I'm using Access 2003. Thanks for help.

I don't know how to get those rows to present in a report like that, and I don't know how to get columns to total downwards. You've answered the second part already though I think.

That's only part of it, but it does need to be presented like that yes. There are other fields with equations in but they seem more straightforward.