Someone needed to do lots of calculations (for example adding one field to another and dividing by another to give a new value) so they made it into a crosstab. It's also quite a large database and it would be much easier/safer not to change anything pre-calculation stage. Also, the query will...
Leslie, I will post the SQL in due course but can't get at it at the moment.
Duane, By edit I mean build relationships with other tables. There are a number of measure names that in the crosstab query are being used as column headings. I would like to use these measure names as a foreign key in...
I'm working on a fairly large database and there is a crosstab query in it which is the end result of lots of other append/normal queries etc. I need to change some of the field values in the crosstab and it would be much easier to do if it was a normal query. Is there anyway you can convert a...
Sorry, I didn't explain it very well. Let's say you were assessing the performance of training centres and you were given monthly data in the form of:
TrainingCentre
NumberOfCandidates
NumberOfQualificationsAchieved
CandidateSatisfaction
MonthlyCostOfCentre
You might want to assess training...
Hi Duane,
Thanks for your reply.
The formulas themselves aren't very complicated (at the most percentages, subtractions and multiplications). However, I would like the option of just being able to update the formula in the table and any queries base on that value will be changed accordingly...
Hello,
I want to have a table describing the various field names that are used in a database. The data to be held in some of the fields are raw data but other fields will be calculations based on other fields. In my table "tblMyFieldNames" I would want to have two columns:
"FieldName" and...
Not sure why it's doing it. I wouldn't be surprised if you didn't believe me and I could provide a screenshot if you wish. In cells A8 and A9 I have used the list properly. However in cells A10:A15 I have typed any old letters (i.e not in the list).
Any ideas?
David
Hi Skip,
Just one thing - how can I limit the options to the resulting drop down lists? I thought this happened automatically but now users also can type free text (which I don't want).
In my Industries dropdown I currently have...
Skip,
Thanks for your help. I'm just getting a bit frustrated because I'm sure I did what you said and I can't work out why it's working for you but not for me.
I did have a Factory selected in SelectedFactory.
I have changed my source for validation in A7 to...
Ok, it's not quite as I planned but:
B2 is SelectedFactory
Then there are a few rows of spaces.
In row 6 I have my entry table column titles.
Cell A7 is the first dropdown for getting the Industries available in the SelectedFactory.
So this is where I have...
Hi Skip,
The initial three column list (Factory, Industry, Workshop) which comes from my database is about 400 rows long. Some Factories would have Industries that are also in other Factories but the combination between Factory, Industry and Workshop name would produce a unique Workshop.
eg...
Hi Aceman,
Thanks for your help but the form is now behaving strangely.
I open the form by selecting a case from a listbox and pressing a button on a previous form.
When the form initially opens the combo box allows you to change from one type to another without displaying the message box at...
Sorry, my mistake. If you open the form at a particular record then it seems that nothing is loaded into typOld and it does the message box as above. If however, you click yes you want to change it, then if you try to change it again it gives the warning as is required (i.e only when the type...
Hi AceMan,
Thanks for your help but it is not working yet. My knowledge on Access is very patchy so you will have to bear with me.
Every time I make a change to the combobox the message box appears saying
So presumably typOld does not have an initial value. Should its value have been declared...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.