Recent content by kita__n

  1. K

    Can't figure it out

    are u bored and trying to waste your time as well as others!? OK the answer isn't there...what is your problem sir..you can very well ignore it!
  2. K

    Can't figure it out

    Thanks for the complement RICH the websit that i provided does the same damn thing....it gives you exaples with reports and its functions dear !
  3. K

    Can't figure it out

    try this website as well...
  4. K

    Printing Forms

    this might work! In the Command Button Wizard, choose the category> RECORD OPERATION, then the action PRINT RECORD. This will print only the the first page of the form!
  5. K

    count problem again!!!!

    hmm.... I tried to make the reports using the queries....but it does not allow me to use anyother query along with the Count query! is there a way to solve this?
  6. K

    count problem again!!!!

    yup you were right! It wont let me count the fields in the same query so I guess I will just run it seperately....I was hoping that it would let me make a report with pulling both the queries but that dint work either so this is it a sepearate query for count! Thanks a bunch!
  7. K

    count problem again!!!!

    Sorry folks have asked this question before but I could not solve it the right way so will appreciate some more solutions! SELECT Count([Work Orders By Today's Date].[WorkOrder#]) AS [CountOfWorkOrder#], [Work Orders By Today's Date].Craft, [Work Orders By Today's Date].Description, [Work...
  8. K

    problem with count!

    hmmm....:( would u tell me how to do that!! can't figure out how:confused:
  9. K

    problem with count!

    help help! well....now it is giving me all 1's. It dosen't increment with every work order I enter! what should I do?
  10. K

    problem with count!

    WORKS Thanks a bunch.....it works just the way I wanted it to !! Great:)
  11. K

    problem with count!

    problem with count! another prob! I have a query which sorts all the "Work Order for today's date" SELECT WorkOrder.[WorkOrder#], WorkOrder.Craft, WorkOrder.Description, WorkOrder.Zone, WorkOrder.Building, WorkOrder.[Room#], WorkOrder.TypeOfRequest, WorkOrder.Priority FROM WorkOrder WHERE...
  12. K

    help me fix this SQL query!

    ThankYou All Thanks a bunch got my problem fixed....and will make sure that i check the typo's little more carefully next time:rolleyes:
  13. K

    help me fix this SQL query!

    hi DOC and RV I tried both of your solutions and both times it gives me an error "syntax error" These are the two eg: (DOC'S SUGGESTION) SELECT WorkOrder.[WorkOrder#], WorkOrder.Craft, WorkOrder.DateRecieved, WorkOrder.DateCompleted, WorkOrder.FollowUpComments, WorkOrder.CraftPerson FROM...
  14. K

    help me fix this SQL query!

    Ok, here's the query that isnt working the right way. What I'm intersted to do is to be able to type in the last name of the person or the first name and bring up ONLY that persons work orders! What is happening right now is that it pulls out all the CarftPerson! SELECT...
  15. K

    Open report in "landscape"

    Thanks... I was having the same problem! Now got it fixed!
Back
Top Bottom