Search results

  1. C

    Calculater query

    n what criteria wud I write 2 multiply the 'number of days overdue' by €0.23, oh,and wot wud I put to add 30 to the 'date taken out'??
  2. C

    Calculater query

    Oo0OO Rob!!! U iz a Mile-o-phile in the making!!! Thank u!!!!!!!!!!!!! *mwah*
  3. C

    Calculater query

    Dats because I don't have any criteria!!! I just have the fields, date taken out, date due back, number of days overdue, and charge incurred by this item so far
  4. C

    Calculater query

    What I'm looking for is the criteria to write underneath in the criteria section of the query Thanx.x
  5. C

    Calculater query

    OK,I'm really sorry ppl,I know u're gonna hate me and that its totally selfish of me,but cud 1 of u super-smart ppl please give me the code I need... OK, so I've got a table that holds details of when a library member takes out a book. thing is, I need a query that calculates the date due back...
  6. C

    Calculator query

    oh ok,thank u i gotsta go now,lesson. I chat 2 u again 2morrow babes Laterz
  7. C

    Calculator query

    Ahhh,tiz my other friend (my bestest friend)!!! I do need that field Mile-O-Phile,for report purposes
  8. C

    Calculator query

    Hiya,before the likes of my friend directormac start schreeching at me about going into Access Help to find the answers to my problems I would like to say that I've already done that=I spent hours=and I still couldn't find the answer to my question OK,I have a table with the fields : Item name...
  9. C

    Refering to a child form's field

    What do I type in a query's criteria when I want it to refer to a field in a child form,as opposed to a main form.Basically what do I refer to the field as?
  10. C

    Child form syntax

    Do any of you guys know the syntax needed in the Query Criteria for a parametre query that reads a field in a child form (to use when opening up another form?
  11. C

    Parametre query

    U're syntax didnt work Any other ideas? (like writing 'sub' or something?)
  12. C

    Parametre query

    Mile,what do u write in the query criteria when u want the information from the first field (the criteria that decides what happens in the second field) to be from a child form (all the stuff you sent me is about Visual Basic,not query criteria)
  13. C

    Parametre query

    Right ppls, what do u do with the parametre query syntax [Forms]![Publishers]![PublisherIDNumber] when you want the publisher ID number to be looked up from 3 or 4 different fields on one table?
  14. C

    Parametre query

    I was just kidding, I know its Mile-o-phile (lol) NEWay,I checked ure profile n u were born in 79,so that makes u either 23 or 24.Nice Oh,by the way,do u know what to do with ure syntax when the original form is a child on another form? (the form where the criteria comes from?)
  15. C

    Parametre query

    So asl Mile-o-man I'm 25/f/London
  16. C

    Parametre query

    Beer it is then! I created a form out of the query and want it to open this form,when run,with the criteria (publisher ID number) from the last field matching the publisher ID in the publisher ID section of this form
  17. C

    Parametre query

    Ohmygosh IT WORKS!!! AW,I CUD KISS U!!!!!! Just one more question,how do I open up a form using this query?
  18. C

    Parametre query

    Here it is: [Forms]![Publishers]![PublisherIDNumber] Oh by the way I checked out u're site - its cool! It'll be excellent when its finished!
  19. C

    Parametre query

    Oh,the form will be open,its from here where the criteria is written. Do u know how 2 get rid of that weird message?
  20. C

    Parametre query

    When I try it I get a message that says 'Enter Parametre Value' and underneath it says 'Forms!frmWhateverForm!txtWhateverControl
Back
Top Bottom