I have hit a wall on a database that I have been working on, so far I have
two fields that are calculated from different queries [tothrday] [torearnday]

Employee day pay calculated by number of products at rate 1 + product2 at
rate 1 (i.e. 55.00)

Employee Day hours Calculated using the "On Time and How Much Has Elapsed"
script on, time in - time out - total breaks in hr:mm (i.e. 5:00)

I have been trying to calculate the rate, in my head as example above it is
easy £11/Hr but I can not get access to understand what query I want it to
calculate [torearnday] / [tothrday]= #Error

This is my first database so I have been guided by the help links within
access and a dummies book but can not find a solution, any help appreciated.

Cheers
Rob

RobJ

I can't tell from your description what formula you are using to do the
calculation "in your head". If you were to write the formula down and pass
it to a clerk to do, how would it look?

Is that the "[torearnday] / [tothrday]= " that you described? Please post
the SQL of your query.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP
http://mvp.support.microsoft.com/

Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/


"RobJ" <(E-Mail Removed)> wrote in message
news:268A67D6-715B-4C79-8D75-(E-Mail Removed)...
> I have hit a wall on a database that I have been working on, so far I have
> two fields that are calculated from different queries [tothrday]
[torearnday]
>
> Employee day pay calculated by number of products at rate 1 + product2 at
> rate 1 (i.e. 55.00)
>
> Employee Day hours Calculated using the "On Time and How Much Has Elapsed"
> script on, time in - time out - total breaks in hr:mm (i.e. 5:00)
>
> I have been trying to calculate the rate, in my head as example above it
is
> easy £11/Hr but I can not get access to understand what query I want it to
> calculate [torearnday] / [tothrday]= #Error
>
> This is my first database so I have been guided by the help links within
> access and a dummies book but can not find a solution, any help
appreciated.
>
> Cheers
> Rob
>

One query works out how much the employee earned in on day
Another works out how many hours:minutes they worked in a day
I want to work out the hourly rate of pay

So day 1
Earned £55
Worked for 5 hours
55 / 5 = 11 (£11/hr)

I believe the error is due to the hh:mm format of the time field



"Jeff Boyce" wrote:

> RobJ
>
> I can't tell from your description what formula you are using to do the
> calculation "in your head". If you were to write the formula down and pass
> it to a clerk to do, how would it look?
>
> Is that the "[torearnday] / [tothrday]= " that you described? Please post
> the SQL of your query.
>
> --
> Regards
>
> Jeff Boyce
> Microsoft Office/Access MVP
> http://mvp.support.microsoft.com/
>
> Microsoft IT Academy Program Mentor
> http://microsoftitacademy.com/
>
>
> "RobJ" <(E-Mail Removed)> wrote in message
> news:268A67D6-715B-4C79-8D75-(E-Mail Removed)...
> > I have hit a wall on a database that I have been working on, so far I have
> > two fields that are calculated from different queries [tothrday]
> [torearnday]
> >
> > Employee day pay calculated by number of products at rate 1 + product2 at
> > rate 1 (i.e. 55.00)
> >
> > Employee Day hours Calculated using the "On Time and How Much Has Elapsed"
> > script on, time in - time out - total breaks in hr:mm (i.e. 5:00)
> >
> > I have been trying to calculate the rate, in my head as example above it
> is
> > easy £11/Hr but I can not get access to understand what query I want it to
> > calculate [torearnday] / [tothrday]= #Error
> >
> > This is my first database so I have been guided by the help links within
> > access and a dummies book but can not find a solution, any help
> appreciated.
> >
> > Cheers
> > Rob
> >
>
>

RobJ

We're not there. We can't see your fields. We can't see your query SQL.

If you want more specific suggestions, post more specific information.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP
http://mvp.support.microsoft.com/

Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/


