Search results

  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 ;)
  16. C

    Outer Join Problem

    In the spreadsheet you attached, the link between the formats table and the National table has to be made on the 'wrong' field as the National table has the description in it rather than the ID for the format... but I built that query like below: SELECT tblTrafficFormat.Format...
  17. C

    Outer Join Problem

    something like this?
  18. C

    Prevent duplicate entries of a field on an input form

    to look for duplicates... create a query based on your table, group by the PO Number and count the number of records.... look for any where the count is >1
  19. C

    Outer Join Problem

    I think the problem is you've got the join the wrong where round... it should be FROM tblTrafficNational LEFT JOIN tblTrafficFormat rather than FROM tblTrafficFormat LEFT JOIN tblTrafficNational
  20. C

    How to create an ID # based on number of recored

    I use this code on a form I have... it should work if you just use your table and field names instead - I already had some records in my table before I started this so I didn't need to check first to make sure if there was a number to start from, iyswim Private Sub Form_BeforeUpdate(Cancel...
Top Bottom