Calendar and time sheet

Again you ignore the questions and facts that provide proof that you are
wrong and ask a tangential question to attempt to get logic off track.

I don't personally know Arno R. Don't ask me about Arno R. I was referring
to my friend and acquaintence Ken Snell. Remember the thread where you
accused Ken of advertising in public news groups? Here is the message that I
was referring to:
================================================
Steve,
You are a complete idiot! I just searched for the thread you quoted from Ken
Snell. The thread subject was "i need a pro". How can you even suggest that
what you do compares with Ken's reply? Do you have no common sense? Can't
you tell the difference between a OP who comes looking for free advice and
someone who comes expecting to pay?

The full text of the message Ken replied to:
"hi all, is there a site that has a list of pros that will actually set
up microsoft access for me. i need it set up for my small business
and it is far too complicated for me. i live in the northern kentucky
area about 50 miles south of cincinnati ohio. thanks for any replies
an have a nice holiday weekend"

In another reply in the same thread, the OP stated:
"..and then they could have an idea as to what they should charge me. "

Here's a little test. Rate the following on the appropriateness offering to
provide paid contracting services:

Subject 1: i need a pro
Subject 2: Multidimensional Forms/Tables
================================================

--
Duane Hookom
MS Access MVP
--

"PC Datasheet" wrote in message
ink.net...
So your "friend" is Arno R!


"Duane Hookom" wrote in message
...
Steve,
"a bunch of code" "jack up the cost"? I had the form and code created in
a matter of minutes (apparently I work faster than you). I then
provided/donated most of the solution free in this public news group (and
an earlier thread).

The tables were normalized and the data entry met the requirements. I
have done this a few times and it becomes quick and easy. My customers
don't have to pay extra later on when they need to query for all Tuesdays
or sum the values between 5/12 and 5/25. I would NEVER provide a solution
to a client that would work as you proposed.

When I read your post with the "spreadsheet" looking table structure, I
held back from criticizing your solution. Although I vehemently criticize
your advertising, I was too much of a gentleman to criticize your lack of
understanding of application development.

I called you an "idiot" once when you took a friend's statement totally
out of context and then immediately apologized. I have often criticized
actions and have tried to never refer to anyone as "DUMB", "Nitwit", or
other derogatory expressions (although I often think it).

You might get more work if you didn't display a lack of understanding of
news groups and programming.

--
Duane Hookom
MS Access MVP
--

"PC Datasheet" wrote in message
link.net...
So your solution is to write a bunch of code to fill a bunch of
textboxes rather that simply using an nonnormalized table. HOW DUMB!! Is
this the way you build applications so you can jack up the cost?

Fehn, there's nothing wrong with using a non-normalized table in this
case. Keep it simple and you get a non-code solution! You get your data
displayed the way you want and it's updateable.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications

www.pcdatasheet.com

Over 1050 users have come from the newsgroups trusting me and requesting
help.
My fees are very reasonable.



"Duane Hookom" wrote in message
...
A pivot or crosstab was my first thought also. However, Fehn possibly
wants a solution that is "updatable". The pivot and crosstab work great
for presenting the data from a normalized table but unfortunately they
are not updateable.

--
Duane Hookom
MS Access MVP
--

"Ed Warren" wrote in message
...
Your example looks a lot like a pivot table; some grouping at the top
and left with some data in the center of the table.
You just might be able to get to where you want to be using a clever
query and then displaying it in a pivot table.

Ed Warren.

"Fehn" wrote in message
...
Does anyone know how to make this possible ad updatable in MS Access?

Description - 12/1 - 12/2 - 12/3...... 12/31
Sample1 - 2 - - 5 .....etc
Sample2 - 6 - 8 - 3 .....etc
:
:
etc.


Thanks.

Glad to hear from you Fred!

I wished more people would speak up like you do now. It sure helps!
But if others don't want to get 'involved' in this mess, I guess we do understand.

Arno R

"fredg" schreef in bericht ...
On Sat, 03 Dec 2005 19:53:12 GMT, PC Datasheet wrote:

Duane,

You continue to demonstrate that you are not even in the league with class
acts like Allen Browne, Ken Snell, Pieter Linden, Albert Kallal, Fred G,
Graham Mandello, Chuck Grimsby, MG Foster, and others.

