Search results for query: *

ya i know... its just that since the question was already asked i figured, might as weel get more detail here and if it does not work ill go the the other forum... fortunatly for me it worked... the link clFlava seem to be working... thanks a lot

im sorry... i dont have that either... the only thing i have that might be similar is application.currentdb but it does not support the path property. it is kinda weird... are u sure you are in access 97 ?

i think i have the same kind of problem... although i cant use the solution for two reasons : 1) i dont want to use the acces path, i need to use the currentdb directory. 2) the application.path property does not seem to be available... (so not working in access) thanks

ok i got it i had to make group on interval ! dont ask me why, i have no idea !

it was a good idea but it does not change anything

i am not sur to understand what you mean... it is pretty difficult to print "blank" since it is blank ! what would you want to be printed ?

i actually finally understood what my problem was... after i displayed the monthid, i understood that the sorting wasnot made correctly : instead of doing 1,2,3,4...12. it would do 1,11,12,2,3,4... this field is seen as if it was a text field eventhoug in the table it is an integer. so i had to...

alright thanks

as i said, i have no problem sorting the data itself. it's only when the report is displayed that the months are not sorted correctly. i want to know if theres a way to sort the order of appearance of GROUP HEADERs in a report, because obviously, if it was simple data, it would have been sorted...

well i didnt provide some because of the description i gave but things always seem obvious to someone who knows what he's talking about. Sorry about that the first two columns are month_id (primary key) from 1 to 12 (integer) month_desc from april to march (text) month_id month_desc 1...

Hi, i have a report that contains a groupe header. this header contains the months of the year. problem is, when you create a new group header, you need to specify a sort order (ascending or descending). but months are not sorted in alphabetical order. furthermore, i have to display the months...

WOUHOU!!!!! thanks !

hey great... i found the solution myself... i just need to make a new field in my report that makes a count of the fields i want to know. in the properties of this field, i only specify, in the running sum : "over group" and it calculates the total... thanks to me !!! ;)

in the design view. you need to put an input mask or in the code, textbox.inputmask = "9999;;_" ;)

i know you said the customers pc, but have u check the time zone ? make sure you are using the same time zones.

oups sorry... i did not look well... i had not seen that the amount from last year was in the same table ! sorry

you would need the table that contains last years amounts. but i guess it would be something like : SELECT Table1.date, table1.item, table1.amout, table2.amount from table1, table2 where table1.date = table2.date and table1.item = table2.item; where table 2 contains last years amount ciao !;-)

hey guys, i have been asking a lot of questions lately but i really need to finish this app quick !!! i have a crosstab query that has 4 column headings (fixed) when executing my query, i get a certain number of query that might or might not have values in some of the 4 columns. what i want...

well i found the way... i declared the fixed columns in the columnheading properties... thanks anyways ! :-P

hi, i have a crosstab query that generates up to 4 different columns depending on the query's result. the problem is, since these columns are not always there, i cant make a report with all four fields. cause then if one of them is not returned by the query, then i get a error message or the...