Recent content by Jazzy007

Hi is it possible to combine text in a table when some have a space between them eg 123 456 789B would like it on the table as 123456789B without any space. I was not sure what command to use in a query to get this type of and use it for an update query if possible. Can someone help Many thanks

Hi I wonder if anyone can help i have a query that has a criteria ie a prompt for the user to fill in where they enter the start and end date. Between [Enter MDT Start Date] And [Enter MDT End Date] I have developed a report based on this query, is it possible in a text box to display the...

Hi I have 3 date fields. I am trying to work out number of days when =[FIELD1 - FIELD2 OR FIELD3] should do the calculation in field 4 NUMBER OF DAYS. but it comes up with date only. FIELD1 will always be filled, if field 2 is field then the number of days must be based on that. but if field2...

Hi I have 3 date fields. I am trying to work out number of days when =[FIELD1 - FIELD2 OR FIELD3] should do the calculation in field 4 NUMBER OF DAYS. but it comes up with date only. FIELD1 will always be filled, if field 2 is field then the number of days must be based on that. but if field2...

Hi it possible for lookup in 1 column to be dependant on the lookup on another columns depending on what is clicked in a form to make it easier brand table field 1: Number auto field 2: Drink linked to lookup table called drinks field 3...

hi I wonder if anyone can help. In Access forms I have column A and column B and Column C. Column C = Column B - Column A. Now can I have a message box/popup box displayed in column C only if the value is greater than >=14. Message saying over 14 days. if the value in Column c is less than 14...