Referencing Values in a Crosstab Query

[Guest]

What is the proper syntax for referncing a value within a Crosstab query?
Does something like DLookup work?

Ideally, I am looking to populate fields, on a form, in a time sheet
scenario. A crosstab query creates the desired format/data intersects;
however there is the issue of days not yet populated, which don't exist in
the crosstab, but would need to exist on the form, and populate back to the
table(s) correctly.

Any ideas, or does anyone have a time sheet/time capture db I could look at
for reference?

Thanks, in advance.

Sharkbyte

 

[Guest]

You can make columns show up in a crosstab that don't exist in the data. Look
for the Column Headings property of the crosstab query. Right click on the
area near the tables in design view. Select properties. If you wanted numbers
1 through 14 to show up in order:

1,2,3,4,5,6,7,8,9,10,11,12,13,14

For months:

'JAN','FEB','MAR','APR','MAY','JUN','JUL','AUG','SEP','OCT','NOV','DEC'