Steve,
You have gone too far.
To partially quote Joseph Welch --
"... Have you no sense of decency ...?"
Your first reply to the OP was a direct solicitation of business,
without even an attempt to give a workable answer to his question.
This went far beyond your signature solicitation and was totally
uncalled for.

You then assumed my non-participation in calling you to task was some
sort of approval of your behavior. Quite the contrary. I didn't wish
to take up my time, nor the time of others, in what I perceive is a
futile attempt to get you to observe the common courtesies of
participation in an international newsgroup dedicated to 'free'
technical help.

You then went and mentioned my name in an attempt to separate the
posters who have actively called you to task for these solicitations
from those of us, MVP's and others, who for whatever reason chose not
to participate. I can keep quiet no longer.

Steve, after following these many threads in the various Access
newsgroups over the past months, I can surely state that there is more
class in the fingertips of Arno, Duane, John, Randy, Keith and Jeff,
(and I'm sure lot's others who have not been actively participating
in this 'discussion'), than you have in your whole body.

You see, it's not just a matter of what you 'can or can't do,' it's a
matter of what you 'should or should not do' that separates 'Class
Acts' from the rest.

In a later post in this thread your wrote:
"There's an old saying, "birds of a feather flock together".

I agree. I'm very happy to be associated with Arno, Duane, et alia.
Believe me, it's much better to be an eagle than a turkey!
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Here's a rhetorical question for you ---

"Why are you so stupid?"

Thanks for providing the link where I got that!!!!!


--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications

www.pcdatasheet.com

Over 1050 users have come from the newsgroups trusting me and requesting
help.
My fees are very reasonable.




"Duane Hookom" wrote in message
...
rhetorical question
Huh?
/rhetorical question
http://humanities.byu.edu/rhetoric/F...0questions.htm
--
Duane Hookom
MS Access MVP
--

"PC Datasheet" wrote in message
ink.net...
Duane,

One of the prime signs of a dimwit is a post like the one you just made.
You have sunk to the lowest depths with John Marshall.

This is just evidence that you don't give a damn about the newsgroups,
about polluting the newsgroups with worthless garbage and wasting a large
volume of bandwidth.


--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications

www.pcdatasheet.com

Over 1050 users have come from the newsgroups trusting me and requesting
help.
My fees are very reasonable.



"Duane Hookom" wrote in message
...
Steve,
One of the greatest assets of a good programmer is the ability to
identify patterns. Can you see the pattern below?

News Groups
====================================
A question is posted: no advertising: No conflict
A question is posted: no advertising: No conflict
A question is posted: advertising: Lots of conflict
A question is posted: no advertising: No conflict
A question is posted: no advertising: No conflict
A question is posted: no advertising: No conflict
A question is posted: advertising: Lots of conflict

Can you find the conflicts? If you look at actual threads with
conflicts, can you find the ONE common initial element of each thread?

Do you ever see Arno R or myself or any others creating conflict without
an advertising post first?

Think about it...
--
Duane Hookom
MS Access MVP
--

"PC Datasheet" wrote in message
link.net...
Duane,

Just take a cue from the people who are class acts and quit supporting
and promoting Arno R and his band of dimwits. It's that simple. It's
not complicated. It's not difficult.

You are not impressing anyone siding with Arno R and his band of
dimwits. You don't see these class act people siding with Arno R. They
adhere to common netiquette rules. Whatever their feelings are, they
stick to helping people in the newsgroups.

There's an old saying, "birds of a feather flock together". Everyone is
seeing that you are just like Arno R and his band of dimwits.


--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications

www.pcdatasheet.com

Over 1050 users have come from the newsgroups trusting me and
requesting help.
My fees are very reasonable.


"Duane Hookom" wrote in message
...
Steve,
Just start behaving like everyone else. It's that simple. It's not
complicated. It's not difficult.

Everyone else understands this. Everyone else is very good at
complying. Everyone else sticks fairly close to common netiquette
rules.

--
Duane Hookom
MS Access MVP
--

"PC Datasheet" wrote in message
ink.net...
Duane,

You continue to demonstrate that you are not even in the league with
class acts like Allen Browne, Ken Snell, Pieter Linden, Albert
Kallal, Fred G, Graham Mandello, Chuck Grimsby, MG Foster, and
others.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications

