Search results

  1. I

    Change format on query criteria

    It's totally work now! Thank you so much for help me! Thanks CJ_London!!!
  2. I

    Change format on query criteria

    Sorry! I am away from my desk for a while, so I can not provide the value from my table, but every data under [FSC] is either integer or empty cell, I thought you ask me the data type in my table, so sorry for the confusion, my situation is I have a table which in the right integer format, but...
  3. I

    Change format on query criteria

    [FSCtol] contain many numbers and some of empty field(null value) The error is after I run the query, all the cells under [FSCtol] gives me #Error Thanks CJ_London!
  4. I

    Change format on query criteria

    I did like: FSC:Cint([FSCtol]) in the query design field, but it returns me error in the query table, Do you mind check it for me?
  5. I

    Change format on query criteria

    Hi, I have a small question here, hope someone can solve that I use expression on the query field, but after I run it, the field change its format from number to text, can anyone tell me how to reformat on the query criteria to change the text to integer format? Thanks
  6. I

    Query from different table in one column

    Thank you, I will try your advice, Thanks a lot!!!
  7. I

    Query from different table in one column

    Thank you for reply!!! The result I want is: Year | SlowWay | FastWay 1992---125--------3779 1993---60---------3773 1994---8----------4556 For example: the number 125 in 1992 coming from the total count of walk and bike, the number 3779 in 1992 coming from the total number of vechicle, ship...
  8. I

    Query from different table in one column

    Hi all, I got a urgent situation here, Please help me out, Thanks! I have two tables, Table A: Year Type Count 1992 Walk 82 1992 Bike 43 1992 Vechicle 298 1992 Ship 3 1992 flight 3478 1993 Walk 47 1993 Bike 13 1993 Vechicle 638 1993 Ship 24 1993 flight 3111 1994 Walk 0 1994 Bike 8 1994 Vechicle...
  9. I

    export report to multiple worksheet in one excel with grouping

    Hi all, I have a report which based on a crosstab query, and I add a grouping by using the group&sort button on the design toolbar. The grouping is on one of my crosstab query row head. Now I want to export report to excel with each grouping as an individual worksheet in one excel file, which...
  10. I

    display Multiple columns pass from the multiple selection listbox to report

    Thanks, but the video only shows to make the crosstab query base on the fix column, in my case, the column will be random select from the listbox, and it could be 1,2,3 or 4 column on the form, can you help on how to achieve that? Thanks!
  11. I

    display Multiple columns pass from the multiple selection listbox to report

    the data represent the number of people in different group(children, elder....etc) visit different area by different transport from 1992 to 1999 The area, transport and group selection is from the multiple selection listbox by select the area, transport and group type, it should give me the...
  12. I

    display Multiple columns pass from the multiple selection listbox to report

    Hi dear all, can anyone gove me little help? I have two forms, one is for selection and the other one is fo display the result example of the display report form right now shows: year Area1 1993 Vehicle 5 1993 Train 6 1994 Vehicle 1 .... the Area and transport type are all passed from the...
  13. I

    display multiple fields base on selection in one page

    Hi dear all, I have a query like below Cnt Type Time 1 TypeA 20/01 1 TypeB 23/01 4 TypeE 23/01 3 TypeC 14/02 24 TypeA 25/02 564 TypeD 12/03 116 TypeE 24/03 0 TypeB 15/04 27 TypeD 25/04 And I have a multiple listbox on my form to select type If the selection from the...
  14. I

    Help with Crazy Loop and Query in VBA

    Yes! It is super complex.....and Thank you a lot for your patient and help!!!
  15. I

    Help with Crazy Loop and Query in VBA

    Of course, Thanks for your reply!!! I have table <Area>, <Species>, <CatchNum>,<weeks> my query AreaQuery1 in the code represent the selection query by user enter weeks, species and gives catchNum and primary area My <Area> table contains 6 column: the attachment is the database of my area...
  16. I

    Help with Crazy Loop and Query in VBA

    Hey guys! I almost raise my white flag with my project, I am a so bad programmer....... My code gives me bugs all the time and I hardly can fix it... Can any of you genius have a look and give me some advise or fix for me...PLEASE...THANKS..... Private Sub Zone_slc_AfterUpdate() Dim db As...
  17. I

    selection statment in VBA

    MANY Thanks!
  18. I

    selection statment in VBA

    Thanks guys, I can write the if...then...else statment, but my only concern is I want to represent two brence with the countNumber, one is when all the count number are 1, then I will have one way to deal with it; the other brence is if not all the count number are 1, then for the count...
  19. I

    selection statment in VBA

    Thanks! But can you tell me how to write it in VBA? I thought that the IIF can not be written in VBA, am I right?
  20. I

    selection statment in VBA

    Hi All, I am very stupid on VBA coding:banghead: My problem is that I have a query which count the number of target field in my table,(if the value in the column represent once, the count is 1; if the value repeat 3 times, the count value is 3), then I want to develop a case select or anything...
Top Bottom