B brucey54 Registered User. Local time Today, 10:54 Joined Jun 18, 2012 Messages 155 Dec 5, 2014 #1 Hi folks, quick question I have textbox on a form. I also have a query that displays a date, I would like this date to be displayed within the textbox, not sure how to do this, thanks in advance.
Hi folks, quick question I have textbox on a form. I also have a query that displays a date, I would like this date to be displayed within the textbox, not sure how to do this, thanks in advance.
B brucey54 Registered User. Local time Today, 10:54 Joined Jun 18, 2012 Messages 155 Dec 5, 2014 #2 This is the code I have so far, tying to find the max date =DCount("[MealDate]","Qry_2_DateNewPatients"='MAX' not working
This is the code I have so far, tying to find the max date =DCount("[MealDate]","Qry_2_DateNewPatients"='MAX' not working
B brucey54 Registered User. Local time Today, 10:54 Joined Jun 18, 2012 Messages 155 Dec 5, 2014 #3 Code still not working =DCount("[MealDate]","Qry_2_DateNewPatients"='DMAX')
B brucey54 Registered User. Local time Today, 10:54 Joined Jun 18, 2012 Messages 155 Dec 5, 2014 #4 Code still not working =DCount("*","Qry_2_DateNewPatients","[MealDate] = " & Format([txtCusDate],"\#dd\/mm\/yyyy\#"))
Code still not working =DCount("*","Qry_2_DateNewPatients","[MealDate] = " & Format([txtCusDate],"\#dd\/mm\/yyyy\#"))
B brucey54 Registered User. Local time Today, 10:54 Joined Jun 18, 2012 Messages 155 Dec 5, 2014 #5 it's ok folks got it to work =DLookUp("[MealDate]","Qry_2_DateNewPatients")
