Search results

To all of you, thanks for devoting some of your time to help me. So I'll go and play bearing this information in mind, perhaps a query before this one so it gets evaluated first, and bring this query into the main query. Otherwise i'll have to find another way round it to achieve what I need!

Hi Galaxiom, Big John Booty Thanks for your response. I think that I may not have stated my problem very clearly! I have a table (tblSupplierNonConformances) which contains a long integer field ([Error Code] - the foreign key in a relationship to an error codes table) and the data in this...

Hi All Can anyone help me with an IIF statement that is going wrong please? In a query, I have the following IIF statement in the criteria of a long integer field: IIf([Forms]![frmSupplierNCRsReviewSelection]![fraErrorCode]=1,>0, In (1,5,6,7)) The IIF statement is getting and using the...

Thanks very much for your help. My simple requirements stem from a spreadsheet that is currently doing the job with just 7 pieces of data (TrackNo, TrackTitle, ArtistName, Genre, RecordingTitle, RecordingMedia, Date). The reason for switching to a database is because of course many pieces of...

Bit of a newbie at all this. I understand simple relationships, but some confuse me. I've looked at other posts in forums, downloaded sample databases, but not been able to find anything quite like this? I've come across this problem before, and am not sure how to resolve it.. A simple music...