Search results for query: *

The S: to refer to the drive where the DB is located dropped off a few messages back, shouldn't this be required ? Regards Warwick

Do you have the actual SQL as the form's record source? If so you can have the code in a (saved) query & use the query as the record source. Hope this helps. Regards Warwick

I don't think he is after distinct. From " training01 5/12/03 training01 5/12/02 training01 5/12/03 training02 5/12/03 " "training01 5/12/03" is repeated so I think he wants the duplicates for some reason. Vanleurth what do you want ? Regards Warwick

I am not totally sure what you are getting at but are you saying that you get a "funny" order when you produce the report? If so this may be related to the sort on your times field will be a text sort not a numeric one. Regards Warwick

Use the following ="c" & Right(CStr(DatePart("yyyy",Date())),2) Hope this helps. Regards Warwick

Yes in the report query criteria use Forms![YourForm]![YourField] Hope this helps. Regards Warwick

Try dragging the individual reports onto a "container" report (Subreports). When displayed they will all be there in one window. Hope this is of use. Regards Warwick

Use each report's OnNoData event to trap them instead of in the code. Alternatively you could pull a recordset (ADO or DAO) prior to calling the reports to see if there is no data. Hope this is of help. Regards Warwick

This should be OK, normally. It is Blank on the report, not an error message? BTW to state the obvious 1. The Visible property is set to true ? 2. It's not white text on a white background (or something similar)? 3. The text box doesn't have the same name as the field ? 4. It is not hidden...

What I meant is design a form to do the booking as per Jeff's design but give yourself the extra information required (Free Rooms, existing bookings) by designing a couple of subforms which can be inserted into the main form. Regards Warwick

If all you need is to see the other information why not put that on two subforms on the main form & apply the rest of Jeff's design? Regards Warwick

Humble.. is correct IF you don't have 255 controls on the report. If you do the limit does apply but I would suggest that if it has 255 controls then it may be a bit complicated. Regards Warwick

is null or >01/01/2000 should work. Regards Warwick

I have not tried this so it is just a thought. You could try setting their height to a negligible amount & then making sure "Can Grow" is set to yes. In this way the second row should occupy minimum space when not populated. Hope this helps. Regards Warwick

You can also output to PDF if you have the PDF writer. Almost every PC in the world has Acrobat Viewer. Regards Warwick

You have two options 1. Intead of importing the XL you can link to it. Then when the new SS come in you can rename it to the linked name & that will be available in Access. It would probably be best to have a query to move the data from the linked XL SS to a native access table as although you...

If I understand what you are getting at. Pull a line as your data source equating to each action, including the individual's details sorted by Individual & then action. On the report group by Individual with section headers & footers. This should give you what you are after. Regards Warwick

If your IIF statement didn't work then try nesting them. i.e. Iif(condition1,iif(condition2,Result,null),null) Hope this helps. Regards Warwick

With the immediate if statements you can nest them i.e. " =Iif([Customer add 2] is null, Fields 1,5 and 6 ,Iif([cust add 3] is null,fields 1,2,5 and 6,iif([Cust add 4] is null,fields 1,2,3,5 and 6,))) " Hope this helps. Regards Warwick

This was not precisely what you asked for (but I think it is better because the order is correct. TRANSFORM Sum(MGIAllCombined.fin_debtor_amount) AS SumOffin_debtor_amount SELECT MGIAllCombined.mat_number, Sum(MGIAllCombined.fin_debtor_amount) AS [Total Of fin_debtor_amount] FROM MGIAllCombined...