"RobJ" <(E-Mail Removed)> wrote in message
news:2FD05DEF-5CA8-49D2-A51F-(E-Mail Removed)...
> One query works out how much the employee earned in on day
> Another works out how many hours:minutes they worked in a day
> I want to work out the hourly rate of pay
>
> So day 1
> Earned £55
> Worked for 5 hours
> 55 / 5 = 11 (£11/hr)
>
> I believe the error is due to the hh:mm format of the time field
>
>
>
> "Jeff Boyce" wrote:
>
> > RobJ
> >
> > I can't tell from your description what formula you are using to do the
> > calculation "in your head". If you were to write the formula down and
pass
> > it to a clerk to do, how would it look?
> >
> > Is that the "[torearnday] / [tothrday]= " that you described? Please
post
> > the SQL of your query.
> >
> > --
> > Regards
> >
> > Jeff Boyce
> > Microsoft Office/Access MVP
> > http://mvp.support.microsoft.com/
> >
> > Microsoft IT Academy Program Mentor
> > http://microsoftitacademy.com/
> >
> >
> > "RobJ" <(E-Mail Removed)> wrote in message
> > news:268A67D6-715B-4C79-8D75-(E-Mail Removed)...
> > > I have hit a wall on a database that I have been working on, so far I
have
> > > two fields that are calculated from different queries [tothrday]
> > [torearnday]
> > >
> > > Employee day pay calculated by number of products at rate 1 + product2
at
> > > rate 1 (i.e. 55.00)
> > >
> > > Employee Day hours Calculated using the "On Time and How Much Has
Elapsed"
> > > script on, time in - time out - total breaks in hr:mm (i.e. 5:00)
> > >
> > > I have been trying to calculate the rate, in my head as example above
it
> > is
> > > easy £11/Hr but I can not get access to understand what query I want
it to
> > > calculate [torearnday] / [tothrday]= #Error
> > >
> > > This is my first database so I have been guided by the help links
within
> > > access and a dummies book but can not find a solution, any help
> > appreciated.
> > >
> > > Cheers
> > > Rob
> > >
> >
> >

Hi Jeff,

Sorry I do not understand, I can email you the database but where do I find
the SQL?

I have found some code but that appears to be for the forms as VB code.

Rob



"Jeff Boyce" wrote:

> RobJ
>
> We're not there. We can't see your fields. We can't see your query SQL.
>
> If you want more specific suggestions, post more specific information.
>
> --
> Regards
>
> Jeff Boyce
> Microsoft Office/Access MVP
> http://mvp.support.microsoft.com/
>
> Microsoft IT Academy Program Mentor
> http://microsoftitacademy.com/
>
>
> "RobJ" <(E-Mail Removed)> wrote in message
> news:2FD05DEF-5CA8-49D2-A51F-(E-Mail Removed)...
> > One query works out how much the employee earned in on day
> > Another works out how many hours:minutes they worked in a day
> > I want to work out the hourly rate of pay
> >
> > So day 1
> > Earned £55
> > Worked for 5 hours
> > 55 / 5 = 11 (£11/hr)
> >
> > I believe the error is due to the hh:mm format of the time field
> >
> >
> >
> > "Jeff Boyce" wrote:
> >
> > > RobJ
> > >
> > > I can't tell from your description what formula you are using to do the
> > > calculation "in your head". If you were to write the formula down and
> pass
> > > it to a clerk to do, how would it look?
> > >
> > > Is that the "[torearnday] / [tothrday]= " that you described? Please
> post
> > > the SQL of your query.
> > >
> > > --
> > > Regards
> > >
> > > Jeff Boyce
> > > Microsoft Office/Access MVP
> > > http://mvp.support.microsoft.com/
> > >
> > > Microsoft IT Academy Program Mentor
> > > http://microsoftitacademy.com/
> > >
> > >
> > > "RobJ" <(E-Mail Removed)> wrote in message
> > > news:268A67D6-715B-4C79-8D75-(E-Mail Removed)...
> > > > I have hit a wall on a database that I have been working on, so far I
> have
> > > > two fields that are calculated from different queries [tothrday]
> > > [torearnday]
> > > >
> > > > Employee day pay calculated by number of products at rate 1 + product2
> at
> > > > rate 1 (i.e. 55.00)
> > > >
> > > > Employee Day hours Calculated using the "On Time and How Much Has
> Elapsed"
> > > > script on, time in - time out - total breaks in hr:mm (i.e. 5:00)
> > > >
> > > > I have been trying to calculate the rate, in my head as example above
> it
> > > is
> > > > easy £11/Hr but I can not get access to understand what query I want
> it to
> > > > calculate [torearnday] / [tothrday]= #Error
> > > >
> > > > This is my first database so I have been guided by the help links
> within
> > > > access and a dummies book but can not find a solution, any help
> > > appreciated.
> > > >
> > > > Cheers
> > > > Rob
> > > >
> > >
> > >
>
>