www.pcdatasheet.com

Over 1050 users have come from the newsgroups trusting me and
requesting help.
My fees are very reasonable.



"Duane Hookom" wrote in message
...
I would keep all the data in normalized tables (and ignore or
verbally abuse PC Datasheet).

tblSamples
================
SampleID Autonumber primary key
SampleTypeID link to table containing descriptions
SampleDate
SampleValue

If you really need a form like this, consider
-writing code that loads your data into a "flat" table for editing
more code would be needed to normalize after editing
-create an unbound form like a grid of text boxes.
use code to fill the grid with data and then to
save the data to your normalized table

I wrote some code for another poster a while back the filled a bunch
of text boxes with customer names and order dates from Northwind.
One of the keys was to use a scheme for naming the text boxes as
below:

txtCust1 txtOrdDate1_1 txtOrdDate1_2 ...etc...
txtCust2 txtOrdDate2_1 txtOrdDate2_2 ...etc...
txtCust3 txtOrdDate3_1 txtOrdDate3_2 ...etc...
...etc... ...etc... ...etc... ...etc...

The code to fill the text boxes with customers and order dates:
Private Sub cmdPullOrderDates_Click()
Dim db As DAO.Database
Dim rs As DAO.Recordset
Dim strSQL As String
Dim intCustomer As Integer
Dim strCustomer As String
Dim intOrder As Integer
strSQL = "SELECT CompanyName, OrderDate " & _
"FROM Customers INNER JOIN " & _
"Orders ON Customers.CustomerID = Orders.CustomerID " & _
"ORDER BY CompanyName, OrderDate"
Set db = CurrentDb
Set rs = db.OpenRecordset(strSQL)
rs.MoveFirst
With rs
intCustomer = 0
Do Until .EOF Or intCustomer 2
strCustomer = .Fields("CompanyName")
intCustomer = intCustomer + 1
Me("txtCust" & intCustomer) = strCustomer
intOrder = 0
Do Until strCustomer .Fields("CompanyName") Or
intOrder 4
intOrder = intOrder + 1
Me("txtOrdDate" & intCustomer & "_" & intOrder) =
.Fields("OrderDate")
.MoveNext
Loop
Loop
.Close
End With
Set rs = Nothing
Set db = Nothing
End Sub

--
Duane Hookom
MS Access MVP


"Fehn" wrote in message
...
Does anyone know how to make this possible ad updatable in MS
Access?

Description - 12/1 - 12/2 - 12/3...... 12/31
Sample1 - 2 - - 5 .....etc
Sample2 - 6 - 8 - 3 .....etc
:
:
etc.


Thanks.

Steve

I'm not sure who "Graham Mandello" is, but I can tell you that Graham
Mandeno objects very strongly to your misuse of the newsgroups.

This community is here to provide a forum for *free* advice and assistance,
not for soliciting paid work. If, indeed as you say, over 1000 users have
come to you from the newsgroups and paid fees, however "reasonable", for
your work, then you are guilty of grossly abusing the community that we all
support.

Please don't interpret my silence in threads of this nature as tacit
approval of your behaviour. The sooner you learn to respect the etiquette
of this community, the better it will be for all of us.

--
Graham Mandeno [Access MVP]
Auckland, New Zealand


"PC Datasheet" wrote in message
ink.net...
Duane,

You continue to demonstrate that you are not even in the league with class
acts like Allen Browne, Ken Snell, Pieter Linden, Albert Kallal, Fred G,
Graham Mandello, Chuck Grimsby, MG Foster, and others.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications

www.pcdatasheet.com

Over 1050 users have come from the newsgroups trusting me and requesting
help.
My fees are very reasonable.

PC D -- Please do not put me on a "pedestal".. I object to your
solicitations, your demeanor, and your choice of how to use the language. My
"silence" just means that I pursue other means to offset your solications.

--

Ken Snell
MS ACCESS MVP


"PC Datasheet" wrote in message
ink.net...
Duane,

You continue to demonstrate that you are not even in the league with class
acts like Allen Browne, Ken Snell, Pieter Linden, Albert Kallal, Fred G,
Graham Mandello, Chuck Grimsby, MG Foster, and others.

You are your own worst enemy. It's not me or Arno R or John Marshall or
anyone else.

