time & billing database

Please help, how can I show this in a form of an access database?
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/6195-time-and-billing-database.html
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6195

AutoID ProjectName 1/1/05 1/2/05 1/3/05 ...... 1/31/05
1 Proj01 4 Hrs 2 0 .... etc
2 Proj02 0 Hrs 2 0 .... etc
3 Proj03 4 Hrs 3 0 .... etc
4 Proj04 0 Hrs 1 8 .... etc
etc.

Thanks.

*

 
Do share your immediate thoughts or reactions on this issue? We value your views! Login Now! or Sign Up Today! to share your views with us.. Gurfateh!

Fehn wrote:
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6195
> Please help, how can I show this in a form of an access database?
>
> AutoID ProjectName 1/1/05 1/2/05 1/3/05 ...... 1/31/05
> 1 Proj01 4 Hrs 2 0 .... etc
> 2 Proj02 0 Hrs 2 0 .... etc
> 3 Proj03 4 Hrs 3 0 .... etc
> 4 Proj04 0 Hrs 1 8 .... etc
> etc.
>
> Thanks.

First step is saving the information in an Access Database.

It appears you have fields for each date and a field for each project.
Normally it is better to have one table for projects listing the project,
maybe a description and information unique to that project. Next you would
have a second table where all the hours go linked to the first table. A
record in the second table would have things like the date, number of hours,
maybe who billed the hours etc. Each entry would be a separate record.

Is this how your data is recorded?



--
Joseph Meehan

Dia duit

Hi Fehn,

Would you be happy with the results of a crosstab query, without attempting
to display the results in a form? If so, check out this link:

Crosstab Queries
http://www.access.qbuilt.com/html/crosstab_queries.html
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6195
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6195


While you can display the results of a crosstab query in a form, you will
need to use a bit of complicated VBA code if the dates are not static. At
this point, you'd probably be better off to use a PivotTable if you have
Access 2002 or later.


Tom

http://www.access.qbuilt.com/html/ex...tributors.html
__________________________________________

"Fehn" wrote:

Please help, how can I show this in a form of an access database?

AutoID ProjectName 1/1/05 1/2/05 1/3/05 ...... 1/31/05
1 Proj01 4 Hrs 2 0 .... etc
2 Proj02 0 Hrs 2 0 .... etc
3 Proj03 4 Hrs 3 0 .... etc
4 Proj04 0 Hrs 1 8 .... etc
etc.

Thanks.

Yes Joseph, this is how the data is recorded in excel.

Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6195
The projectname is actually link to another table that have all the projects.

Every month we are creating an excel spread for the time sheet and the only
change in the spreadsheet is the dates.


"Joseph Meehan" wrote:

> Fehn wrote:
> > Please help, how can I show this in a form of an access database?
> >
> > AutoID ProjectName 1/1/05 1/2/05 1/3/05 ...... 1/31/05
> > 1 Proj01 4 Hrs 2 0 .... etc
> > 2 Proj02 0 Hrs 2 0 .... etc
> > 3 Proj03 4 Hrs 3 0 .... etc
> > 4 Proj04 0 Hrs 1 8 .... etc
> > etc.
> >
> > Thanks.
>
> First step is saving the information in an Access Database.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6195
>
> It appears you have fields for each date and a field for each project.
> Normally it is better to have one table for projects listing the project,
> maybe a description and information unique to that project. Next you would
> have a second table where all the hours go linked to the first table. A
> record in the second table would have things like the date, number of hours,
> maybe who billed the hours etc. Each entry would be a separate record.
>
> Is this how your data is recorded?
>
>
>
> --
> Joseph Meehan
>
> Dia duit
>
>
>

Thanks Tom.

I will wheck that link.

Just a brief history on why im doing this.

Before I have a databse that shows the following:

Date ProjectName NumHrs
1/1/05 Project01 4
1/1/05 Project02 4
1/2/05 Project01 4
1/2/05 Project01 2
1/2/05 Project01 2
etc.

My co workers doesn't like that form.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6195

They want a to have all the days of the month showing up on the form and all
they need to do is put the project name and the corresponding hours that they
worked on days that they worked.

So I made that in excel. But I still want to use access.

Thanks.

"Tom Wickerath" wrote:

> Hi Fehn,
>
> Would you be happy with the results of a crosstab query, without attempting
> to display the results in a form? If so, check out this link:
>
> Crosstab Queries
> http://www.access.qbuilt.com/html/crosstab_queries.html
>
>
> While you can display the results of a crosstab query in a form, you will
> need to use a bit of complicated VBA code if the dates are not static. At
> this point, you'd probably be better off to use a PivotTable if you have
> Access 2002 or later.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6195
>
>
> Tom
>
> http://www.access.qbuilt.com/html/ex...tributors.html
> __________________________________________
>
> "Fehn" wrote:
>
> Please help, how can I show this in a form of an access database?
>
> AutoID ProjectName 1/1/05 1/2/05 1/3/05 ...... 1/31/05
> 1 Proj01 4 Hrs 2 0 .... etc
> 2 Proj02 0 Hrs 2 0 .... etc
> 3 Proj03 4 Hrs 3 0 .... etc
> 4 Proj04 0 Hrs 1 8 .... etc
> etc.
>
> Thanks.
>

Fehn wrote:
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6195
> Yes Joseph, this is how the data is recorded in excel.
>
> The projectname is actually link to another table that have all the
> projects.
>
> Every month we are creating an excel spread for the time sheet and
> the only change in the spreadsheet is the dates.

So the data started out in Excel. OK I see the problem. I would like
to see it imported into Access in a normalized table design.

Will you be taking this project into Access or will it be run on both
Access and Excel?

It is is being done over in Access, I suggest you change the way the
data is stored and use related normalized tables before you worry about how
it will be displayed. I believe that once normalized properly you will find
it far easier to produce the final product and have it work like the users
want.

>
>
> "Joseph Meehan" wrote:
>
>> Fehn wrote:
>> > Please help, how can I show this in a form of an access database?
>> >
>> > AutoID ProjectName 1/1/05 1/2/05 1/3/05 ...... 1/31/05
>> > 1 Proj01 4 Hrs 2 0 .... etc
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6195
>> > 2 Proj02 0 Hrs 2 0 .... etc
>> > 3 Proj03 4 Hrs 3 0 .... etc
>> > 4 Proj04 0 Hrs 1 8 .... etc
>> > etc.
>> >
>> > Thanks.
>>
>> First step is saving the information in an Access Database.
>>
>> It appears you have fields for each date and a field for each
>> project. Normally it is better to have one table for projects
>> listing the project, maybe a description and information unique to
>> that project. Next you would have a second table where all the
>> hours go linked to the first table. A record in the second table
>> would have things like the date, number of hours, maybe who billed
>> the hours etc. Each entry would be a separate record.
>>
>> Is this how your data is recorded?
>>
>>
>>
>> --
>> Joseph Meehan
>>
>> Dia duit

--
Joseph Meehan

Dia duit

Once I got this working in access, then they will use only access.

Just a brief history on why im doing this.

Before I have a databse that shows the following:

Date ProjectName NumHrs
1/1/05 Project01 4
1/1/05 Project02 4
1/2/05 Project01 4
1/2/05 Project01 2
1/2/05 Project01 2
etc.

My co workers doesn't like that form.

They want a to have all the days of the month showing up on the form and all
they need to do is put the project name and the corresponding hours that they
worked on days that they worked

Thanks.


"Joseph Meehan" wrote:

> Fehn wrote:
> > Yes Joseph, this is how the data is recorded in excel.
> >
> > The projectname is actually link to another table that have all the
> > projects.
> >
> > Every month we are creating an excel spread for the time sheet and
> > the only change in the spreadsheet is the dates.
>
> So the data started out in Excel. OK I see the problem. I would like
> to see it imported into Access in a normalized table design.
>
> Will you be taking this project into Access or will it be run on both
> Access and Excel?
>
> It is is being done over in Access, I suggest you change the way the
> data is stored and use related normalized tables before you worry about how
> it will be displayed. I believe that once normalized properly you will find
> it far easier to produce the final product and have it work like the users
> want.
>
> >
> >
> > "Joseph Meehan" wrote:
> >
> >> Fehn wrote:
> >> > Please help, how can I show this in a form of an access database?
> >> >
> >> > AutoID ProjectName 1/1/05 1/2/05 1/3/05 ...... 1/31/05
> >> > 1 Proj01 4 Hrs 2 0 .... etc
> >> > 2 Proj02 0 Hrs 2 0 .... etc
> >> > 3 Proj03 4 Hrs 3 0 .... etc
> >> > 4 Proj04 0 Hrs 1 8 .... etc
> >> > etc.
> >> >
> >> > Thanks.
> >>
> >> First step is saving the information in an Access Database.
> >>
> >> It appears you have fields for each date and a field for each
> >> project. Normally it is better to have one table for projects
> >> listing the project, maybe a description and information unique to
> >> that project. Next you would have a second table where all the
> >> hours go linked to the first table. A record in the second table
> >> would have things like the date, number of hours, maybe who billed
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6195
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6195
> >> the hours etc. Each entry would be a separate record.
> >>
> >> Is this how your data is recorded?
> >>
> >>
> >>
> >> --
> >> Joseph Meehan
> >>
> >> Dia duit
>
> --
> Joseph Meehan
>
> Dia duit
>
>
>