Open the query. Click View > SQL.

It may help to edit a copy of the query in order to remove fields that are
not necessary to the problem at hand before you copy the SQL. I can't
really suggest anything to omit since I don't know any details of your
database.

"RobJ" <(E-Mail Removed)> wrote in message
news:1BBD26D9-3FAA-4EFA-B758-(E-Mail Removed)...
> Hi Jeff,
>
> Sorry I do not understand, I can email you the database but where do I
> find
> the SQL?
>
> I have found some code but that appears to be for the forms as VB code.
>
> Rob
>
>
>
> "Jeff Boyce" wrote:
>
>> RobJ
>>
>> We're not there. We can't see your fields. We can't see your query SQL.
>>
>> If you want more specific suggestions, post more specific information.
>>
>> --
>> Regards
>>
>> Jeff Boyce
>> Microsoft Office/Access MVP
>> http://mvp.support.microsoft.com/
>>
>> Microsoft IT Academy Program Mentor
>> http://microsoftitacademy.com/
>>
>>
>> "RobJ" <(E-Mail Removed)> wrote in message
>> news:2FD05DEF-5CA8-49D2-A51F-(E-Mail Removed)...
>> > One query works out how much the employee earned in on day
>> > Another works out how many hours:minutes they worked in a day
>> > I want to work out the hourly rate of pay
>> >
>> > So day 1
>> > Earned £55
>> > Worked for 5 hours
>> > 55 / 5 = 11 (£11/hr)
>> >
>> > I believe the error is due to the hh:mm format of the time field
>> >
>> >
>> >
>> > "Jeff Boyce" wrote:
>> >
>> > > RobJ
>> > >
>> > > I can't tell from your description what formula you are using to do
>> > > the
>> > > calculation "in your head". If you were to write the formula down
>> > > and
>> pass
>> > > it to a clerk to do, how would it look?
>> > >
>> > > Is that the "[torearnday] / [tothrday]= " that you described? Please
>> post
>> > > the SQL of your query.
>> > >
>> > > --
>> > > Regards
>> > >
>> > > Jeff Boyce
>> > > Microsoft Office/Access MVP
>> > > http://mvp.support.microsoft.com/
>> > >
>> > > Microsoft IT Academy Program Mentor
>> > > http://microsoftitacademy.com/
>> > >
>> > >
>> > > "RobJ" <(E-Mail Removed)> wrote in message
>> > > news:268A67D6-715B-4C79-8D75-(E-Mail Removed)...
>> > > > I have hit a wall on a database that I have been working on, so far
>> > > > I
>> have
>> > > > two fields that are calculated from different queries [tothrday]
>> > > [torearnday]
>> > > >
>> > > > Employee day pay calculated by number of products at rate 1 +
>> > > > product2
>> at
>> > > > rate 1 (i.e. 55.00)
>> > > >
>> > > > Employee Day hours Calculated using the "On Time and How Much Has
>> Elapsed"
>> > > > script on, time in - time out - total breaks in hr:mm (i.e. 5:00)
>> > > >
>> > > > I have been trying to calculate the rate, in my head as example
>> > > > above
>> it
>> > > is
>> > > > easy £11/Hr but I can not get access to understand what query I
>> > > > want
>> it to
>> > > > calculate [torearnday] / [tothrday]= #Error
>> > > >
>> > > > This is my first database so I have been guided by the help links
>> within
>> > > > access and a dummies book but can not find a solution, any help
>> > > appreciated.
>> > > >
>> > > > Cheers
>> > > > Rob
>> > > >
>> > >
>> > >
>>
>>