Recent content by ppatel2

Thanks lbass. I have rewritten the formula and used the sum option. The calculations have come out correctly. I also have a distinct count I am trying to do on a similar field. I need to count all unique documents #s for a specific group for a given period. The period has been defined by the...

Hello All, I am trying to create a report in 8.5 that will give me four columns of data. Two (one actual the other a percent) columns reporting on the current month and the other two reporting on year to date totals (actual and percentage). All this data is in one table. I tried to create a...

I do have the forms records set to a particular table (input). The table and fields used in the if statement are from a query that updates everytime a row is submitted.

kjv611, I pasted the code you provided and the error message I'm getting is "Object Required". I have setup the code in the module corresponding to the command button and event (on-click).

kjv1611, My ultimate goal is to not have to keep selecting a listbox value when I know all corresponding list box values will equal the initial list box value.

kjv1611, You are correct. I tried placing an if statement in the onclick event of the command button. It looked like the following: if (conversion_1.country is null) then (DoCmd.GoToRecord , , acNewRec) (else [list13=conversion_1.country] and [DoCmd.GoToRecord , , acNewRec]) It is erroring...

So I have this listbox that I set to a country. I also have two text boxes where I enter in information. Currently the List box reset after each submit command. I was wondering if I could lock the value in the list box until I clear all table contents (already have a command button for this)?

My apologies, I linked the two tables using a key field from table(A) with a foreign key field (can have duplicate values) in Table(B). I did not however link the two tables on the field i'm using as a group.

Software used: Crystal 8.0 Microsoft Access Database So I've linked two tables togethers. Table(A) has a one to many relationship with table(B). I've used data from table(A) in 4 out of the 6 columns in my report. Table(B) supplies 1 out of the six columns in my report. I've linked table...

So I'm trying to get the one mean value of three columns from my table. I had to use the three columns because the intial SQL statement uses an outer join on a single table three times to pull three different values. I'll Provide an example of the data below: C1 C2 C3...

I'm trying to link two created tables in Crystal (8.0). The tables are Peoplesoft queries. Every time I try this in Crystal I get a message saying that I can't link SQL stored procedures. I'm trying to create a report based on somewhat of a cross tabbed report. 5 out of the 6 columns of...