You post an immediate, blatant advertisement
You lash out at others who would like to stop advertising in newsgroups
You provide a novice/inflexible solution
You criticize a more professional, flexible, functional
solution that will cost much less in the long run
You refuse to either understand or admit that you understand

--
Duane Hookom
MS Access MVP
--

"PC Datasheet" wrote in message
ink.net...
Here's a rhetorical question for you ---

"Why are you so stupid?"

Thanks for providing the link where I got that!!!!!



"Duane Hookom" wrote in message
...
rhetorical question
Huh?
/rhetorical question
http://humanities.byu.edu/rhetoric/F...0questions.htm
--
Duane Hookom
MS Access MVP
--

"PC Datasheet" wrote in message
ink.net...
Duane,

One of the prime signs of a dimwit is a post like the one you just made.
You have sunk to the lowest depths with John Marshall.

This is just evidence that you don't give a damn about the newsgroups,
about polluting the newsgroups with worthless garbage and wasting a
large volume of bandwidth.



"Duane Hookom" wrote in message
...
Steve,
One of the greatest assets of a good programmer is the ability to
identify patterns. Can you see the pattern below?

News Groups
====================================
A question is posted: no advertising: No conflict
A question is posted: no advertising: No conflict
A question is posted: advertising: Lots of conflict
A question is posted: no advertising: No conflict
A question is posted: no advertising: No conflict
A question is posted: no advertising: No conflict
A question is posted: advertising: Lots of conflict

Can you find the conflicts? If you look at actual threads with
conflicts, can you find the ONE common initial element of each thread?

Do you ever see Arno R or myself or any others creating conflict
without an advertising post first?

Think about it...
--
Duane Hookom
MS Access MVP
--

"PC Datasheet" wrote in message
link.net...
Duane,

Just take a cue from the people who are class acts and quit supporting
and promoting Arno R and his band of dimwits. It's that simple. It's
not complicated. It's not difficult.

You are not impressing anyone siding with Arno R and his band of
dimwits. You don't see these class act people siding with Arno R. They
adhere to common netiquette rules. Whatever their feelings are, they
stick to helping people in the newsgroups.

There's an old saying, "birds of a feather flock together". Everyone
is seeing that you are just like Arno R and his band of dimwits.


"Duane Hookom" wrote in message
...
Steve,
Just start behaving like everyone else. It's that simple. It's not
complicated. It's not difficult.

Everyone else understands this. Everyone else is very good at
complying. Everyone else sticks fairly close to common netiquette
rules.

--
Duane Hookom
MS Access MVP
--

"PC Datasheet" wrote in message
ink.net...
Duane,

You continue to demonstrate that you are not even in the league with
class acts like Allen Browne, Ken Snell, Pieter Linden, Albert
Kallal, Fred G, Graham Mandello, Chuck Grimsby, MG Foster, and
others.

"Duane Hookom" wrote in message
...
I would keep all the data in normalized tables (and ignore or
verbally abuse PC Datasheet).

tblSamples
================
SampleID Autonumber primary key
SampleTypeID link to table containing descriptions
SampleDate
SampleValue

If you really need a form like this, consider
-writing code that loads your data into a "flat" table for editing
more code would be needed to normalize after editing
-create an unbound form like a grid of text boxes.
use code to fill the grid with data and then to
save the data to your normalized table

I wrote some code for another poster a while back the filled a
bunch of text boxes with customer names and order dates from
Northwind. One of the keys was to use a scheme for naming the text
boxes as below:

txtCust1 txtOrdDate1_1 txtOrdDate1_2 ...etc...
txtCust2 txtOrdDate2_1 txtOrdDate2_2 ...etc...
txtCust3 txtOrdDate3_1 txtOrdDate3_2 ...etc...
...etc... ...etc... ...etc... ...etc...

