Recent content by Milin

Is there any way that I can format a field in my table to take a fraction? - I realize that I could just make it text and write it manually, but I want to be able to total it as a real number in a query. I see that Excel can do this, but I can't figure out how to format for Access - I don't...

Thanks for your help.  I don't actually want to do a running total, as I want the count of the "D" value for each grouped account.  I'm sorry - I am new to formulas in CR - this is what I've tried to piece together, but it doesn't work. I don't understand how to set...

Hello, <br><br>I have a report that lists meetings and their status letter, grouped by their related account.&nbsp;&nbsp;What I want to do is get a subtotal on each Account of how many Definite-status (&quot;D&quot;) leads there were per account - not a subtotal count of all meetings, JUST the...

ok elizabeth - I think I see why. in my households, I sometimes have duplicate responses to magazine A (partly a dirty data problem and partly someone that responded to the same mag, say 6 mos apart). So I can use this report based on the numbers being the total individual response by mag. My...

Sorry elizabeth - I didn't explain it well...<br>the formulas I'm using are your Query1 and Query1_crosstab.&nbsp;&nbsp;I'm assuming, like you said, that the intersection of rowA with columnA is the total for A magazine. At first this looked right, but I went back and did testing against my...

elizabeth..<br>This is cool!!! It almost works - what I notice is that in the joining of the table twice in query1, it is counting my magcode totals twice, so the intersection cell of mag1 and mag1 on the crosstab query is very inflated.&nbsp;&nbsp;I noticed that when I deleted the table2 copy...

Thanks for your replies!<br><br>I think Elizabeth is going towards what I'm trying to do - but I'm not sure because I don't quite understand what you wrote.&nbsp;&nbsp;What is Tablel2_1?&nbsp;&nbsp;Here's some more info - I have a query that gives me householdID, MagCode, and other address info...

Hello, <br><br>I can't quite figure out how to do this - do I need SQL? ...I am a newbie at it<br><br>I have households of customers(all grouped by a unique household group id number) and the magazine (represented by a magazine code) that they responded to.&nbsp;&nbsp;What I want to create is a...

I have a report in which I am grouping data together by unique address. I want to create a total in the footer of the report that counts the number of unique addresses from the address field - so I can see how many address groups I have in the report.&nbsp;&nbsp;All I see in Access is the COUNT...

Hello, <br>I am using Crystal5 and was told that it is not possible to total off of a number in a group footer- is that really true?...this is my situation:<br><br>I work in the travel and tourism industry and have a report that tracks meetings booked in my town and the hotel - or hotels - that...

JIM...<br>Thanks for the help. I set up the code and on every record I click to try to open, I get the &quot;record not found&quot; message box that I set up. I can see the &quot;CallerNo&quot; in the main table, so I know the records are there. What do you mean about the recordsetclone not...

Hello...<br>I am trying to recreate an example I found in the MS Access97 Step By Step book p.179). It is where you create a dialog box (form) using a list box to pick a record to go to a specific record on the main form.<br><br>This is the code from the book, modified for...

Hello, <br><br>Has anyone used any of the merge/purge or &quot;dedupe&quot; mailing list scrubbing softwares out there that claim to &quot;plug into&quot; Access directly, instead of having to export out a file?<br><br>Thanks

Hello, <br><br>My goal is to create a database of names of email respondents to our website.&nbsp;&nbsp;I have all incoming emails in a folder (in Outlook97).&nbsp;&nbsp;I am using MS Access97 with the &quot;link to Outlook&quot; free plugin in order to hook the two.&nbsp;&nbsp;I can pull the...

I bet this is an easy one, but I just need someone to help me understand the basic concept - I've never done this before...<br> <br> I have a form (form1 )and a subform(form2). When data is entered on form 1, a customer number (an autonumber) is generated. This number and the other data is then...