Search results

Re: autonumber..........aarrggghhh If you have a form where you create the jobs, you can use the DMax function to create an automatically increasing number. You need toset up an extra fiedl to contain the job number. In the forms BeforeInsert vent, enter the following: MyField =...

If you are using a report to display the results there is the option of sorting the students on the marks. You can find this under the group and sort buton.

I think the learning curve is triping everything up. From my own experience Word has a pretty flat learning curve in the beginning It may become steeper but most users will not go there. Excel has a start that is a bit steeper but it soon flattens out again unless you keep using new functions...

Try this: Int(-100 * [Sum(([Category1]="C")*-1/21)) / -100

Just figured out what it was. Always, always, always remember to save a query every time you make a change to it. Otherwise it just gives you funny ideas.

I have tried to implement the suggested solution but without luck. Since I already had the information from tblReportDates available in a query I tried using that. From what I could understand from spelling my way through your module this is what it achieves. Apart from not being in a table, I...

Thank you Recyan, that looks promising. I ill see if I can get it built into my own project.

I wish it was that easy. The problem is that I need a count for every month within a period. Of course I could make a seperate query for each month but that becomes useless when I try to make a graph out of the numbers.

That would simply be this: Month Count jan-2001 1 feb-2001 1 mar-2001 1 apr-2001 1 may-2001 1 ...... oct-2012 1 ....... may-3195 1 .......

For vessel 1 it would count in jan 2001 and in every month thereafter until the end of time or until an end date is entered. Since we don't know when vessel will leave our management we can not set an end date until we are informed it has been sold or ill be moved to a different management company.

Hi vbaInet Let me try to visualise it. The grey line represents the month where the vessel has been in management. The arrows mean that the grey line continues in that direction. I hope this helps.

Having continued the search for a solution I think the only way to solve this would be a module that takes the dates for the beginning and end of each month and counts how many vessels are in between. I had no problem making a query that gives me the dates but since the module requires vba I...

Sorry if I was not clear enough, I must have left my brain somewhere in a spiderweb. What I want to get out is how many vesels there are in management in a given month. The actual data would be something like this: VesselID - VesselName - DateInManagement - DateOutManagement 1 - Vessel 1 -...

I have been trying to get a count of the vessels we are operating grouped by months. The data is structured as follows: VesselID - VesselName - DateInManagement - DateOutManagement DateInManagement is always filled out with a date. DateOutManagement is either with a date or null. What I would...

I have been told that it is just a matter of getting the OS registered somehow thus showing up on the approved list for the hardware. While I don't know what the cost is, I got the impression that is was pretty cheap.

While I don't want to step on John's toes I had the same problem once and solved it this way. Make sure there is a relationship between the two queries. You can simply drag a common field from one to the other. Double click on the relationship line and you will see 3 options at the bottom of...

That is a problem someone with more knowledge will need to look at as I can't quite see a solution I could make.

If you have already found the highest number used, why not just add 1 to it and display that?

If you only ever use a single toner on each occasion you count count the number of dates recorded and subtract it from the total number of toners ever bought. If you use more than 1 toner you need to either make two records of use the field you are currently using. If you do not want to change...

In Denmark we have about 46 homocides per year. The majority is committed using knives or other stabbing weapons. Guns are generally illegal and have been for many many years.