The code to fill the text boxes with customers and order dates:
Private Sub cmdPullOrderDates_Click()
Dim db As DAO.Database
Dim rs As DAO.Recordset
Dim strSQL As String
Dim intCustomer As Integer
Dim strCustomer As String
Dim intOrder As Integer
strSQL = "SELECT CompanyName, OrderDate " & _
"FROM Customers INNER JOIN " & _
"Orders ON Customers.CustomerID = Orders.CustomerID " & _
"ORDER BY CompanyName, OrderDate"
Set db = CurrentDb
Set rs = db.OpenRecordset(strSQL)
rs.MoveFirst
With rs
intCustomer = 0
Do Until .EOF Or intCustomer 2
strCustomer = .Fields("CompanyName")
intCustomer = intCustomer + 1
Me("txtCust" & intCustomer) = strCustomer
intOrder = 0
Do Until strCustomer .Fields("CompanyName") Or
intOrder 4
intOrder = intOrder + 1
Me("txtOrdDate" & intCustomer & "_" & intOrder) =
.Fields("OrderDate")
.MoveNext
Loop
Loop
.Close
End With
Set rs = Nothing
Set db = Nothing
End Sub

--
Duane Hookom
MS Access MVP


"Fehn" wrote in message
...
Does anyone know how to make this possible ad updatable in MS
Access?

Description - 12/1 - 12/2 - 12/3...... 12/31
Sample1 - 2 - - 5 .....etc
Sample2 - 6 - 8 - 3 .....etc
:
:
etc.


Thanks.

"Jeff Conrad" wrote in message
...

Keith answers a LOT of questions in the Security newsgroup Steve.
Do not ever forget that.


And quite a few on here and CDMA. I try not to get *too* involved in the
futility of PCD.

"PC Datasheet" wrote in message
ink.net...
Duane,

You continue to demonstrate that you are not even in the league with class
acts like Allen Browne, Ken Snell, Pieter Linden, Albert Kallal, Fred G,
Graham Mandello, Chuck Grimsby, MG Foster, and others.


So now three of your "class acts" have publicly attacked your blatant
disregard of the rules. Do you have any comment to make?

Thanks Ed!

Case A is what i want to see....
What will happen if there there is another date??

Because what I am trying to do is a form that is updatable and will be seen
like this

Case A
Description 12/1/2005 12/2/2005 12/3/2005.... 12/31/2005
Sample2 3 4 5 .... 6
Sample2 6 7 2 .... 3
Sample2 7 6 3 .... 5

DO you have any suggestion on this?

Thanks again.




"Ed Warren" wrote:

My first thought was to take my non-MVP ideas and stay home, but what fun
would that be?

In Duane's solution: you may want to consider what happens when you (or
others) manage to enter more than one case of Sample2 on the same date.

-----------------------------------data structure (Duane)
SampleID Autonumber primary key
SampleTypeID link to table containing descriptions
SampleDate
SampleValue

