Recent content by Celtic Queen

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'??

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

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

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

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...

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

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

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...

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?

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?

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

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)

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?

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?)

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