Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: CompGirl
  • Content: Threads
  • Order by date
  1. CompGirl

    crosstab query

    my question is, is it possible to leave the fields blank while making a crosstab query.. cause it doesnt work for me... am i supposed to do it differently???
  2. CompGirl

    leaving some fields blank??

    I have a huge problem... I have a form that produces report when pressing certain action reports... the report is based on a crosstab... the thing is.. when i leave a field blank in my table the report wont open correctly... i dont understand what the problem is? am i supposed do do something else?
  3. CompGirl

    this is probably a very easy one bu

    this is probably a very easy one but i just started today with sql programming.. the thing i wanted to ask is how to set the same values in a column with one simple command... for example name grade anna 5 donna 5 albert 5 in this example... if i know that they all have...
  4. CompGirl

    hi everyone... i need to ask someth

    hi everyone... i need to ask something.. is there a way to put three crosstab querys together.. lets say ive a crosstab query that look something like this risk class severity class I II III IV a 2 1 2 3 b 8...
  5. CompGirl

    2 Me!Field, is this possible?

    hi everyone... im new at this but can someone tell me how i am supposed to write this code. It complains on this row: Me!Risker = Me!hiddenEnvi_Risk_Class And Me!hiddenPro_Risk_Class Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) Dim Re As DAO.Recordset Dim ReSum As...
  6. CompGirl

    sum my records

    hello everyone this is the code behind my report, the only thing that i want to do is to sum the IDs that pop up .. Private bContinuedSection As Boolean, sLastHeaderKey As Variant Private Function IsContinuedSection() As Boolean IsContinuedSection = bContinuedSection End Function Private Sub...
  7. CompGirl

    sum fields in crosstab query

    hi everyone... ive made a crosstab query that looks something like this: Sweden Germany Denmark A 4 2 0 B 3 C 5 1 6 D 2 2 i have a table with countries, cities, population and...
  8. CompGirl

    :( reportgenerator

    hi.. i was wondering if anyone could look at my reportgenerator and tell me whats the problem with the code ... im trying to filter some stuf but it doesnt work.. its a report generator made in access
  9. CompGirl

    no duplicates

    hi can anybody tell me what i am supposed to do if I dont want duplicates in my combo box. I dont want it to write the number twice when its already there... thx
  10. CompGirl

    three reports in one

    i have created four pages... u recieve a report through three of the pages... now i want the first page to add all the three report from the other three pages to one... is this possible?
  11. CompGirl

    7 hours with the same problem ???

    i dont know what im doing wrong.. i have a form that will print out a report after choosing options in the combo boxes... then my filtering code is like this: Option Compare Database ' Use database order for string comparisons ' Option Explicit Global RapString Sub...
  12. CompGirl

    total in side by side format on the report

    this is not a hard one... but since im new i dont know how... ive created a crosstab query, and i want the totals to be shown side by side... how can i do this... 1 2 3 4 a b c d Totals bla bla bla bla <---
  13. CompGirl

    arrays + report

    I would like to do as follow.... first i want to create an array and print it out on a report... the thing is that i want the same values to be printed out on the same place with a , between... like this salesman programmer author Anna 1,2 3 Bella 4...

Part and Inventory Search

Back
Top