Search results

Thanks Pat, I don't play bridge, but I am starting to believe you know all the tricks. The Abs(Sum(YourField)) did not work but you motivated me to persist with the sum function instead of the count and I think I have finally got it. There is an added trick I had to use though. When the True...

I just hope someone here is able to help with this. I have on a form a combo box with its list of values derived from a table. The values selected from the combo box are all stored in one field in another table. I want to count all the like values so I can group the like values into different...

You could add a time/date field in the patients table. In that way each patients record would have a date associated with the record. It should then be easy to filter the records that feed the combo by using the function: =Date(Now) Regarding the relationship issue, it seems to me that...

Another possibility working with two forms is that it is possible to open the second form from within the first by using a button.

For just two tables, a one to many relationship is always the best option, at least initially. In fact, you need to ask yourself if you really need two tables. Which begs the question: when are two tables required? The answer should lie in knowing what we really want to achieve. Then, the...

Still making headway, however the DCount function is giving me the total of each set of filtered records in the entire table. I am not able to get a sub-total for each group I have in the report. Probably I should try to explain: This database is...

Many of those fields are either redundant or futuristic. As I went along creating the database I kept on trying different things. However, the cleaning up can stay until I have decided on a final direction. Well, I have made some headway with resolving the issue as posted. I created the one...

I have been at it for two days now and still am unable to make a breakthrough. I think I need to be baby fed.

I have been at it for two days now and still am unable to make a breakthrough. I think I need to be baby fed.

My, My that does not sound so bad. Wish I could get waylaid myself:p

Anything new

OK: Firstly, just for an overview you could go: "Switchboard Form">"Open CIM Module" here you will see the main form and the 11 combos which I would like to replace with just 1. (You could probably play around with some of the buttons there, and you will see that this is a form...

Isskint, the db is here

And this is number ten so I can post a link to the db in my next post

I only need one more post after this, then I can post a link.

I just re-read your reply and this is exactly how I have it now. So there is a combo for each value with just one row per combo. However, my client wants just one combobox with all the values listed. Hence my needing help. IT is funny, because on the face of it it seems so simple. I even tried...

If you could give me a PM Link or email address I would send you a link to the DB. I get the feeling that it would be a breeze for you.

I really appreciate your interest. However, the copy I would send you is on another computer at home and unfortunately I am now at work. Anyway, I will send you a link to one so you can see what I want to do.

Isskint, that did not work for me. However, remember that the combo is just the vehicle by which I enter records into a table. The table is also included in the query that my report is based on. The problem really is that all the records are stored in one field/column and I am not able to use...

To use your example, I would need an addition to the expression that would target a specefic row in the column which I could then use the Count function on viz:Forms!FormName!ControlName.Columns(2).row2