Search results

Table Motor MotorID, MotorType, FuelType, Contact, Dept AutoNum, word, word, word, word Table MotorRecord MotorID, RecordDate, Amount AutoNum, Date, Num Table MotorType MotorType, FuelType, CO2 word, word, Num SELECT Motor.Dept & " " & Motor.MotorType & " " & Motor.FuelType AS Expr1...

Table RecycleRecord ItemName, RecordDate, Amount Paper, 1/7/2013, 100 Table RecycleItem ItemName, UnitInKg Paper 1 Table PaperType PaperType, KgPerUnit A4 Paper, 2.5 Table PaperUsage PaperType, RecordDate, Amount A4 Paper, 2/7/2013, 100 I want results like...

Table ElectricityUsage UserID, RecordDate, Amount AutoNum, Date, Number I create a blank report and add two text boxes with control source =[ElectricityUsage]![RecordDate] and =[ElectricityUsage]![Amount]. Even only with the two boxes, the error appears, #name Then I tried another method. Add...

[solved]how to group by academic/user-defined year This is further application on: htt p://www[dot]access-programmers[dot]co[dot]uk/forums/showthread.php?t=279458 A quicker look, here is a query: SELECT ElectricityUser.UserName, Year(ElectricityUsage.[Occurrence]) AS [Year]...

hi, all a newbie to access currently trying to develop a database