Recent content by Martian262002

Hello Everyone :cool: , In access, I have a field in a table that I need to fix. The field contains a charge(money) value, with a code attached to it. For example: [2345.0020680]---> The (2345.00) is the charage amount & the (20680) is the code. [17580.04PPO]----> (17580.04) is Charge...

Hello everyone:cool: , I have a form in Access, that uses criteria from drop downlist's to grab data from the database & display it in a report! To display the report you have to click print preview, and the report is displayed. Here's the problem: When I try to export the document into...

Hello everyone:) , Episode Visits: SN: 4, HHA: 24/Supplies: 7 The above is my the information I need! I need the SN:4, HHA:24 & Supplies:7! The above example is in one field, and I need the given information in a separate field! Ex: Episode Visits: SN: 4, HHA: 24/Supplies: 7 Fields: SN...

It Works! Thanks, It worked great, I really appreciate it!! Thanks again everyone,:) Martian26:cool:

Hello Everyone, I have a problem with a couple of my fields in Access 03'. I need to cut the character(chr) out of a number in a field. There is a the little box Chr at the beginning of my PatID numbers and between the 1st number and the 3rd. The * reresents the little box Chr...

Hola everyone! I need to know how to delete dates using the criteria field in an delete query! This is how the table looks: Field1 Smith, Mike J 09/26/2005 11/16/2005 The date range is wide, so doing a between is not a good option. Field1 is filled with information like the above. How do I...

I have this table filled with patient information. I imported the excel file into textPad, then to Access and I have a little problem. There are 2 fields that contain Patients name because the names are too long. How I know where each patient name is because in another field their is the word...