i have a table that is group by customer id. each customer have some infomration that depends on if there is any data for it or not then that line will be visbile or not.
when i export data into PDF then sometimes for the last record half of the data is in one page and the rest is going on the next page.
how can i say that if the data for each customer doesnt fit into the page then move the whole data into the next page not in two different...
voroojak
Last Activity: Oct 23 '09, 05:47 AM
Joined: Feb 23 '07
Location:
-
fit record in one page in SSRS
-
multiple checkbox in access
Hi
I have a form that there is 3 checkbox in it.
one or two or all 3 can be selected.
i want to pass the selected check box to the sql table.
the problemis when I just choose 1 checkbox then it doesnt go.
if i just choose year0 then it wont pass
'year0
If chk_year0 = True And chk_year1 = False And chk_year_2 = False Then
rst.Fields("tar get_spb_year_li st") = year0.Caption... -
Thanks alot and sorry for not be cleared. -
H again
it worked some how.
i did with check box and put the conditions whether it is checked or not. i was prefering to do it with list box but it didnt work unfortunately. i still like to know how can i do it with list box but for now it is working:)
thanks alotLeave a comment:
-
I am really sorry if i confuse you.
i try to fix it.
maybe it is better just to say that i have a table that i called campaign_data
and the column that the year should be pass is year_list. the list box name is yr_list.
what i want to have as a result is that if i select 2009 and 2010 in my list box, the value that i can see in my table be 2009 2010.
thanks alotLeave a comment:
-
HI
thanks for your answer.the thing is that i want to select multivalues from my listbox and then i can be able to show the selected values in my table. for example if i choos 2009 and 2010, then it shows in my table 2009 2010.
thanks alotLeave a comment:
-
Select Multivalues in listbox
Hi
i have a listbox that generate years. i want to be able to selct one or more years. i change the properties of multi selct to extended and i can select more than one. but the problem is that i want to pass the data in to the table in sql database and it is not passing .
i would appreciate any help.
thanks
voroojak -
HI
Thanks for quick answer
It is an excel sheet with the header. i also prefer to be in a coding in vba that i can read the file and then do the calculation.
the excel sheet has 4 columns that the first coumn is the name of the sales person. the second column is their code, the thiord column is each time they log in and log out to their system.
so for example my excel sheet is like that
alex 567 ...Leave a comment:
-
read excel file
Hi
I have an excel file and i want to use it as input file.
how can i read an excel file?
thanks
Voroojak -
Thanks
it worked. you really helped me alot.
thank youuuuuuuuuuuuu uuuuuuuuuuLeave a comment:
-
sum
i have 3 columns that i want to add them horizontally and vertically. if i just wantt o add them horizontally i can di it by adding the columns but i dont know how cani add them verticall that i can see the result all together.
something like this
A B C
name 1 100 5 23
name... -
Thanks alot, it worked. :)Leave a comment:
-
blank space
HI
i have a proble with the blank space.
i have a column for phonenumber. in phone number table each entry may have a different format.
i mean one entry can be like this 228 566 59878 and the other one can be 457748 6958 or 258 265897. what i wantto do is that i want all the number stick together and be like this 256987412557. i know that with ltrim or rtim i can remove teh space from the begining or end.
thanks... -
Hi
thanks alot for your solution. i think i understood, what to do.
thank you 100000000000000 000000000000000 00000 timesLeave a comment:
-
Duplicate value
Hi
I have a problem with duplicate values.
in my table i have some customer that have more than 1 id. i can fine them with find duplicate values. but the problem is that i want to find those customer that one of their id is started with 2233 and the other one is started with 2234.
but with "Find Duplicate Query Wizard" i will find any customer that has more than one record. i just want those customer that one of the... -
Hi
Thanks alot for your answer
let me explain it a little bit more . i hopei can explain it good.
the data that i pulled the information from is actually from IBM terminal 3270.
First I made a macro inside theapplication and copy all the pages that i wanted becaus ei had to sned so many keys. for example f6 to get this information then do somany page down and again f5f for other information and so on. after i copy...Leave a comment:
-
Hi
I am also new but if I was inswtad of you i would do something like this. u can try it may work:)
it is better to make expression.
U can use from build and then it would be much easier.
[A]+[B]+[C]+[D]
and in criteria choose the date between 1st date and 2nddate.
i hope it worksLeave a comment:
-
Hi
thanks for your reply
i do not just keep the sale report just for one week.
i meant that the sale is cumaltive for each week.
the table is some think loolk like this
run_date week_ending Sup sale_ID Sale#
10/12/2007 15/12/2007 MNA BHJ 3
10/12/2007 15/12/2007 MNA KLP 5
10/12/2007 15/12/2007 ...Leave a comment:
-
calculation
Hi
I have a problem in calculation.
i have a access table that have entry for differnt dates.
the data entry into this table is cumaltive and weekly and i hav eto get a daily report.
i mean it shows todays sell 2500$
tomorow the sell is 5600$ but actually it is 3100$
the day after 7600 but actually it is 1000$
i dont know how can i say minus today from yesterday for each record?
the... -
Hi
thanks for the solution.Leave a comment:
No activity results to display
Leave a comment: