29. november 2004 - 09:59
Der er
53 kommentarer og1 løsning
Problem med Overløb i forespøgsel
Jeg har et problem med forespørgsel. Den giver en fejlmeddelse : OVERLØB. ?
Annonceindlæg tema
Cloud & AI
I dette særtema ser vi på, hvordan cloud og AI bliver fundamentet for virksomhedernes digitale forretning, og hvordan de nye muligheder for automatisering og forretningsværdi kan udnyttes uden at miste overblik, sikkerhed og menneskelig kontrol.
29. november 2004 - 10:04 #1
cant remember seeing such an error before, any chance of seeing your database?
29. november 2004 - 10:06 #2
Kan vi se datagrundlaget fra tabellen ... jeg har ikke kunnet genskabe fejlen
29. november 2004 - 10:07 #3
The calculated field seems rather complex, is it possible to make th ecalculation another way?
29. november 2004 - 10:07 #4
DB has been sent
29. november 2004 - 10:08 #5
måske har jeg fejlen i mine tabeller.. ?
29. november 2004 - 10:08 #6
DB er sendt til Terry.
29. november 2004 - 10:09 #7
[levetid] hvad er det for en værdi ( heltal ?? )
29. november 2004 - 10:09 #8
forespørgsel hedder "Rap0001 Købsværdi af legeredskaber"
29. november 2004 - 10:11 #9
[levetid] er TAL , Langt heltal
29. november 2004 - 10:12 #10
sorry you need to remove NOSPAM from the email!
29. november 2004 - 10:13 #11
Uden at have set databasen, tror jeg fejlen ligger i tabellen c",)
29. november 2004 - 10:15 #12
done.
29. november 2004 - 10:17 #13
til jensen363.
29. november 2004 - 10:18 #14
I have a feeling its in the table too, but I may be able to shed some more light on the problem after looking at the dB
29. november 2004 - 10:20 #15
Det kan være begge, men sandsynligvis er det dato-feltet som skaber probæemet
29. november 2004 - 10:22 #16
well I get an error "Function is not available in query ...." Are you using Access 2003 by any chance?
29. november 2004 - 10:23 #17
Jeg bruger access 2002
29. november 2004 - 10:24 #18
In 2003 I get "Overflow" :o(
29. november 2004 - 10:24 #19
Prøv at sende til : ose@post.dk
29. november 2004 - 10:25 #20
strange you get this error in 2002!
29. november 2004 - 10:25 #21
Hvad er det så lige der skaber det her overflow ?
29. november 2004 - 10:26 #22
OBS ! den skal zipper før jeg kan modtage den
29. november 2004 - 10:26 #23
DB sendt til ose@post.dk
29. november 2004 - 10:27 #24
DB er sendt i .rar
29. november 2004 - 10:31 #25
Sorry, har kun winzip
29. november 2004 - 10:33 #26
DB er sendt til Jensen363 i .zip
29. november 2004 - 10:34 #27
as far as I can see the data is OK, so Ithink it is your query (sum) which is too complex. I'll see if I can break it down
29. november 2004 - 10:36 #28
The query has work before, but with less data in the tables, so it very well be the problem...
29. november 2004 - 10:39 #29
Jeg kan slet ikke åbne den, men jeg har desværre også kun Access 2000 ( så ikke lige at det var 2002 ) .... sorry
29. november 2004 - 10:43 #30
I am 99.99% sure that the problem is NOT your data!
29. november 2004 - 10:44 #31
okay, that nice to know...
29. november 2004 - 10:46 #32
This small part of the calculated field gives an error
29. november 2004 - 10:48 #33
I Access 2000 kan fejlen ikke genskabes med det datasæt jeg har benyttet
29. november 2004 - 10:48 #34
I'm not getting the same error as you so it isnt easy, but I think you need to try and break your calcualte field into smaller parts. Maybe make a query without GROUP/SUM to set the field to 0 if its < 0 (which I think is waht you are doing) Then make your GROUP/SUM query
29. november 2004 - 10:49 #35
jeg tror at mændgen af data er afgørende for afviklingen. Det har nemlig virket før med mindre data i tabellerne.
29. november 2004 - 10:51 #36
okay Terry. I'll try that. Thanks for your suggestion. Please post an answer to get points.
29. november 2004 - 10:52 #37
Year(Date()) isnt allowed in Expression!
29. november 2004 - 10:53 #38
how come it's been working before....
29. november 2004 - 10:55 #39
Year(Date()) works in Access 2000
29. november 2004 - 10:55 #40
change year(date()) to year(now())
29. november 2004 - 10:56 #41
when I do this it works :o)
29. november 2004 - 10:58 #42
Jeg får stadig en fejl "change year(date()) to year(now())" OVERLØB....
29. november 2004 - 11:00 #43
wait!
29. november 2004 - 11:00 #44
Thats really weird we are useing the same DATA. Are you using 2002 2003 access version.
29. november 2004 - 11:01 #45
Maybe its just me who has a problem with year(date()) dont see why that shouldnt work.
29. november 2004 - 11:02 #46
Great. Thanks man it was the ID 282 that made the Error. It works....
29. november 2004 - 11:02 #47
Could any of you convert to 2000 and sent it to me ....
29. november 2004 - 11:02 #48
and give some points to jensen363 too :o)
29. november 2004 - 11:03 #49
Terry > No need ...
29. november 2004 - 11:04 #50
Ja jensen363 tak din deltagelse jeg sender dig DB i 2000 access. zip
29. november 2004 - 11:05 #51
I'm off, should have been laying tiles hours ago, and they have to be finished before the wife comes home, or I'm in deep shi. :o)
29. november 2004 - 11:07 #52
Terry > better watch out ... i have the same problem with my wife ...
29. november 2004 - 11:07 #53
well bye then....
29. november 2004 - 11:11 #54
Ingen problemer med at afvikle forespørgslen i Access 2000 ... men der havde du jo også fjernet ID 282 ... c",)
Dyk ned i databasernes verden på et af vores praksisnære Access-kurser
