Search results

I have a couple of tables that I only want to enter one set of data into, the idea being that each time the new numbers replace the old ones. My tables are automatically creating a second row though, and if I tab beyond the end of my form when entering data I end up with a big mess. How can I...

My first Access application is now ready for live testing and it's no exaggeration to say that I just would not have got to this point without the helpful folks around here. It's been quite a learning curve because I was starting from complete zero, but with the tutorials on the Microsoft...

Cracked it, thanks :)

I didn't know where to put this, so I'm trying here. I suspect it's fairly simple, but I can't find the answer. I want to be able to enter notes into a section on a report, just simple text entry. Could somebody point me in the right direction? Thanks in advance.

Problem solved, again, many thanks for input. I keep thinking that I'm finished if I can just solve the next problem, but there always seems to be one more problem.........

SELECT DISTINCTROW qryProductsUsage.CategoryID, qryProductsUsage.Section, Sum(qryProductsUsage.Consumption) AS [Period Usage], Sum(qryProductsUsage.Closing) AS [Stock On Hand], qryJob.Days, [Period Usage]/[Days] AS [Day Stock Usage] FROM qryProductsUsage, qryJob GROUP BY...

Thanks guys, it's late now so I will look at this tomorrow. Appreciate your input.

As usual, it's probably me mising the point. But I am running a query that throws up 'Enter Parameter Value' and I can't understand what it's asking me for. The odd thing is that if I just click ok then the query runs and gives me the answer I expect. I've read the help articles on the...

Thanks for that. I had to change my thinking there but the form/sort query approach has done the trick for me.

Is there any way of sorting tables? I add and subtract products all the time, and I want my new products to appear in the table in an order that is logical according to what I'm trying to do. I can get it right in Queries in order to produce the reports and queies I need, but I can't see how...

Brilliant! Thanks

Thanks for the link, it hasn't helped me a great deal but thanks.

I'm dividing the Day Stock by the Closing @ Cost, so that's the whole equation. If both of those fields have a value it works in the way I want it to, it returns the correct number for me if I just run it in the original format (it will work both ways around): Days Stock: [Closing @ Cost]/[Day...

Sorry, I just realised what a horlicks I made of asking that question so have edited it. The first part is the number of days and is itself a result of a query, the second part is the number of days calculated by a query. What it does is calculate the consumption per day and multiply it out by...

Days Stock: [Day Stock]/[Closing @ Cost] This expression is returning me an error if one of the numbers is '0', I really need it to return a '0'. I have managed to get an IIF statement to work in another part of the same query but for some reason the same format won't work here. This is the...

Thanks for replies, I will try both of these this morning.

I don't quite know where to ask this question, but, as always, any help appreciated and my apologies if it's in the wrong place. I have a form which runs a query for me to work out the diference between two dates, so an opening date and a closing date = a number (of days) I want to use that...

It's as much a question about Runtime as anything else. I'm still very new to Access and databases, so much of what is posted goes right over my head, but I try and take things in and then go away to test it; more often than not coming back with more questions until I get where I want to be...

Thanks for that, an MDE file sounds like a good solution for me just now. Edit: Just read the last post, I will need to be careful testing methinks. It's not earth shattering stuff I'm doing, it's just been a lot of work and I want to be careful where it goes etc.

I do have the option for an MDE file so will give that a try. What are the 'gotchas' ??