Recent content by chris.leng

putting it into the query instead of calling it as a function has worked wonders, and yea, greater use of square brackets solved a fair few problems :) happy days now, lol

I'm afraid not, i'll see what i can do regards trimming down data tomorrow, how do i do a field with spaces within that dsum? (ie replace date with "delivery date"?) also what exactly is the difference between "" and [] within things? i assumed [] was field and "" was... stuff? bit confusing...

can anyone see/explain where i'm going wrong? its becoming very frustrating

first error - syntax error in: 'ijn = " and date =#' dunno where that comes from, the code still looks like what i just posted?

test 12: terriersum([wwo].[date],[wwo].[out]) Function terriersum(terdate, terijn) terriersum = DSum("qty", "ssched", "ijn > " & terijn & " And [date] > #" & terdate & "#") End Function why does that go nuts?!?

yay, failed with the whole query stopping thing and access crashed out, whys is it so bad >:( right: Function terriersum(terdate, terijn) terriersum = DSum("qty", "ssched", "ijn > '" & terijn & "' And [date] > #" & terdate & "#") End Function something about a reserved error? i'm kinda...

ok, i'll try that, also when i run the query and the function si wrong how do i stop it trying to run the broken function 5000 times? non of the normal exit stuff works now its saying undefined function, but it is, wtf? :/ - oh desgin mode seems to solve the first issue. anyway, when i think...

yea, i'd done that, but it didn't seem to accept the inputs from the query?

Ahh, thanks for the tip on searches, i tried the dsum method, i set up a functon, used 2 arguements, but had trouble making it work, code: Function sumfunction1(vardate As Date, var1 As Long) As Long DSum("field2", "table", "field1 > " & var1 & " And date > #" & vardate & "#") End function...

Hi, I'm trying to add subtotals onto my query in an additional column, The Criteria are other values from the current record and I'd like to add values from the whole query, example: very basic table with Dates and Quantites, I would like a total of all the quantites on and before the date...

it only happens on the first record of a new table. edit: oh, btw, where is the archive index? (i'm probably being slow, but i'm looking for a forum with that name)

So the northwind example uses forms to make those sublevels automatically from other tables instead of making subtables for that table? also any comment on my earlier unique identifier questions?

I've been looking at that northwind database and am starting to make sense of it, got some noobie questions though. The expand box, the little + next to the records of some tables which makes a drop down to show another sub table, how do you add those? are they a sub table? or a link which...

i had a search around, this guy http://www.allenbrowne.com/AppInventory.html seems to be talking about roughly what i want... i think? though i'd need to add some extra values to those tables he shows in that picture. where would i be able to find a database set up like this? or how would...

I currently have 2 excel spreadsheets, one is relatively stable data referring to manufacturers of parts, order numbers etc, the other is more dynamic as it records data of individual shipments to and from me The problem is I currently have to enter most data twice as it needs to go onto both...