Hi Fehn,

In that case, a crosstab query will not be helpful because it produces a
read only recordset.


Tom

http://www.access.qbuilt.com/html/ex...tributors.html
__________________________________________

"Fehn" wrote:

Thanks Tom.

I will wheck that link.

Just a brief history on why im doing this.

Before I have a databse that shows the following:

Date ProjectName NumHrs
1/1/05 Project01 4
1/1/05 Project02 4
1/2/05 Project01 4
1/2/05 Project01 2
1/2/05 Project01 2
etc.

My co workers doesn't like that form.

They want a to have all the days of the month showing up on the form and all
they need to do is put the project name and the corresponding hours that they
worked on days that they worked.

So I made that in excel. But I still want to use access.

Thanks.
__________________________________________

"Tom Wickerath" wrote:

Hi Fehn,

Would you be happy with the results of a crosstab query, without attempting
to display the results in a form? If so, check out this link:

Crosstab Queries
http://www.access.qbuilt.com/html/crosstab_queries.html
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6195


While you can display the results of a crosstab query in a form, you will
need to use a bit of complicated VBA code if the dates are not static. At
this point, you'd probably be better off to use a PivotTable if you have
Access 2002 or later.


Tom

http://www.access.qbuilt.com/html/ex...tributors.html
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6195
__________________________________________

"Fehn" wrote:

Please help, how can I show this in a form of an access database?

AutoID ProjectName 1/1/05 1/2/05 1/3/05 ...... 1/31/05
1 Proj01 4 Hrs 2 0 .... etc
2 Proj02 0 Hrs 2 0 .... etc
3 Proj03 4 Hrs 3 0 .... etc
4 Proj04 0 Hrs 1 8 .... etc
etc.

Thanks.

Hi Tom,

Do you have any suggestions on what i need to do?

Thanks


"Tom Wickerath" wrote:

> Hi Fehn,
>
> In that case, a crosstab query will not be helpful because it produces a
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6195
> read only recordset.
>
>
> Tom
>
> http://www.access.qbuilt.com/html/ex...tributors.html
> __________________________________________
>
> "Fehn" wrote:
>
> Thanks Tom.
>
> I will wheck that link.
>
> Just a brief history on why im doing this.
>
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6195
> Before I have a databse that shows the following:
>
> Date ProjectName NumHrs
> 1/1/05 Project01 4
> 1/1/05 Project02 4
> 1/2/05 Project01 4
> 1/2/05 Project01 2
> 1/2/05 Project01 2
> etc.
>
> My co workers doesn't like that form.
>
> They want a to have all the days of the month showing up on the form and all
> they need to do is put the project name and the corresponding hours that they
> worked on days that they worked.
>
> So I made that in excel. But I still want to use access.
>
> Thanks.
> __________________________________________
>
> "Tom Wickerath" wrote:
>
> Hi Fehn,
>
> Would you be happy with the results of a crosstab query, without attempting
> to display the results in a form? If so, check out this link:
>
> Crosstab Queries
> http://www.access.qbuilt.com/html/crosstab_queries.html
>
>
> While you can display the results of a crosstab query in a form, you will
> need to use a bit of complicated VBA code if the dates are not static. At
> this point, you'd probably be better off to use a PivotTable if you have
> Access 2002 or later.
>
>
> Tom
>
> http://www.access.qbuilt.com/html/ex...tributors.html
> __________________________________________
>
> "Fehn" wrote:
>
> Please help, how can I show this in a form of an access database?
>
> AutoID ProjectName 1/1/05 1/2/05 1/3/05 ...... 1/31/05
> 1 Proj01 4 Hrs 2 0 .... etc
> 2 Proj02 0 Hrs 2 0 .... etc
> 3 Proj03 4 Hrs 3 0 .... etc
> 4 Proj04 0 Hrs 1 8 .... etc
> etc.
>
> Thanks.