Search results

I have 3 tables. One table has a whole load of data: (table 1) date, name, company name, building Name, etc I have one other table which holds company names (table 2) I have one other table which holds Building Names (table 3) The main table is linked to the other tables so in the company...

Wondering if anybody has any information about this. Backgound information: My access database information comes from a 'card' where somebody has manually put crosses in a number of boxes. This information is currently being manually inputted into the database... I know you can get scanners to...

I have a statement which is driving me nuts...i'm a beginner with using SQL: Private Sub Command45_Click() Me.Graph0.RowSource = "SELECT (Format([Date],""" """mmm""" ''yy')) AS Expr1 FROM Chart_Unsafe_Daily GROUP BY (Format([Date],'mmm'' '''yy")), (Year([Date])*12+Month([Date])-1); End Sub...

I have a report with has a graph. I also have a form which has two date entry fields, date to: and date from: These two dates are used to display all the groups of data which lies between the two dates. in more detail: What i have just now, correctly shows all the data which lies between the...

Hi there, I have a problem where the option buttons within a form are creating a "-1" in the Table instead of a "+1" The reason this is a problem is because i am using a COUNT query which obviously gives me a negative total, such as "-23" instead of "+23" I would really like the option...