User Profile

Collapse

Profile Sidebar

Collapse
Executable
Executable
Last Activity: Sep 11 '10, 03:17 PM
Joined: Apr 30 '10
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Executable
    replied to Max(DATE) and Max(Time)
    in Access
    Hi NeoPa,

    Thanks for the lesson I really appreciate it. If I wanted to put this on a string would this work?
    Code:
    SQL = "SELECT tT.[SN],tT.[Time] FROM [Table1] INNER JOIN (SELECT SN,Max([Date]),TimeValue(Max([Date] + [Time])) FROM [Table1])"
    See more | Go to post

      Leave a comment:

    • Executable
      started a topic Max(DATE) and Max(Time)
      in Access

      Max(DATE) and Max(Time)

      Hi all,

      I have a table with several records that contain a SerialNumber, Date and Time. The same serial number can have several times and dates. What I'm trying to do is generate a SQL statement in VB to get the latest date and time when that serial number was updated.

      I tried using:

      Code:
       "SELECT SN,Date,Time, FROM Table1, (SELECT MAX(Date),MAX(Time) FROM Table1) WHERE SN=some value"
      ...
      See more | Go to post
      • Executable
        replied to Microsoft access reports/queries
        in Access
        Thanks to all that reply. I think I just found a solution it is not the most elegant solution but it will do the job. I will use 2 SQL statements:

        1) SELECT INTO temp FROM Main this will create a new table with the required ID.

        2) DELETE FROM Temp I will use the Temp table to delete any zeros (since there will only be one record at this point) then I can generate the report from this table.

        Thanks All....
        See more | Go to post

          Leave a comment:

        • Executable
          replied to Microsoft access reports/queries
          in Access
          Hi NeoPa Thanks for your input. Well, what do you think of this approach: fetching the record and searching for any columns that contain a zero, deleting these columns and creating a table with the new non-zero columns then generate the report and finally delete the table? This might be challenging but I can't think of any other way....
          See more | Go to post

            Leave a comment:

          • Executable
            replied to Microsoft access reports/queries
            in Access
            I appreciate all the responses; let me try to explain the situation a little better.

            Example: I have a table with 3 columns the names are C1,C2 and C3 (3 columns per row) column C1 contains a unique ID that Identifies the record. The value in C2 or C3 can change from 0 to 5. So let's say C1 contains the ID (value)=1 and C2 contains a value of 0 and C3 contains the value of 3. The user would like to generate a report for ID=1 so the...
            See more | Go to post

              Leave a comment:

            • Executable
              started a topic Microsoft access reports/queries
              in Access

              Microsoft access reports/queries

              Hi,

              I have a question. I have a table of several records each record contains about 20 columns and of course several rows. I would like to generate a query which checks each cell (not each record) and if the cell has a 0 then I want to generate a report that doest not include the value in the cell ( 0 ) nor the name of the cell. I just want to completely ignore the value and the name when generating the report. It can be in VB...
              See more | Go to post
              • Executable
                replied to Retrieving Data From a DAO Recordset
                in Access
                Thanks to all....
                See more | Go to post

                  Leave a comment:

                • Executable
                  started a topic Retrieving Data From a DAO Recordset
                  in Access

                  Retrieving Data From a DAO Recordset

                  Hi everyone,

                  I have a question. I am creating a dynamic report from a table and need to fetch all the data (values and column names) into an array so that I can manipulate the data. I know there is a way to get the values in the recordset using GetRows() but that Only gives me the values, I also need the Field names of the columns. Does anybody know how to do this?

                  Thanks,
                  See more | Go to post
                  No activity results to display
                  Show More
                  Working...