Search results

Hi there I'm using DCOUNT to count some fields on some of my tables and I would like to know what can I do to only count repeated fields only once. By example if I've got access in two different fields it only count one. This is my code: dcount("[field]", "mytable") Thanks

Thanks for your quick response. Newman, I've donne what you said, divide by 60 and I get 2.25. I just dont' understand what do you mean with modulo (15). So, I have this formula: Duration = DateDiff("h", IncStart, txtrts) / 60 What should I do next?

Hi there. I'm using the following code in my Access aplication: DateDiff("h", IncStart, txtrts) My problem is i need the exactly time difference and if the difference is 2hours and 15 mins it will display only 2 hours. Is there any way to do that? I've tryed in min but it display 135 mins.

Hi there I've got the following query in my application: SQL = "INSERT INTO tblreport3 ( exchange, NoCustomers2, [time] )" SQL = SQL & "SELECT Table1.Exchange1, Table1.Customers1, Table1.Duration" SQL = SQL & "FROM Table1" SQL = SQL & "WHERE (Table1.IncStart Between #txtdatefrom# And...

Hi there I've got the solution now, it is as following: rst.FindFirst "[Exchange1] = '" & CbmExchange & "' And [IncStart] >= #" & txtdateFrom & "# ". Thanks anyway

Hi there In my application I've got a table1 with a field data type "Date/Time"(IncStart). On my form I've got a text field(txtdateFrom) formated to short date. The problem is when a run the following query: Set rst = CurrentDb.OpenRecordset("SELECT * FROM table1;", dbOpenDynaset) rst.FindFirst...

Thank you very much. Your feedback is very appreciated and will help me to improve my website. In one of my pages I've got a votes and the results are given in percentages. The problem is, if is divided by 3, it will display a value of 33.333333 when I only want 33.3. Any idea on what to do...

I'm sorry i've typed the wrong address. http://www.safoda.co.uk

Try this: Detail.BackColor = 255

Hi On some of my website tables I use the "aAlign"="top" code but is not recognised by W3C. Is there any other code to do the same job and is recognised by W3C? Could you also surf on my website and give me some feedback on how to improve it? http://www.safida.co.uk Thanks

Thank you Stopher

Hi I would do like this: Private sub Submit_Click() dim sql 'inserts into Table1 sql = "INSERT INTO Table1(field1,field2,field3,field4,field5,field6) VALUES ('" & field1.Value & "','" & field2.Value & "','" & field3.Value & "','" & field4.Value & "','" & field5.Value & "','" & field6.Value &...

Hi there I have a table in my database with a field called description. Imagine if one of my discriptions is "I learn a lot in access world forums". I need a query that if I look only for a word "access" will retrieve this discription. Is this possible to be done in access? Thanks

One last question. Where can I find a good SQL 2000 tutorial? :)

Thank you SQL_Hell to your quick reply. :) Thas was great. By your explanation I take that is very similar the way is done on access. Is this right?

you can link or import the data from the txt file into the database. 1 - Do right click on objects tables and select import or link. 2 - Select file type txt and look to your text file. 3 - select your text file and follow the wizard. Hope this helps

Hi. I’m new on SQL 2000 and I need some help for this project at work. I’m building a database where the data that need to be inputted in come in a text file. Is any way (like a batch file or linking the database with a text file) to input the data strait away? Some files are over 100 MG size...

I 100% agree. Just to reenforce what you two said before it's loads times I have a question was already made for someone else and I just need to read the reply.

Hi there! I've three tables in my database, tblInfo, tblSavedInfo & tblCountry. for tblInfo I have this fields - Ref: Cost: RefCountry: for tblSavedInfo I have this fields - Ref: Cost: Country: for tblcountry I have this fields - RefCountry: Country: My problem is when I save from tblinfo to...

Hi I've written the following SQL code that is not working: SQL = "INSERT INTO tbltest5 ( TLI, [Switch Name], NNI, [BT CB], [Time Period], Calls )" SQL = SQL & "SELECT tbltest2.TLI, tbltest2.[Switch Name], tbltest2.NNI, tbltest2.[BT CB], tbltest2.[Time Period], tbltest2.Calls" SQL =...