Search results for query: *

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

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

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

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