Search results

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.

Have you considered a subform to record the varying details of each inspection? Depending on what and how you are recording the data it might be a better way.

I think I would make so you get an error if you try to show a report that does not fulfil the criteria. Even better would be to not allow the user to select a report that dos not fulfil the criteria. As for the title you can make a text box and set it to lookup the valus you need using dlookup...

Sorry for not getting back earlier. This is the SQL view cut down to the essential: SELECT (Min(IIf([tblPSC].[NumberOfObservations]>1,0,100)) AS PSCPerformance, VesselMasterData.VesselName FROM VesselMasterData INNER JOIN tblPSC ON VesselMasterData.VesselID = tblPSC.VesselID GROUP BY...

That might be the source of the problem. Does anyone have an overview of where you must use which characters to avoid getting into this sort of problem?

I know number is reserved but shortened the full name of the field as it is not really relevant. What I find strange is that Performance: (IIf([tbl].[someNumber]>0,0,100)) is not the same as Performance: (IIf([tbl].[someNumber]>0,0,100)) The first is what is being displayed in the query. The...

Does anyone know why access insists on throwing a syntax error when I enter the following in query: Performance: (IIf([tbl].[Number]>0,0,100))? After rooting around I ended up doing this by mistake: Performance: (IIf([tbl].[Number]>0 ,0 ,100)) Then it works however it is still being displayed...

Hi NewShoes While I am not able tooffer anything on the actual mechincs of the combobox I know I would make it a bit differently if I could. While I agree that removing "old" years is a good thing, perhaps you could do this in the query by setting the oldest year to current year minus...