Recent content by vgersghost

  1. V

    First of the year date

    Thanks again. Now that I think about it it's kinda of stupid to show 01/01/2011, because your right, first of the year would always be 01/01/ something. Done bothering you and thanks again for your quick response.
  2. V

    First of the year date

    Wow this cool. I need to readmore! It shows Staurday. I been trying to make it show like 01/01/2011. I reading up on dateserial
  3. V

    First of the year date

    Thank you for the quick response. Okay So how would I get a controlbox on the same form to always show the first of the year without picking a year. I can do easy dates!! The query I'm working on works between the first of this current year and first of past years.
  4. V

    First of the year date

    I have a control box I want to populate with the first day of the year. You have to pick a year form a list and then I need it to show the first day of the year no matter what year is picked. Just can't figure it out. I'm hoping once I get shown how to get the first day I can use the little...
  5. V

    Merging two unlike tables

    Not sure what A,N,I,D,T columns are. The field names can be change in either table to match, (copies) and then I could just change them back. thx
  6. V

    Merging two unlike tables

    Not sure what your asking? I could have easily appended the data from table a to table aa if the field names match, but you can see that table a field names end up in one column called field names in table aa and the data is in the next column.
  7. V

    Merging two unlike tables

    The date was enter in a maintenance program line by line, not very quickly. I'm tyring to speed up the process. I'm stuck wit the program. Hope this helps.
  8. V

    Merging two unlike tables

    I am trying to get the data from table A into table AA. Not sure how this works. Tried queries, but no luck. Thanks for any ideas or help.
  9. V

    Round value

    Try this also ROUND((YourData)/5,2)*5 This gives you: 34.11 34.1 34.12 34.1 34.13 34.15 34.14 34.15 34.15 34.15 34.16 34.15 34.17 34.15 34.18 34.2 34.19 34.2
  10. V

    Round value

    mfuada Here is some coding that I used for rounding. Works quite well. Not sure who gave it to me though. See attachement
  11. V

    Automail from Access

    Lissa: This is the code I have been using for SMTP for awhile and it works great and is simple. Public Function SendEMail_CDO(strBody, strSubject) 'strFrom, strTo, strCC, strSubject, strBody, strAttachment Dim mail Dim config Dim fields Dim strTo As String strTo =...
  12. V

    Reworking data in a table

    Yes that is Correct. I am trying to merge all the records. Just not sure how. thx
  13. V

    Reworking data in a table

    The value "00050S" repeating in field 1 is not a primary key. There is none. I'm not sure what your getting at. thx
  14. V

    Reworking data in a table

    Hello: I was handed a table where the data is layout like this: Field 1 Field 2 Field 3 00050S 10-71434B 0.05 00050S 10-72855 0.003125 00050S 10-83105-6A 1 00050S 10-83126 1...
  15. V

    Removing last digit on different length numbers

    Thank you pbaldy. Left(FieldName, Len(FieldName) - 1) It worked and it was so simple. Still learning things and appreciate all the help
See more
Back
Top Bottom