Search results for query: *

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

Hi everybody! I have a table: ID (calc) Cost per day (currency) From (date) To (date) Number of people (numbers) And I want to calculate like this: Cost per day X Number of people X amount of days between...

Hi! I'm going nuts over here. I have a table with Objects. tblObjects ObjectID (calc) Object_name (text) Avaible_from (date) Avaible_to (date) etc... And I have a table for booking. tblBooking BookingID (calc) Name (text) Phone (text) Object (relation...

Is there an easy way to place a button in my form that will add specific files to a single post? Best Regardz, Spikemannen

Hallo, I have a tbl like this: arrend date amount of time And I would like my query to show how many arrends I have per month. How should I do this? Best Regardz, Spikemannen

When I want to send an email with MS Outlook 2000 and choose to send to a group, can I then choose one member in this group who won't get the mail?

I have a form with a textbox that I write comments in. When I press the button "New Comment" I want todays date to be written in the textbox on the row under the last sentence. Is that possible? Probably, but how will I do that?

Can I have a button that puts todays date in a text box after the text that is already there?