Recent content by ChimpZter

Thanks, not sure what you mean by the second para there but the first bit has done the trick - I have learnt something new today!!:D Just for the record this worked.... SELECT [Equipment], [NextSchedDate] AS [ServiceDate] FROM [myTable] WHERE [NextSchedDate] >= #04/01/2010# and...

okay cokey thanks, well would this work .... SELECT [Equipment],[ServiceDate1] as [Equipment],[ServiceDate] FROM [MyTable] UNION SELECT [Equipment],[ServiceDate2] as [Equipment],[ServiceDate] FROM [MyTable] UNION SELECT [Equipment],[ServiceDate3] as [Equipment],[ServiceDate] FROM [MyTable]

Just need to clarify - I agree with what you are saying I just need to get the data in that format! It has worked out that way because I am using data from elsewhere and I added the service frequency (days) to the last scheduled date so I could project forward when the next services would be due...

Hi, I have a table with equipment in the first column and their maintenance dates in the subsequent 3 columns serviceDate, 2 and 3 How do I transform this table from 4 columns into just 2 columns; i.e. equipment and serviceDate only, obviously equipment names will be repeated in the first...

reason I am working toward using a DLookup but I notice every value I select in an unbound comboxbox just repeats in all the others - I might try and avoid doing this instead!

try this The relationships are correct, when you build your form with form wizard base it on the surgeryschedule table and select all the fields. Then select the recipeients and surgeons tables and select all fields in each except the primary keys. Now accept the table and press 'Finish' With...

On continous forms I have an unbound combo box. When I select the top record the other combo boxes update as well - how can I disassociate them? thanks John

Thanks for that

I have a had a quick look and I am not sure what you are after but I think you need to use subforms so that when surgeonID is selected the other fields complete automatically - use the FormWizard and add all the fields you need and it should recognise the grouping for you.

Hi I have a form with a comboBox, the user selects a value and I wish to update a field on a filtered form with the following SQL statement: "SELECT tbl_ServiceIntervals.[275to400] " & _ "FROM tbl_ServiceIntervals " & _ "WHERE (((tbl_ServiceIntervals.[Style/Spec])=""930""))" it will only ever...