Printing unique record

[Kathy]

In the olden days in Alpha4, I could tell the report to print all the data with a certain field on one line by programming that it as unique. So how do you do it in Alpha7?

I have the program working very well for most people but this individual wants to enter his data each day rather than wait until the work is complete so when the records are entered the data looks like this:


Worker: Sun Mon Tues Wed Thu Fri Sat Total Hrs

Brown 7 7
Brown 8 8
Brown 7 7




I want the data to print like this:

Worker: Sun Mon Tues Wed Thu Fri Sat Total Hrs

Brown 7 8 7 22

I know it is probably so simple but I don't know what word to use to look this up under help.

[Tom Cone Jr]

Kathy, perhaps others can intuit what you mean better than me. If not, tell us the table structure and explain when / how each field gets populated.

-- tom

[Kathy]

The report didn't come acroos

I will scan a real report for you and send it-the example I gave did not come across the way it should have. Sorry Kathy

[Tom Cone Jr]

Kathy, that may help even though it's not what I asked for. However, understanding the structure of your table and the sequence in which fields (or records) are filled in by the user would be better. Maybe the terminology is getting in the way. An A5 table is the thing you know as an A4 database.

-- tom

[masteralone]

Kathy,

From what I read it is simply a weekly breakout of hours worked for a specific week.

I am assuming that (a) you have a date field as part of the entry process for each day and (b) you have an index created for the date field and (c) you select the start and ending date for the report.

If this is the case, you can run a simple for i=1 to 7 operation that would open a table, get the hours for the first day, put it into a variable like day1, fetch the next date, put the hours in day2 and so on, then set the 7 days on the report to the 7 vars you have and total the vars.