Recent content by Spikemannen

Hmm, your example didn't work. The field just came out blank. Best Regardz, Spikemannen

I'm sorry but my "code" english is not that good :-/ I'll try to describe it better: in tblArrend i put in arrends from different companys. And every quarter(of the year) we are suppose to send an invoice to each company. But only for those arrends that has a been finished...

the last record in tblInvoice. The last record is the same companyid but the last invoicedate. Best Regardz, Spikemannen

Hi... This is my code so far: SELECT SUM(tblArrend.EstTime) AS SumForPeriod WHERE tblArrend.CompanyID = tblInvoice.CompanyID AND tblArrend.Finished<tblInvoice.Until My table tblInvoice looks like this: InvoiceID InvoiceDate CompanyId BillTime Until In this form I choose a InvoiceDate and...

Hi! Thanks for your reply... The thing is that I want the sum of tblArrend.Time for all the arrends that has a finished date that is between previous tblInvoice.InvoiceDate and tblInvoice.Until in the active post but only for the company that I have selected in tblInvoice.Company. Best...

Hi! I have five tables: tblCompany CompanyID CompanyName tblSubject SubjectID Subject tblHandler HandlerId Handler tblArrend ArrendID Company Arrived Subject Arrend Handler Prio Description Status Finished Time tblInvoice InvoiceID Company InvoiceDate Until Time For the function I'm after...

Hi! I have five tables: tblCompany CompanyID CompanyName tblSubject SubjectID Subject tblHandler HandlerId Handler tblArrend ArrendID Company Arrived Subject Arrend Handler Prio Description Status Finished Time tblInvoice InvoiceID Company InvoiceDate Until Time For the function I'm after...

Hi all... Have this table with about 16.000 posts, with the fields: Hsbftg Old Levnr Lev Faktnr Pg Period Cost There are duplicates in this, now I want to view which posts that are duplicates. And the only thing that tells me who are duplicates is to compare the fields Hsbftg and Cost. How to...

Hi. I have three tables. tblCompany CompanyID (count) CompanyName (txt) tblInvoice ID (count) CompanyID (related to tblCompany) InvoiceDate (date) InvoiceNo (txt) TimeFrom (date) Time (number) tblSupport ArrendID (count) CompanyID (related to tblCompany) Arrive (date) Area (txt) Description...

Hi. I have three tables. tblCompany CompanyID (count) CompanyName (txt) tblInvoice ID (count) CompanyID (related to tblCompany) InvoiceDate (date) InvoiceNo (txt) TimeFrom (date) Time (number) tblSupport ArrendID (count) CompanyID (related to tblCompany) Arrive (date) Area (txt) Description...

Hi! I have tried this code in both access 2000 and access xp. In access 2000 this works, but not in access xp?! How should I do this to get it to work in access xp? Problem: I have a form where I name an object and choose between which two dates it is avaible in the form frmObject. In my...

Thank you... Now I got it Best Regardz, Spikemannen

Still the same error message. Access marks the first , . Best Regardz, Spikemannen

Thank you. I have wrote: Days: DateDiff("y",[From], [To]) But I get this error: Microsoft Access Expression syntax not valid Best Regardz, Spikemannen

Are you trying to configure Outlook through Outlook or through Start - Settings? Best Regardz, Spikemannen