Search results

Thanks Tera, works a treat - once I'd figured out what a Module was and how to add one 🤔

Thanks guys for quick responses, Please forgive my ignorance but where do i put the code ?

Hi everyone, Need a bit of help here due to my lack of knowledge. Have a table that has fields DelUser & DelUserTime along with other fields. My intension is to use the fields as a "Time Stamp" of when the particular record was created or modified. I wish the system to auto populate these...

Yes, we sorted out the tabulation but I could not work out how to get the time data shown. In my first post on that thread I show a image of the tabulated data with colours on the delivery numbers - those colours indicate a particular time the delivery is required. At present on my reports I...

Thanks, do you remember a few weeks ago you helped me with a cross tab query to get delivery numbers in columns with the date as the column headers ? Just wonderd if you had had any thought as to how I could get extra data into that report. I would like to get delivery time and customer name...

Thats it, thanks very much.

Does this look correct ? SELECT TabDELDetail.DelDate, TabDELDetail.DelCustomer, TabDELDetail.DelSO, TabDELDetail.DelWhere, TabDELDetail.DelTime, TabDELDetail.DelTF, TabDELDetail.DelNotes, TabDELDetail.DelID FROM TabDELDetail WHERE (((TabDELDetail.DelDate) Between Date() And...

No Nulls, all date filed populated with correct dates

DBG, think in hindsight your code would be a better fit. However I cant get it to work, perhaps I have it in the wrong place ? I have put it in the Criteria of the query for the field DelDate but keep getting the errror "Data type mismatch in criteria expression" should I be replacing part of...

Thanks all, used Bobs with >= so as it included today

Hi, I have a query in place that pulls delivery dates from a table. The current query pulls the whole week by using Field : DatePart("ww",[DelDate]) Criteria : DatePart("ww",Date()) and Field : Year([DelDate]) Crireria : Year(date()) I would like to be able to pull only the deliveries for the...

Thanks, I'll have a play

Hi did you managed to get any time to look at the conditional formatting ?

No worries, thanks

Hi would it be possible to pull across to the xtabDBG query fields DelWhere and DelTime ? At present I can not get the conditional formatting to work due to the time not being available, the DelWhere would also be useful.

Think i undersdtand the basics. Thanks again

Well done thats it exactly 👏👏 A brief explanation would help me understand the extra queries that I see. Thanks again Smudger

ok

Nearly, I think I may have confused as the key does not need to be visible. I hope to apply conditional formating to the listed s/o numbers to indicated their respective delivery times. See earlier Pic 2 - again pleae ignore the Key colomn. I just need the s/o numbers in vertical colomns with...

Lets see if that worked, see attached