Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. dridgeway

    Help with Instr() function

    I ended up doing this: ((InStr(" & strFreight & ",format([DPL].[PRECOL3RD],'!@@@')))>0 Or (InStr(" & strFreight & ",format([DPL].[PRECOL3RD],'!@@@'))) Is Null) StrFreight is just an entry box on a form - but works with miltiples now with commas Thank you
  2. dridgeway

    Help with Instr() function

    I need the user to be able to select multiples, P & PA, or P & C, C & PA....etc.
  3. dridgeway

    Help with Instr() function

    I have a parameter query that prompts: [Enter Freight Terms] User needs to be able to enter single or multiple values (seperated by commas) Freight Terms is a 3 character field with only 3 different values: P, PA & C - however if I enter PA, I receive all the P's and the PA's...how can I avoid...
  4. dridgeway

    PROBLEM - INSTR FUNCTION

    My Field [DPL].[PRECOL3RD] is a 3 digit field, strFreight is a text box in a form (for entry)...are you suggesting simply turning them around like this: ((InStr([DPL].[PRECOL3RD]," & strFreight & ")) > 0 Or (InStr([DPL].[PRECOL3RD]," & strFreight & ")) Is Null) From my form, I'm asking the...
  5. dridgeway

    PROBLEM - INSTR FUNCTION

    The following works great in my parameter query - as long as I don't try to find 2 or more characters. Example: If I enter the letter "C", all is fine and I get all C's returned (because only 1 C string will ever be populated in the field), however, If I enter PA in the parameter query...I...
  6. dridgeway

    COMPLICATED QUERY PROBLEM

    Could be unlimited number of codes per load Could also have same code twice but with different amounts. I've grouped by Load in my Report - but it's reporting the amounts twice.
  7. dridgeway

    COMPLICATED QUERY PROBLEM

    Not quite - Need: Load Code Amount Code2 Amount2 12345 ABC 25.00 XYZ 50.00
  8. dridgeway

    COMPLICATED QUERY PROBLEM

    2 LINKED TABLES - I CANNOT CHANGE THE TABLES Table=LOADS Key Field= LOAD one record per LOAD Table=CHARGES Key FIeld = LOAD many records per LOAD Example of CHARGES table: LOAD CODE AMOUNT 12345 ABC 25.00 12345 XYZ 50.00 I have my relation set between these 2 tables - but...
  9. dridgeway

    RELATION PROBLEM

    TABLE A HAS A FIELD I'LL CALL "CHARGES" TABLE B HAS MANY RECORDS THAT MAKE UP THE TOTAL IN TABLE A CHARGES (USES CODES, BUT COULD HAVE SAME CODE DIFFERENT DOLLAR AMOUNT) HOW CAN I RUN A QUERY TO SEPERATE OUT EACH CODE'S CHARGES TYPE WITHOUT DUPLICATING INFORMATION IN THE REST OF THE QUERY?
  10. dridgeway

    CDate ...Between.....Data Type Mismatch

    My data field "pdate" is a NON-DATE field in a linked table that I cannot change. This query works PERFECTLY unless there is a blank "pdate" field. Can anyone help? PARAMETERS [Start] DateTime, [End] DateTime; SELECT CDate(Nz([pDate],'01/01/1900')) AS PICKDATE FROM dpl WHERE...
  11. dridgeway

    DATE PARAMETER QUESTION

    mpastore, here's what i ended up doing and it works fine. PARAMETERS [S] DateTime, [E] DateTime; SELECT DPADV.PICKUP, IIf([DATE]=' / / ',CDate('01/01/1980'),CDate([DATE])) AS AdvDate FROM DPADV WHERE (((IIf([DATE]=' / / ',CDate('01/01/1980'),CDate([DATE]))) Between [S] And [E])) ORDER...
  12. dridgeway

    DATE PARAMETER QUESTION

    Darn, that gives me "This expression is typed incorrectly, or is too complex to be evaluated." I copied and pasted from your reply and double checked the syntax and it appears good.
  13. dridgeway

    DATE PARAMETER QUESTION

    SELECT DPADV.PICKUP, DPADV.DATE FROM DPADV WHERE (((DPADV.DATE) Between CDate([Start]) And CDate([End])));
  14. dridgeway

    DATE PARAMETER QUESTION

    mpastore, I'm so much closer now, thank you, however, when I enter for instance 02/02/03 - 04/02/03 i get just those months and days, but it returns all years....00, 01, 02, 03.... I've also tried inputting 2003 to no avail.
  15. dridgeway

    DATE PARAMETER QUESTION

    example is: 06/03/03
  16. dridgeway

    DATE PARAMETER QUESTION

    I have: Field: DATE (Text, not date) Table: DPADV Between [Start] and [End] I cannot get it to query the data range I enter, it pulls everything. I'm linking to a table, not importing

Part and Inventory Search

Back
Top