Search results

I have a cross query which works well, it is: TRANSFORM Sum(t.stockqty) AS sumofstockqty SELECT t.pncode, t.unit FROM [SELECT querystock.pncode, querystock.unit, querystock.stockDate, querystock.PO, querystock.stockqty FROM querystock UNION ALL select 'Total' as pncode,null as...

thanks for all the help from this forum! I have solved the problem, and the idea is from the replies of the teachers here.

still waiting for help......:(

James, it doesn't work neither. actually I 've worked on this for over 10 hours. [sdate] is only a variant the table don't have this field.

I know it should be 'sdate', and I've tried, but there's no reaction at all; I checked sdate=20100607; why you say it is 5 characters?

thanks for your help. what would be the correct expression then?

After a textbox ("Name") I need a serial number in my form, so I write the following on the afterUpdate event of name: ************* Dim sdate As String Dim sNum As Integer sdate = Format(Date, "yyyymmdd") sNum = DMax("mid([dtjm],3,3)", "aa", "Right([dtjm],8)= sdate") If...