Recent content by JeremyH

Thank you for your input. :)

Fixed the coded string works. Thanks you so much.

it displays #Name? Maybe I should concatenate the fields in a macro? I want to use the concatenated string in my email subject line when I use the SendObject command Apologies for the fragment bits of info (multi-tasking day is not working for me today)

on my SO_Main Query SOCusPO: "Job No. " & [SO_ID] & ", Customer " & [CUSTOMER] & ", PO No. " & [PURCHASE ORDER] Result in Query table: Job No. 74018, Customer INHEP ELECTRONICS HOLDINGS (PTY) LTD, PO No. 12345 But it is still not displaying in the form correctly

Hi all... I have been struggling to get a text box to display the correct concatenated string of data Form Fields: SO_ID - for my job number from my SO_Main table Customer - Customer Name from my customer table Purchase Order - PO number. I have concatenated these fields in my SO_Main query...

. The field formats is definitely my problem that i need to correct. I have a table of pre-selectable time slots in 10 minute increments. Hopefully by removing this it will fix the problem

Thank you for your comments it is noted.

Thank you for your reply... Dividing by 144 will give me the result that i am looking for. Could it possibly be the input field formats that i need to correct??? not sure now

Hi All, I'm very new to this site... and a bit familiar with Access basic tables and queries. I have read through some of the threads pertaining to time duration calculations. the "DateDiif" function works quite nicely but its not giving me the result that i need. "=DateDiff("n",[Time...