Recent content by capdownlondon

ok problem solved: here's the code i finaly used: TRANSFORM Sum([AttendancePercentTable Query].Present) AS SumOfPresent SELECT [AttendancePercentTable Query].CompareField1 FROM [AttendancePercentTable Query] WHERE ((([AttendancePercentTable Query].CompareField1) Is Not Null) AND...

basically, there are more fields in the table. the percentags are manually input for each student for a given date (when i say date i mean a given name for a term for example, so not an ACTUAL date). what i want to be able to do is have a list of all the dates for a particular child on a form...

been driving me mad btw so it would be very much appreciated for he help. the reason i need the ifo displayed in this manner is for graphing purposes. thanks adam

I have a table that has the follwoing fields: -student name -pesent percentage -compare value 1 (a number) -compare value 2(a number) now i want a query to display the following fields as an output -Student name -Compare value -present percentage 1 -present percentage 2 so where "compare...

just to add to this it then says:

also another problem is on a form with a graph on it, and when i open it i get the error this doesn't happen when i open it on my computer, but it does at work. thanks Adam

its says MISSING: CalAdapter1.1 Type library. thanks for the help by the way.

how do i do that?

i have been developing a db at home for people to use at work. it has been going well, until more recently. most of the time when i open the db at work and i've made changes to it at home, there have been problems. all sorts of things. i will give an example of the most recent: i havean...

i have a graph, and it is based on sql to generate its values. TRANSFORM Sum(redscount2.[CountOfCard Code]) AS [SumOfCountOfCard Code] SELECT (Format([fldDate],"dd mm yy")) AS Expr1 FROM redscount2 WHERE (((redscount2.[Childs Name])<>"False")) GROUP BY (Year([fldDate])*12+Month([fldDate])-1)...

managed to work it out.

ok well, the code is: Private Sub Combo5_AfterUpdate() Me.OLEUnbound0.RowSource = TRANSFORM Sum(redscount2.[CountOfCard Code]) AS [SumOfCountOfCard Code] SELECT (Format([fldDate],"dd mm"" '""yy")) AS Expr1 FROM redscount2 WHERE (((redscount2.[Childs Name]) = "frankie graham")) GROUP BY...

im trying to paste some sql behind a combobox in vb, i wont explain it all. but basically, i know i have to have the sql in " SQL " but what do i do if the sql contains "" within itself, then it is causing problems. is there either something i can put infront of the " like \" for...

ok, basically i work in a special school for kids with behavioural difficulties. we have a system where the kids get "red cards" if they behave badly. they get different types of red cards depending on what the behaviour is, and these are recorded dailly and repressented by codes (representing...

is it possible to generate multiple graphs based on records from 1 field. like you would on a report, generating a page with information for each entry in a certain field? and any ideas on how to do this, seeing as from what i understand that graphs have to stay unbound (i may be wrong)...