Fields collection

[Dryseals]

I'm using code to create a crosstab table for me, this is for scheduling multiple crafts by date, tally the time and post it in a form. Problem is not all crafts are schedule each day, so any craft not scheduled will not create a field in the crosstab.

What's the best way to determine if a field is in a table?

 

[SkipVought]

Hi,

Do an outer join to include ALL crafts.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[Dryseals]

Thanks Skip, I'm not sure if I can do this, self taught. But the outer join would be between two different tables correct?
This crosstab is compiled from one table. It's a table pulled out of SAP. It's an operation table so each operation represents a record. In each record is the craft, the date and the times, a few other things, but we won't need them.
In the form I have a box for each craft and the crosstab tallies the time for each craft for that date. Only one date at a time is used. So if there is no time on that date for "X" craft, theres no result and no field created in the crosstab.

 

[SkipVought]

But the outer join would be between two different tables correct?

Not necessarily. You can join a table to itself (TWO occurrence of your table in the QBE grid) on [Craft].

maybe post a sample of relevent data you're owrking with?



Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[dhookom]

If the craft field is the column heading, you can simply type every craft into the Column Headings property of the crosstab query.

Duane
Hook'D on Access
MS Access MVP