Recent content by Izzy2009

I created a database that has 3 tables, an items table, lot table, and shift table. I have attached the relationship chart that will explain how the tables are linked. I have created three forms that goes in sequence. The 1st form has the WEEk_Of and ITEM fields and the second form has LOT...

I am creating a form that is going to pull from two separate tables. The form(tblLot) has a subform in it (tblShift), which allows a user to enter information concerning the shift (ie: shift_date, amount_batches, etc). The form has a combo box that allows the user to select a week, then...

year1/2/3/etc were just hypothetical years, I figured I would keep it in general terms. Anywho, I ended up doing something similar in changing the date if it was in the past: IF {EQUIPMENT.ASSESSMENT_DATE} < CurrentDate THEN ToText(CurrentDate,"yyyy") ELSE...

More or less, in a multi-columned crosstab, how could I combine two of those columns into one and maintain the rest of the columns. Say my first post's code block is where I am and this is where I am trying to go: year1&2 year3 name building1 <$$$> <$$$>...

Ah, my apologies. I am using Crystal Reports 11. I understand in the Crosstab function how to insert the data so it is displayed by year (something like under the Column section: Year, Summarized Fields: Cost. What I don't understand is how to bring a back-catalog of costs and throw them into...

I am trying to write a report to display fields by year as a budget projection report. Something similar to this: year1 year2 year3 name building1 <$$$> <$$$> <$$$> building2 <$$$> <$$$> <$$$> building3 <$$$> <$$$> <$$$> name building1 <$$$>...