Search results

I have a main form with several subforms based on a 1 to 1 relationship. The information on the main form is common to all the groups and is kept in one table. But each group has unique fields so each has its own table. Each of the subforms is displayed on a page. Question: I want the fields...

To increase the limit you can use the Memo data type instead.

If you have a whole number (for example 1.0) JStockton's method will properly not round it up to 2 but mresann's simpler solution will. Don't know if that matters.

Thanks. No, I don't have too many IIF statements. Like you suggested I try to avoid using them. In this instance, my users enter buys and sells as positive values. To get the total I make the sells negative with an IIF and sum them up. Then I do some other things and it becomes a nested query...

Have you tried using the Month function? If you put Month(yourdate) it will return the month number. See if that helps.

Hello: I have read in Access Help that using IIF statements in queries does not allow the query to be optimized and can be a cause for slow performance. Simple question: If I create a public function to do my IIF statment operation will this allow the query to be optimized and run at maximum...

Perfect Wayne! Thanks.

Hello: I searched to forum but came up empty. Does anyone have a list of reserve words or know where I can get one? Thanks, Dwight

Perfect Oldaf294! I've adapted your method to my needs and it works great.

I want negative numbers on my report to be in parenthesis rather then have a preceding negative sign i.e. I want (10) for -1 but I don't want them converted to string values. Is this possible? I worked with the FormatNumber function but I only succeded in generating errors. As always, I...

Hello: Two questions: 1) Pat Hartman often writes about Access's ability to be combined with true client server RDMS softwars (e.g., Oracle, DB2, SQL Server) and explains that if this upsizing is going to occur that each table must have a unique index. I don't have any plans to upsize but want...

Thanks Newman, I like the IIF statement approach. If the bars are greater than +3 or less than -3 (both can be the case and yes they may be much greater i.e. +10 could occur) then I want them truncated at that point.

Hello: My issue is odd but I think simple to fix. Here’s the situation: I have a report with a horizontal (rather than up and down the bars go left and right) bar chart graph at the center The range of the X-axis is from -3 to +3. The problem is that if a value falls outside this range, for...

Well all I can say, is thank you but that seems inadequate. This will be very helpful to me. I see the effects of the timer (what happens when I click) but don't understand why I need that in the code.

Mailman: The calculation you provided is a Total Return figure - which works fine. But how would I calculate a compounding value if I had the percentage changes rather than the actual values? This is where I always got hung up before. I have attached the same database with a new table called...

Thank you Mailman. It does indeed appear to do what I need.....and I even understand it which is an added bonus. I didn't include the queries I mentioned because I was sure they were a dead end. Previously, I had always first calculated the individual period percent changes and then tried to...

Take a look at the Command Button Wizard.

Hello: I need help calculating a compounding value in Access. Attached is a database with a table containing some sample data which I hope proves useful. Using self-join queries I know how to calculate the percentage change between two values in a data series. However, this method (as far as I...

I have not looked at your database but from your description it does not sound like it is designed properly if you are trying to move data back and forth between its tables. If it is normalized this shouldn't be necessary. The data would be in the correct table and then queries can be used to...

Thanks Sam F. The append query took about 3 minutes to setup and works fine. I just set up another table rather than trying to update a column in an existing table. I'll just keep telling myself that 5 hours of researching the VBA help files yesterday was good for me....... Thanks again, Dwight