Recent content by CazB

  1. C

    Ignore Wildcard if Criteria is Blank

    Try this format for your WHERE? WHERE (((IIf(Not IsNull[Forms]![SearchJobs]![SearchAddressLine1]),SiteDetails.SiteDetailsAddressLine1 Like "*" & [Forms]![SearchJobs]![SearchAddressLine1] & "*",-1))=True) Basically it says: if searchaddressline1 is blank, ignore it, otherwise match it ;)
  2. C

    Show in a listbox a query filtered by 2 or more textboxes

    hmm, ok, I see your problem! In actual use, would all the fields be unbound like this?
  3. C

    Show in a listbox a query filtered by 2 or more textboxes

    can you post up a (zipped) sample of what you're trying to achieve?
  4. C

    Show in a listbox a query filtered by 2 or more textboxes

    How do you want the criteria to work? should it match either one or the other, or should it match both?
  5. C

    help - total max working how to get other data

    might not be the 'best' solution, but this should work.... Use 2 queries: in the first one, just pull out the Product Number and date last sold Query1: SELECT SMKPLUDetail.[Product No], Max(SMKPLUDetail.[Date Last Sold]) AS [Last Sold] FROM SMKPLUDetail GROUP BY SMKPLUDetail.[Product...
  6. C

    Saving form data help!!

    do a search on this forum for Cascading Comboboxes there's lots of info out there :)
  7. C

    MVF vs Lookup Fields vs Multiple Tables [Noob]

    sounds like you have a couple of many-to-many relationships there, so you'll probably be best off using linking tables to build the relationships you need... have a look here http://www.databasedev.co.uk/many_to_many_example.html to see how that can work....
  8. C

    LEN function

    sorry, yes... forgot that! serves me right for answering whilst also being on the phone... thanks for pointing out my schoolgirl error, lol....
  9. C

    LEN function

    Sorry if this doesn't make sense, but: if you are using Nz (expression, 0) then the length will never be 0, will it? If the 'expression' is blank, won't it put in 0 anyway, which means the length will be 1? so If Len(rst![Kolory P]) <> 0 Then przod = True End If etc
  10. C

    IIf with two true values

    Just put your "if they're alive' criteria around the other ifs.... using my example above: =iif(status="alive";IIf(Weekday([yourdate];0) Between 1 And 5;"X";IIf(Weekday([yourdate];0)<=7;"Y";Null));Null)
  11. C

    Dlookup help needed!

    could be I got some field / table / query names wrong... check those?
  12. C

    IIf with two true values

    so in Danish, it would be =IIf(Weekday([yourdate];0) Between 1 And 5;"X";IIf(Weekday([yourdate];0)<=7;"Y";Null)) or =IIf(isnull(yourdate);null;iif(Weekday([yourdate];0) Between 1 And 5;"X";"Y")) ? weird ;)
  13. C

    Dlookup help needed!

    If you are using a form to put the person's name in, and the query you are wanting to lookup the TimesMissing is not the recordsource for the form, then you could try this, in an unbound textbox on your form? =DLookUp("[CountOfName of YP]","TimesMissing","[Name of YP]=" &...
  14. C

    IIf with two true values

    Is this in a function, or in a query? IN a query, this should work..... =IIf(Weekday([yourdate],0) Between 1 And 5,"X",IIf(Weekday([yourdate],0)<=7,"Y",Null)) OR =IIf(isnull(yourdate),null,iif(Weekday([yourdate],0) Between 1 And 5,"X","Y")) should work similarly in a function?
  15. C

    Outer Join Problem

    plog... I was asking the OP if that's what they were after, based on the data supplied... not trying to answer your question ;)
See more
Top Bottom