Search results for query: *

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

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

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...

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...

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...

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.

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

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...

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?

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...

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...

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.

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

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.

example is: 06/03/03

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