Search results

Possible yes!

Still getting #error...know why?

This errors out... #Error. Data Example: Could be: AD,DLY, or Could be: ADD,DL I need the characters before the first comma. Help please...

I have a form that pulls up "hot" shipments that need immediate attention. I would like for the user to be able to click on a piece of the information and populate the form that host all of the master data. So when a user enters access, they get a msg box that says...you have hot shipments...

This is from a .csv file. I would like to strip the characters. something like But I keep getting an error. I did it to a field like this. MAWB: 16061279455(HKHKG-USATL) Left([MAWB],Instr(1,[MAWB],"(")-1) How can I do it for this one... AD, PAR?

Some are two characters...i.e. Delay Codes are i.e. (AD, PAR, etc) some may have two delay codes. i,e, AD, PAR but I only need to show the first. Thoughts

I have a query that I would only like to see certain data in a field. FieldDLY: PAR, UNA I only want to see PAR and not UNA. Help

Can someone please look at my code and tell me why the value will not return to my form (RDL) there is a command button in Form tblMasterData. I cannnot get it to return a value. Also would like to set date to today's date when the calendar pulls up. Please help, I have attached the database.

I have three data fields in my form. Shipped Date, Delivered Date and Turn Around Time. I need to calculate the Shipped Date and Delivered Date and populate it in the TAT field.

Thanks, that worked.

No, I am trying to send form information. Take several pieces from a form to input into an email.

Trying to send a email through a command button. I get the email correctly, however I would like the form data in the subject line. Can you please help? Here is the code I have so far...this works to pull up an email, but I need the form data. The table the form is built from is tbl_Master...

This wants me to put in parameters...for example. Enter Pick up date and enter COB date. I already have the Pickup Date. I need to validate that if the COB field is null and pickup date is greater than or = to 48 hours of the system date...show on the report.

Sorry, I am losing it today. I have a Picked up date, and if it has not cleared customs and the field is null and 48 hours past the system date then I need to report it.

I need to perform a calculation in my query that is the field is null and the system date is greater than or = to 48 hours to appear on my report. Does this help?

Have a field called COB (Cleared on-board). If this is blank and system date is greater than or = to 48 hours...I need to this appear on my report. Condition Please help.

Question? Where do I put the select statement?

Attached is the table structure Two tabs with my data elements in the attached spreadsheet. I need all the information from both files into one table/query. Again, the constants are master waybill and house waybill.

Reply Simple match, sorry should have used a better term Simple one-to-one query. When I do this, it pulls back 5x the amount of records. I have two tables that I need the data pulled back for both and the unique fields are MAster waybill and house waybill. Thoughts?

Trying to merge two data tables. I have two unique fields. Master Waybill and House Waybill. These will be the same across both files. When I do a simple match, I get back over 100K records. This is 5x the amount of data I have in my tables. Tbl1 = 21178 records Tbl2 = 18981 records...