Search results

Sorted it. =IIf(IsNull([In VICTORY.CountOfCountOfSurname]),0 & " " & [surname] & " in Victory",([In VICTORY.CountOfCountOfSurname]) & " " & [surname] & " in Victory") Many thanks for the initial steer.

Many thanks for the very speedy response but that is giving me two errors? When I type it into the control box it says that it has an "invalid control source". If I ignore that and try and display the report, I get an error that tells me there are too many ")" I have tried mucking about with...

Hi, The following control in a report displays the number of people with surnames the same as those who served onboard HMS Victory during the battle of Trafalgar: [In VICTORY.CountOfCountOfSurname] & " " & [surname] & " - in VICTORY." It works fine but if there are no matches, it just...

RG, It looks like you didn't get a thanks for this. It has just helped me...so thanks :) Oscar

I have finally managed to get this to work but have to have one query based on another. Can anyone help me to combine these two below into one please ? First one named Qry_Test SELECT Qry_All_Ops.StartDate, Qry_All_Ops.Unit, First(Qry_All_Ops.JettyNumber) AS FirstOfJettyNumber...

Thanks mainly to John K I have the following code from a previous post which identifies when a 'Unit' has been entered at 2 different 'JettyNumber' on the same 'StartDate' SELECT Qry_All_Ops.StartDate, Qry_All_Ops.Unit, Count(Qry_All_Ops.Unit) AS CountOfUnit, Sum(Qry_All_Ops.JettyNumber) AS...

Excellent, thanks. I had bodged a fix where I wrote a second query and called one from the other but this is so much neater. Although it works fine, I have realised that there is an error in my maths and the code below won't find all the "errors" Result: [sumofJettyNumber]/[countofunit] Eg. If...

Thanks. I added Expr1: [result]=CInt([result])as a new column and it sorts the results into -1 and 0. It's the 0's I need but when I add the criteria "=0" as a where expression to the new column it tells me the expression is too complex ! New code SELECT Qry_All_Ops.StartDate...

The attached file shows a screen shot of my query. I need now to isolate only those results that are not whole numbers. I think it will be MOD or INT but I can't get it to work in the query. Also, do I add this "where expression" to the Result column or do I need to create a new Expr: column ...

I have managed to make a little progress on this but not much. I have written two queries: I have to admit that I don’t fully understand how they work but the first one below narrows the data down such that if a ‘Unit’ is listed more than once it must be in more than one location...

Thanks very much for your quick reply but I regret that I really don't understand what you mean.:confused: I couldn't trouble you for a quick & dirty SQL text could I ? Thanks

I have one table which contains the following fields: StartDate, Unit, Location, Operation. I want to run 2 checks: 1. To show if a Unit is in two different locations on the same day ? Eg. 23 May 07, Ship A, Jetty B, Fuelling 23 May 07, Ship A, Jetty B, Water - Is permitted. 23 May...

Got it ! The code below fixed it wherestring = "StartDate between #" & Form_OpenDate & "# and #" & NextDay & "#" Hope this helps someone else.

Afraid not. The code jumps straight to the error section and doesn't even appear to make any sense of the string.

I have spent hours trying to sort this via searching here and elsewhere. A button on a diary form sends an email containing the day's events. I have been asked to send the current day and the next day. This has me stumped! Form_OpenDate = Format(Me.Text62, "MM/DD/YYYY") ' Gets the date being...

All, I have a search form (continuous) which filters results from the main table. I can then double click on one of the filtered results to open a new form (single) showing all the fields for that entry. Fine so far. My question - There are ten different types of operation that can be...

I wasn't specific enough as usual:rolleyes: There are several tables (Location, Ship etc..) These feed into the main table which contains all the operations. I have modified the SQL to read as follows: SELECT Ops_Log_Table.Location, Ops_Log_Table.StartDate, Ops_Log_Table.ReferenceNumber...

I have a database containing shipping details. As part of the error checking system I am trying to write a query that will identify if a ship is incorrectly recorded in two locations on the same day. There are approx 50 ships and 60 locations all entered in one table in the following format...

Pbaldy, Many thanks.

I am calling a continous form from a combo box on another form. The code below used to warn me that there were no records and shut the form down to avoid showing a blank form. Private Sub Form_Load() If IsNull(Me.TxtUnit) Then MsgBox "There are no operations recorded for this Unit", vbOKOnly...