Query to divide.

[AndrewB]

Hi All,

Can someone assist me with a query? I need field Expr1: [Results] to
divide [Rate Total] by [Contracted Rate]. Rate Total and Contracted rates
are in 2 seperate tables I brought into the query but can't seem to get the
right syntax for the division.

Help

Thanks,

 

[John W. Vinson]

Hi All,

Can someone assist me with a query? I need field Expr1: [Results] to
divide [Rate Total] by [Contracted Rate]. Rate Total and Contracted rates
are in 2 seperate tables I brought into the query but can't seem to get the
right syntax for the division.

Help

Thanks,

How are the tables joined in the query? What error are you getting? Could you
post the SQL view of your query as it stands now, and what error you're
getting?

 

[Golfinray]

Results:[tableratetotalisin!rate total]/[tablecontractedrateisin!contracted
rate]

 

[AndrewB]

Thanks so much Golfinray !
--
AndrewB.

Results:[tableratetotalisin!rate total]/[tablecontractedrateisin!contracted
rate]

Hi All,

Can someone assist me with a query? I need field Expr1: [Results] to
divide [Rate Total] by [Contracted Rate]. Rate Total and Contracted rates
are in 2 seperate tables I brought into the query but can't seem to get the
right syntax for the division.

Help

Thanks,

 

[AndrewB]

Thanks for replying John! I figured it out

ajb
--
AndrewB.

Hi All,

Can someone assist me with a query? I need field Expr1: [Results] to
divide [Rate Total] by [Contracted Rate]. Rate Total and Contracted rates
are in 2 seperate tables I brought into the query but can't seem to get the
right syntax for the division.

Help

Thanks,

How are the tables joined in the query? What error are you getting? Could you
post the SQL view of your query as it stands now, and what error you're
getting?