Just off the top of my head; something like this might serve you better.
con_string.ConnectionString = @"Provider = Microsoft.ACE.OLEDB.12.0;Data Source =|DataDirectory|\Restaurant.accdb;Persist Security Info=False";
con_string.Open();
System.Data.IDbCommand cmd = con_string.CreateCommand() ;
cmd.CommandText = "SELECT count(column3) As [QTY] from [Total] Where [column3] like 'DineIn*' AND [Column1] <>0 AND Cancel IS NULL And [Date] Between ? AND ? Group By [column3] ";
System.Data.IDbDataParameter prm = cmd.CreateParameter() ;
prm.ParameterName = "?" ;
prm.Value = System.DateTime.Now;
cmd.Parameters.Add ( prm ) ;
prm = cmd.CreateParameter() ;
prm.ParameterName = "?" ;
prm.Value = System.DateTime.Now.AddDays(1) ;
cmd.Parameters.Add ( prm ) ;
Dinein_Orders.Text = cmd.ExecuteScalar().ToString();
con_string.Close();
I do hope you're not storing dates as strings.