------------------------------------------(maybe not if you strictly use
Duane's input screen for all data input) Nothing from a data structure
perspective prevents this.
This could easily be fixed by setting a unique index to the
SampleTypeID/date pair.

SampleID SampleTypeID SampleDate SampleValue
1 2 12/1/2005 3
2 2 12/1/2005 6
3 2 12/1/2005 7
----------------------------------------------

Now what do you want to see?
Case A
Description 12/1/2005
Sample2 3
Sample2 6
Sample2 7
---------------------------
Case B
Description 12/1/2005
Sample2 16 (total)

-------------------------
Case C
Description 12/1/2005
Sample2 3 (count)
--------------------------
Case D
Description 12/1/2005
Sample2 5.3 (Avg)

If Case B,C, or D then you will want to use a pivot table/crosstab query and
do the data updates via a simple form.
If you really want only one case per day and really need to show it as a
matrix as discussed then, with the limit above you will probably want to
follow Duane's suggestion, because you will want to query the data for some
useful informtion in the future.

Ed Warren.


"Fehn" wrote in message
...
Thanks Duane! That is what I want, I want it to be updatable... I will try
other methods that other MVP's suggested.... Thanks again.....

"Duane Hookom" wrote:

A pivot or crosstab was my first thought also. However, Fehn possibly
wants
a solution that is "updatable". The pivot and crosstab work great for
presenting the data from a normalized table but unfortunately they are
not
updateable.

--
Duane Hookom
MS Access MVP
--

"Ed Warren" wrote in message
...
Your example looks a lot like a pivot table; some grouping at the top
and
left with some data in the center of the table.
You just might be able to get to where you want to be using a clever
query
and then displaying it in a pivot table.

Ed Warren.

"Fehn" wrote in message
...
Does anyone know how to make this possible ad updatable in MS Access?

Description - 12/1 - 12/2 - 12/3...... 12/31
Sample1 - 2 - - 5 .....etc
Sample2 - 6 - 8 - 3 .....etc
:
:
etc.


Thanks.

Your data table probably should look like:
TableSamples:
SampleID (key) [1,2,3,4,5,6]
SampleText [Sample1, Sample2, Sample3...]

TableSampleObservations:
ObservationID (Key) [1,2,3,4,5,.....n]
SampleID (Foreign Key) --refers to the TableSamples [1,2,3,4....]
ObservationDate (date/time) [12/1/2005, 12/2/2005, 12/3/2005....]
ObservationValue (Number: Integer) [3,4,5,6,6,7,....]

Now the question is how to build a form in the format desired then maintain
the data in the format above.
This will require some VBA coding .

Now that we have a better statement of the problem, there may be an Access
Wizard out here somewhere that can provide better advice than I can.

I would build some temp tables with
temp1:
ColumnNum:
ColumnDate:
fill with rows [1,12/1/2005; 2,12/2/2005; 3,12/3/2005....N,
12/N/2005)
I would use this as a map to go from a column to a date.
this way you can change the dates as required to map to any date in any
month
Temp2:

columns (col1... 31 as required for the month of interest)
rows: for each sample mapped to the appropriate dates
then build a form based on the temp table
then map any changes, additions, deletions back to the basic tables.

You might also look for some code that will allow you to 'transpose rows and
columns'

Ed Warren.

"Fehn" wrote in message
...
Thanks Ed!

Case A is what i want to see....
What will happen if there there is another date??

Because what I am trying to do is a form that is updatable and will be
seen
like this

Case A
Description 12/1/2005 12/2/2005 12/3/2005.... 12/31/2005
Sample2 3 4 5 .... 6
Sample2 6 7 2 .... 3
Sample2 7 6 3 .... 5

DO you have any suggestion on this?

Thanks again.




"Ed Warren" wrote:

My first thought was to take my non-MVP ideas and stay home, but what fun
would that be?

In Duane's solution: you may want to consider what happens when you (or
others) manage to enter more than one case of Sample2 on the same date.

-----------------------------------data structure (Duane)
SampleID Autonumber primary key
SampleTypeID link to table containing descriptions
SampleDate
SampleValue

------------------------------------------(maybe not if you strictly use
Duane's input screen for all data input) Nothing from a data structure
perspective prevents this.
This could easily be fixed by setting a unique index to the
SampleTypeID/date pair.

SampleID SampleTypeID SampleDate SampleValue
1 2 12/1/2005 3
2 2 12/1/2005 6
3 2 12/1/2005 7
----------------------------------------------

Now what do you want to see?
Case A
Description 12/1/2005
Sample2 3
Sample2 6
Sample2 7
---------------------------
Case B
Description 12/1/2005
Sample2 16 (total)

-------------------------
Case C
Description 12/1/2005
Sample2 3 (count)
--------------------------
Case D
Description 12/1/2005
Sample2 5.3 (Avg)

If Case B,C, or D then you will want to use a pivot table/crosstab query
and
do the data updates via a simple form.
If you really want only one case per day and really need to show it as a
matrix as discussed then, with the limit above you will probably want to
follow Duane's suggestion, because you will want to query the data for
some
useful informtion in the future.

Ed Warren.


"Fehn" wrote in message
...
Thanks Duane! That is what I want, I want it to be updatable... I will
try
other methods that other MVP's suggested.... Thanks again.....

"Duane Hookom" wrote:

A pivot or crosstab was my first thought also. However, Fehn possibly
wants
a solution that is "updatable". The pivot and crosstab work great for
presenting the data from a normalized table but unfortunately they are
not
updateable.

--
Duane Hookom
MS Access MVP
--

"Ed Warren" wrote in message
...
Your example looks a lot like a pivot table; some grouping at the
top
and
left with some data in the center of the table.
You just might be able to get to where you want to be using a clever
query
and then displaying it in a pivot table.

Ed Warren.

"Fehn" wrote in message
...
Does anyone know how to make this possible ad updatable in MS
Access?

Description - 12/1 - 12/2 - 12/3...... 12/31
Sample1 - 2 - - 5 .....etc
Sample2 - 6 - 8 - 3 .....etc
:
:
etc.


Thanks.