Recent content by bolson7117

Yea I'm stumped :banghead: Thanks anyways man :)

Yea I've been giving it a whack for a bit now, ill try and get it. It's prob something simple.

It looks like the field format is Text

Hey guys, I'm trying to get a GPS format from this: Table:ENGB (AMI GPS) Part 2 Latitude:41.58932000 Longitude:-96.92073000 To this: Table:ENGB (AMI GPS) Part 2 Latitude:4158932000 Longitude:9692073000- Thanks in advance :), I know the table name has spaces, don't hate me :o

Got It.. Thanks! Have a good Week!

Its stuck as a text field

Can anyone help with this, the field is combing MM/DD/YYYY (time) 12:00:00 AM exp. photo and I would like the date and or both to be Real date format. I'm not so worried about the time but the date would be nice. here is what I have but im lost with the time added :banghead: Field: Last...

I'm wondering what would be the best way to update a list of records based on today's date. Right now I have it to open the form based on the LAST record and then navigate to the record they would like to update, I would only like to show what was entered that day. Thanks in advance for any...

Sort of like this but with the customer on each page.

Hey all, I'm trying to put together a 1 page report that would break down customers as shown in the attached pic. I have tried to do a sub-report but after the first page something is not working right and is not giving me the fallowing results after 00000148 MBRNO. Would this be a problem when...

Wow Umm Yea Access 101 I must have skipped that chapter :) Thanks for the hlep!!

Hey all, I have a problem with a Switch function being to long in my field. :( I have around 23 different numbers like "000001" in my table CAR1_CAV_LOCINFODETL.AREANBR This is what i have been doing but if go any more it will not work? I also do not want to show "000000" and "000098" in my...

Ok now that i have that how would a add something like this, do i use a & as well. Township Direction: Mid([CAR1_CAV_MEMBERDETL.LOCATION],13,1) -up- this is just giving me a 1 or a 2 and all i want to do is do a Switch or Replace command with this. 1=E and 2=W...

O yea Thanks A-Lot! :):):):)

hey all, If i wanted to add a 0 in front of this Mid express i have already got where would i place it at. I'm also wondering how I can add a non-existing field to my Querie. For example I wanted to have every record have NE as a my state field. SECTION: Mid([CAR1_CAV_MEMBERDETL.LOCATION],7,2)...