Search results

I'm in London the day before, but travelling there and back in a day so I'm not there on the 29th, or I might have turned up! Have fun ;)

ignore me - I Fixed it!! Stupid me had missed out the most important bit - marked in blue ;) I've now got SELECT qryGENAttendeeBase.AttendeeID FROM qryGENAttendeeBase WHERE (qryGENAttendeeBase.CurrentAttendee=True) AND (NOT Exists (SELECT qry_Registration.AttendeeID FROM qry_Registration...

Access 2007. I have a training database which logs all our employees and which training courses they have been enrolled on (plus when they attended, etc... ) What I am trying to do is to write a query which tells me which of our current employees has NOT been enrolled on a certain course...

try replacing +CCN-1 with +Int(MIS/12) in your code.... what does that do? ... sometimes it doesn't like you referring to calculated text boxes in another calculation...

Fab - wasn't sure if I'd got the logic right to get the right answer but thought it should at least help ;)

try adding this WHERE statement to your criteria? WHERE (((yq_NonTermination.Dublet_Lagervare) Is Null)) OR (((yq_NonTermination.[Produkt slut dato])>=[q_Termination].[Produkt slut dato])) ... although that brings up a 3rd one as well....

there are a couple of ways you can do this... I tend to use a combo box to 'look up' the contract and then show the related info in an unbound text box alongside... So, as an eg: Set up a combo box based on tblContracts, making sure you include in it the info you want to show alongside. I'm...

still can't see any attachments?

you might be better using a subform to list out the quantities and locations - that way you can use the parent / child link so that it only displays info for the 'current' Product? Failing that - you need to include criteria on the record source of the list box, limiting it to only the...

Rest assured it'll be something simple ;) I'll check back next week and see how you get on!

Hmm, ok, in that case, you need to check your field names... does the field 'gender' appear in your datasheet?

Just to find where the error is.... try displaying your subform as a continuous form rather than a datasheet - does the calculation in the footer work then?

oh booger, of course, if it's a datasheet then it won't be visible... OK, in that case, add a text box control on your main form and then set the controlsource of that text box to be the text box you can't see on the datasheet, lol...... that should work!

In a word - yes ;) If you don't want it visible there, you can always refer to 'it' on the mainform rather than trying to do the calculation on the mainform, iyswim?

Me again ;) try =-Sum([Gender]="Male") Note the - before the Sum.... if you don't put that in, you'll get a negative number ;)

Here you go... left some in but mixed up the names, so you can see how it works... bear in mind I wrote this about 12 years ago and my knowledge has come on a lot since then, lol.... but it worked, at the time!

ok, bear with me while I strip the data ;)

Only just spotted this... I have an (old) database that is very close to doing what you wanted, lol.... Mine went about it in a slightly different way - basically, you 'register' someone's need to do a course, and then you Book them onto an Event... it allowed us to build a Waiting List of...

Try something like this... subsituting your own table / field names, of course... PARAMETERS [Start Date?] DateTime, [End Date?] DateTime; SELECT mytable.ContractStart, mytable.ContractEnd, DateDiff('d',IIf([ContractStart]>[Start Date?],[ContractStart],[Start Date?]),IIf([ContractEnd]>[End...

what is the data type of the base fields, and have you checked the properties of the control on the form?