Search results

Thanks O' Great Cosmos75! Your answer was much more simple than what I was trying to do!

I can't quite get the second part of my expression to work..... I am trying to take a date field, ex. 1/1/44, and update the column with a CCYYMMDD format. Here's what I got so far: CCYYMMDD: Right([Dob],4) & Left$([dob],InStr(1,[dob],"/")-1) & Mid$([dob],HELP with MID....... Thanks in...

Thanks but....Not so fast.... In my example I had text as well. For instance the value "V45678" using val function returns a "0." I need it to return "V45678." Is there a way for an IIF statement to recognize the difference in a column between text values and number values and apply a...

Can someone write an expression for me that removes preceeding 0's from a column? The column has a mix of Numbers and Text so changing the field type isn't an option! For instance..... Transform this: 0045676 068 00356796 045678 V45678 Into this: 45676 68 356796 45678 V45678 Thanks in...

I thought that was going to be the answer...... BOO! Thanks for responding Pat!

Maybe I wasn't clear.... in the query design view.. Check out the attached file and you will get a clear picture....(ha ha). Is there a way to change the default size so you can automatically see all of the columns? Or do I need to resize every time I add a table? TheRat :confused:

Is there a way to change the default table size when adding a new table in design view? I am tired of resizing every table I add so I can see all of the field names. Thanks, TheRAT

For learning sake..... How do you write the statement if the person ID is a text field and the charge code is a text field? Thanks in advance, TheRat

Thanks Jon! Works like a charm.

I have two columns of data: Person ID and a charge code. A person can have a number of different charge codes (different procedures). I want to create a table with one person ID per record and their associated charge codes. I don't want a cross-tab because there are too many charge codes and...

He shoots... he scores! Thanks to all for responding. I love this site. :cool: Thanks again, The Rat

Not quite there... The code given on a previous thread: Me.Line (0, Me.Height)-(9.46 * 1440, Me.Height) creates a pretty horizontal line on every record. However, I am trying to avoid putting a line across the bottom of each record. I only want to cap off the bottom of each page. As I said...

Thanks Chris! I appreciate the time you've taken to answer my questions! However, I can't get your code to work for my horizontal line. Can you please review my example? Focus on the Employee report, not the rest of the gunk in the attached database. I want a horizontal line to close of the...

How about a horizontal line at the bottom of report? I got code to work for vert lines, but I need a horizontal line across the bottom of my report. My problem? My detail section of the report has two different columns and can dynamically grow at different lengths. See a small pic of my...

I am a self taught VB newbie. I found code for a single line to be dynamically drawn from the Microsoft Website. Can someone help me with the code for multiple lines. I need a line on the far left of the report, in the middle, and on the end. Thanks! //Single line code// Private Sub...

Thanks, but.... I tried the subreport route, but bc of the dbase structure it will put each week on a different row. Here are the fields in the dbase: majorprojects, employee,weektype (<--thisweek or nextweek), deadlines, currentdate, busunit, serviceline, and deliverables. The reason it...

I am trying to create an access report that looks like the attached word document. The difficulty I am having is trying to get all the data on one page. The projects that I and my teammates worked on last week don't necessarily link to the projects we will work on next week. The data sits in...

I have a large table that I want to add a database column to that calculates market share. In this new column I want to divide [people served]/ by the total number of [people served] for a particular [region] and [service line]. I tried the following expression in my attached sample database...

I'm sorry. I didn't explain that codes can have the decimal in different places, so multiplying by one number won't work. ex: Code Needs to be 31.1 311 51.10 5110 37.22 3722 64.0 640

Question: I work in healthcare and a vender wants me to send ICD9 codes without a decimal. Is there a function in access to drop a decimal, ex.98.98, and result in 9898? Thanks in advance!