Topic profile page for Anlu.
This page has aggregated data from forum posts, threads, listings, online discussions, newsgroups, messageboards, and other online sources which contain user generated content for the term: Anlu.
Topic "Anlu" was discussed 68 times on 15 sites in last 3 months
Hi Claire, Could you use something like this: Function fCombineSemis(strTable As String, _ strFirstField As String, _ strSecondField As String) _ As String Dim sql As String Dim rs As Recordset Dim res sql = "SELECT " ...
Started 3 weeks, 2 days ago (2009-11-11 18:25:00)
by anlu
Hi Steve, you can use the TOP x statement in the SQL, e.g. SELECT TOP 1 field1, field2, ..., fieldn FROM table ORDER BY field1 Regards, anlu "Steve Haack" wrote: I have a querydef that returns a set of records, sorted by the ID (autonumber) field. All I need is the first record in the set. How can I tell the query to give me just that first record? Thanks,...
Started 3 weeks, 2 days ago (2009-11-11 17:32:00)
by anlu
Assuming that your time is of datatype date/time, you can use the Format function with the "hh:nn" format. (Using 24 hour format, you don't need the PM indication). Regards, anlu "AGOKP4" wrote: Hi all, Is it possible to convert already entered times in a12hour format to a 24 hour format? e.g I'd like times like 1.00PM to show 13.00PM THANKS!
Started 3 weeks, 2 days ago (2009-11-11 09:24:00)
by anlu
Hi Steve, you can use the TOP x statement in the SQL, e.g. SELECT TOP 1 field1, field2, ..., fieldn FROM table ORDER BY field1 Regards, anlu "Steve Haack" wrote: > I have a querydef that returns a set of records, sorted by the ID > (autonumber) field. > > All I need is the ...
Started 3 weeks, 2 days ago (2009-11-11 08:31:00)
by anlu
Assuming that your time is of datatype date/time, you can use the Format function with the "hh:nn" format. (Using 24 hour format, you don't need the PM indication). Regards, anlu "AGOKP4" wrote: > Hi all, > > Is it possible to convert already entered times in a12hour format to a 24 > hour ...
Started 3 weeks, 2 days ago (2009-11-11 08:15:00)
by anlu
Hi Steve, I think you put the Nz function in the wrong place - try: =Concatenate("SELECT tblPostAblationTesting.chrPostAblationTesting FROM tblPostAblationTesting WHERE [intTargetID] = " & Nz(Forms!frmMaster!fsubOpenEPS!fsubTargetDetails!t xtTargetID,0) & ";") Regards, anlu "Steve" wrote: > ...
Started 3 weeks, 2 days ago (2009-11-11 08:04:00)
by anlu
Hi, Put your code in the Form's Current event - that should do the trick. Regards, anlu "h2fcell" wrote: > Help! I’m in need of a little assistance. Using Access 2007; I have a > form, frmAgents, that has five Text Boxes bound to fields in one table. The > form has the following property settings...
Started 3 weeks, 4 days ago (2009-11-10 00:38:00)
by tamara
That worked perfectly. Thank you so much! "anlu" wrote: Hi Tamara, If I have understood your problem correctly, one way could be like this: 1) Create a table containing all the dates you want to count - if these are successive in some interval, you can easily generate the dates in Excel and import them to a table. I'll assume that the table is called "tblDate" and ...
Started 3 weeks, 5 days ago (2009-11-08 14:18:00)
by anlu
Hi, I see two immediate issues with your sql: First of all, there is a semicolon in your statement - I think Access interprets this as an end of sql marker. Secondly, a GROUP BY clause should come after the WHERE clause. Hope this helps... Regards, anlu "acss" wrote: My last post did not contain the sql but bottomline the i have isolated the problem in the where section...
Started 3 weeks, 5 days ago (2009-11-08 06:08:00)
by Steve Haack
That did it. Thanks for all your help. Steve "anlu" wrote: Steve, I think the easiest way is to create a new query, that joins tblPerson with the first query on PersonIDNum - this is a straightforward query and you can simply select the first and last names from tblPerson. Regards, anlu Anlu, That gave me exactly what I was expecting to get. Thanks for ...
