473,322 Members | 1,345 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

simple query results, yet a difficult way to get to them...

Hi all,
I'm using MS Access 2003.
Bare with me on this description....here's the situation: Imagine insurance,
and working out premiums for different insured properties. The rates for
calculating premiums are dependant on the country in which the client is in.
Therefore, we have a Country table, with its list of rates, a client table
and then the property table. Getting this is great, works fine, easy!
Problem is, now I need to work out a way for special cases - a client within
a country might have their own rate instead of using the "global" rate for
the whole country. And what's worse, a client might have several groups of
rates. So I need a system that will allow the user to be able to choose
which set of rates to use to calculate the premiums for that client. I
created another table called ClientRates, and that's linked to the Client
table, in a many-to-one relationship.
Creating a query that takes rates from one table and multiplies with other
values, and then gives you the premiums is easy, but is there a way to allow
the user to choose which set of rates to use for that specific instance?
Some kind of drop-down list before doing the calculation. I can't imagine
that's possible...but is there any other way?

Here's an image of the tables and their relationships.
http://img106.exs.cx/my.php?loc=img1...ationships.jpg

Thanks a lot for all the help. I hope I made enough sense.
Dejan
Nov 13 '05 #1
4 2036
HJ
There are a lot of ways to accomplish this. I will describe one method,
which may of course not be the optimal one for you; and others may disagree
or come with alternatives.

First, I would like to make a note about the relationships you have defined
between the client, client rates and property tables. You base these
relationships on the ClientName field. That is not a good thing to do,
because you may have two clients with exactly the same name. It is therefor
better to add a ClientID field to the tbl_Client table that has the
AutoNumber type. And in the tbl_ClientRates and tbl_Property you add a
corresponding field, e.g. ClientID or ClientRatesClientID and
PropertyClientID. (The names only matter for your own reference, as long
they are Number (Long Integer)).

Then your actual question. You may add two fields to the tbl_Client table:
ClientSpecialRate (Yes/No) and ClientSpecialRateID (Number, Long Integer).
On your form you add a checkbox, e.g. chkClientSpecialRate, and a combo box,
e.g. cboClientSpecialRate. I suppose you will have the checkbox unselected
by default and the combo box disabled (greyed out) by default.

The combo box' control source is your new field ClientSpecialRateID and the
row source is something like 'Select ClientRatesID, ClientRateName From
tbl_ClientRates Where ClientRatesClientID = ClientID'. When you select the
checkbox you can have the combo box enabled.

Then in your premium calculation query you have your formulas looks at the
ClientSpecialRate Yes/No field. If Yes, then use the data from the
corresponding row in tbl_ClientRates. If No, use the country info.

I hope this helps.

HJ

"d.p." <no@spam.never> wrote in message
news:41**********************@news.zen.co.uk...
Hi all,
I'm using MS Access 2003.
Bare with me on this description....here's the situation: Imagine insurance, and working out premiums for different insured properties. The rates for
calculating premiums are dependant on the country in which the client is in. Therefore, we have a Country table, with its list of rates, a client table
and then the property table. Getting this is great, works fine, easy!
Problem is, now I need to work out a way for special cases - a client within a country might have their own rate instead of using the "global" rate for
the whole country. And what's worse, a client might have several groups of
rates. So I need a system that will allow the user to be able to choose
which set of rates to use to calculate the premiums for that client. I
created another table called ClientRates, and that's linked to the Client
table, in a many-to-one relationship.
Creating a query that takes rates from one table and multiplies with other
values, and then gives you the premiums is easy, but is there a way to allow the user to choose which set of rates to use for that specific instance?
Some kind of drop-down list before doing the calculation. I can't imagine
that's possible...but is there any other way?

Here's an image of the tables and their relationships.
http://img106.exs.cx/my.php?loc=img1...ationships.jpg

Thanks a lot for all the help. I hope I made enough sense.
Dejan

Nov 13 '05 #2
thanks a lot HJ!
this sounds very possible. I haven't had a chance to mess with it the past 2
days, but I'll definintely give your suggestion a go. I'm not that skillful
at Access, but learning slowly. I hope I can figure this out. I'll give a
shout if i run into things :-)

Oh, about the primary key for the client...I made it ClientName because I
know definitely that it'll be different for every client (it's just the way
this company names it), although I'll consider just giving it an ID field,
just for consistency at least.

You also said this at the end:
Then in your premium calculation query you have your formulas looks at the
ClientSpecialRate Yes/No field. If Yes, then use the data from the
corresponding row in tbl_ClientRates. If No, use the country info.
Sorry to be a bit less knowledgable now, but how would an SQL statement look
at a check box and then determine what to use? Here's the SQL statement that
was generated by Access, so you can see the current query. If you have a
diff suggestion, please feel free to say:

SELECT
tbl_Property.ClientName,
tbl_Property.PropertyName,
tbl_Country.CountryCurrency,
[tbl_Property.PropertyBuildValue]*[tbl_CountryInfo.CountryBuildRate] AS
PremiumBuildValue,
[tbl_Property.PropertyContValue]*[tbl_CountryInfo.CountryContRate] AS
PremiumContValue,
[tbl_Property.PropertyStockValue]*[tbl_CountryInfo.CountryStockRate] AS
PremiumStockValue,
[tbl_Property.PropertyElecEqValue]*[tbl_CountryInfo.CountryElecEqRate] AS
PremiumEleqEqValue,
[tbl_Property.PropertyEQCover]*[tbl_CountryInfo.CountryEQRate] AS
PremiumEQCover,
[tbl_Property.PropertySGValue]*[tbl_CountryInfo.CountrySGRate] AS
PremiumSGValue,
[tbl_Property.PropertyBICover]*[tbl_CountryInfo.CountryBIRate] AS
PremiumBICover,
[tbl_Property.PropertyRoDCover]*[tbl_CountryInfo.CountryRoDRate] AS
PremiumRoDCover,
tbl_Property.PropertyNotes

FROM
tbl_Country INNER JOIN ((tbl_Client INNER JOIN tbl_CountryInfo ON
tbl_Client.CountryCode = tbl_CountryInfo.CountryCode) INNER JOIN
tbl_Property ON tbl_Client.ClientName = tbl_Property.ClientName) ON
(tbl_Country.CountryCode = tbl_CountryInfo.CountryCode) AND
(tbl_Country.CountryCode = tbl_Client.CountryCode);

Thanks so much for the help! I really appretiate it!

Dejan

"HJ" <hj********@spamhotmail.com> wrote in message
news:41***********************@news.xs4all.nl... There are a lot of ways to accomplish this. I will describe one method,
which may of course not be the optimal one for you; and others may disagree or come with alternatives.

First, I would like to make a note about the relationships you have defined between the client, client rates and property tables. You base these
relationships on the ClientName field. That is not a good thing to do,
because you may have two clients with exactly the same name. It is therefor better to add a ClientID field to the tbl_Client table that has the
AutoNumber type. And in the tbl_ClientRates and tbl_Property you add a
corresponding field, e.g. ClientID or ClientRatesClientID and
PropertyClientID. (The names only matter for your own reference, as long
they are Number (Long Integer)).

Then your actual question. You may add two fields to the tbl_Client table:
ClientSpecialRate (Yes/No) and ClientSpecialRateID (Number, Long Integer).
On your form you add a checkbox, e.g. chkClientSpecialRate, and a combo box, e.g. cboClientSpecialRate. I suppose you will have the checkbox unselected
by default and the combo box disabled (greyed out) by default.

The combo box' control source is your new field ClientSpecialRateID and the row source is something like 'Select ClientRatesID, ClientRateName From
tbl_ClientRates Where ClientRatesClientID = ClientID'. When you select the
checkbox you can have the combo box enabled.

Then in your premium calculation query you have your formulas looks at the
ClientSpecialRate Yes/No field. If Yes, then use the data from the
corresponding row in tbl_ClientRates. If No, use the country info.

I hope this helps.

HJ

"d.p." <no@spam.never> wrote in message
news:41**********************@news.zen.co.uk...
Hi all,
I'm using MS Access 2003.
Bare with me on this description....here's the situation: Imagine

insurance,
and working out premiums for different insured properties. The rates for
calculating premiums are dependant on the country in which the client is

in.
Therefore, we have a Country table, with its list of rates, a client table and then the property table. Getting this is great, works fine, easy!
Problem is, now I need to work out a way for special cases - a client

within
a country might have their own rate instead of using the "global" rate for the whole country. And what's worse, a client might have several groups of rates. So I need a system that will allow the user to be able to choose
which set of rates to use to calculate the premiums for that client. I
created another table called ClientRates, and that's linked to the Client table, in a many-to-one relationship.
Creating a query that takes rates from one table and multiplies with other values, and then gives you the premiums is easy, but is there a way to

allow
the user to choose which set of rates to use for that specific instance?
Some kind of drop-down list before doing the calculation. I can't imagine that's possible...but is there any other way?

Here's an image of the tables and their relationships.
http://img106.exs.cx/my.php?loc=img1...ationships.jpg

Thanks a lot for all the help. I hope I made enough sense.
Dejan


Nov 13 '05 #3
HJ
Hi DP,

If I primarily focus at your query, and if I do not use any VBA code, you
can have a look at http://www.xs4all.nl/~hjm/images/dp/QueryForDP.jpg (SQL
statement is printed below; image stays online for only a few days).

You see a few adjustments to the tables and one supplement to the query.
That is the Left Join for the tbl_ClientRates table. I have now only
adjusted the calculation for the PremiumBuildValue field; you can do the
rest.

In the example for the PremiumBuildValue you see that if the
ClientSpecialRate Yes/No field has been selected (=Yes), then the special
build rate is being used. If the ClientSpecialRate field has not been
selected, then the general CountryBuildRate is used.

Beware of the Left Join to the ClientRates table. You do need that type of
relationship, because you may not have special rates for every client in
your database.

HJ

To make it easier for you to rebuild the drawn query, here is the SQL
statement:

SELECT tbl_Client.ClientName, tbl_Property.PropertyName,
tbl_Country.CountryCurrency,
[tbl_Property.PropertyBuildValue]*IIf([ClientSpecialRate],[tbl_ClientRates.C
lientBuildRate],[tbl_Country.CountryBuildRate]) AS PremiumBuildValue,
[tbl_Property.PropertyContValue]*[tbl_Country.CountryContRate] AS
PremiumContValue,
[tbl_Property.PropertyStockValue]*[tbl_Country.CountryStockRate] AS
PremiumStockValue,
[tbl_Property.PropertyElecEqValue]*[tbl_Country.CountryElecEqRate] AS
PremiumEleqEqValue,
[tbl_Property.PropertyEQCover]*[tbl_Country.CountryEQRate] AS
PremiumEQCover, [tbl_Property.PropertySGValue]*[tbl_Country.CountrySGRate]
AS PremiumSGValue,
[tbl_Property.PropertyBICover]*[tbl_Country.CountryBIRate] AS
PremiumBICover, [tbl_Property.PropertyRoDCover]*[tbl_Country.CountryRoDRate]
AS PremiumRoDCover, tbl_Property.PropertyNotes
FROM ((tbl_Country INNER JOIN tbl_Client ON tbl_Country.CountryCode =
tbl_Client.CountryCode) INNER JOIN tbl_Property ON tbl_Client.ClientID =
tbl_Property.PropertyClientID) LEFT JOIN tbl_ClientRates ON
tbl_Client.ClientSpecialRateID = tbl_ClientRates.ClientRatesID;

"d.p." <no@spam.never> wrote in message
news:41**********************@news.zen.co.uk...
thanks a lot HJ!
this sounds very possible. I haven't had a chance to mess with it the past 2 days, but I'll definintely give your suggestion a go. I'm not that skillful at Access, but learning slowly. I hope I can figure this out. I'll give a
shout if i run into things :-)

Oh, about the primary key for the client...I made it ClientName because I
know definitely that it'll be different for every client (it's just the way this company names it), although I'll consider just giving it an ID field,
just for consistency at least.

You also said this at the end:
Then in your premium calculation query you have your formulas looks at the
ClientSpecialRate Yes/No field. If Yes, then use the data from the
corresponding row in tbl_ClientRates. If No, use the country info.
Sorry to be a bit less knowledgable now, but how would an SQL statement

look at a check box and then determine what to use? Here's the SQL statement that was generated by Access, so you can see the current query. If you have a
diff suggestion, please feel free to say:

SELECT
tbl_Property.ClientName,
tbl_Property.PropertyName,
tbl_Country.CountryCurrency,
[tbl_Property.PropertyBuildValue]*[tbl_CountryInfo.CountryBuildRate] AS
PremiumBuildValue,
[tbl_Property.PropertyContValue]*[tbl_CountryInfo.CountryContRate] AS
PremiumContValue,
[tbl_Property.PropertyStockValue]*[tbl_CountryInfo.CountryStockRate] AS
PremiumStockValue,
[tbl_Property.PropertyElecEqValue]*[tbl_CountryInfo.CountryElecEqRate] AS
PremiumEleqEqValue,
[tbl_Property.PropertyEQCover]*[tbl_CountryInfo.CountryEQRate] AS
PremiumEQCover,
[tbl_Property.PropertySGValue]*[tbl_CountryInfo.CountrySGRate] AS
PremiumSGValue,
[tbl_Property.PropertyBICover]*[tbl_CountryInfo.CountryBIRate] AS
PremiumBICover,
[tbl_Property.PropertyRoDCover]*[tbl_CountryInfo.CountryRoDRate] AS
PremiumRoDCover,
tbl_Property.PropertyNotes

FROM
tbl_Country INNER JOIN ((tbl_Client INNER JOIN tbl_CountryInfo ON
tbl_Client.CountryCode = tbl_CountryInfo.CountryCode) INNER JOIN
tbl_Property ON tbl_Client.ClientName = tbl_Property.ClientName) ON
(tbl_Country.CountryCode = tbl_CountryInfo.CountryCode) AND
(tbl_Country.CountryCode = tbl_Client.CountryCode);

Thanks so much for the help! I really appretiate it!

Dejan

"HJ" <hj********@spamhotmail.com> wrote in message
news:41***********************@news.xs4all.nl...
There are a lot of ways to accomplish this. I will describe one method,
which may of course not be the optimal one for you; and others may disagree
or come with alternatives.

First, I would like to make a note about the relationships you have

defined
between the client, client rates and property tables. You base these
relationships on the ClientName field. That is not a good thing to do,
because you may have two clients with exactly the same name. It is

therefor
better to add a ClientID field to the tbl_Client table that has the
AutoNumber type. And in the tbl_ClientRates and tbl_Property you add a
corresponding field, e.g. ClientID or ClientRatesClientID and
PropertyClientID. (The names only matter for your own reference, as long
they are Number (Long Integer)).

Then your actual question. You may add two fields to the tbl_Client table: ClientSpecialRate (Yes/No) and ClientSpecialRateID (Number, Long Integer). On your form you add a checkbox, e.g. chkClientSpecialRate, and a combo

box,
e.g. cboClientSpecialRate. I suppose you will have the checkbox unselected by default and the combo box disabled (greyed out) by default.

The combo box' control source is your new field ClientSpecialRateID and

the
row source is something like 'Select ClientRatesID, ClientRateName From
tbl_ClientRates Where ClientRatesClientID = ClientID'. When you select the checkbox you can have the combo box enabled.

Then in your premium calculation query you have your formulas looks at the ClientSpecialRate Yes/No field. If Yes, then use the data from the
corresponding row in tbl_ClientRates. If No, use the country info.

I hope this helps.

HJ

"d.p." <no@spam.never> wrote in message
news:41**********************@news.zen.co.uk...
Hi all,
I'm using MS Access 2003.
Bare with me on this description....here's the situation: Imagine

insurance,
and working out premiums for different insured properties. The rates for calculating premiums are dependant on the country in which the client is
in.
Therefore, we have a Country table, with its list of rates, a client

table and then the property table. Getting this is great, works fine, easy!
Problem is, now I need to work out a way for special cases - a client

within
a country might have their own rate instead of using the "global" rate for the whole country. And what's worse, a client might have several
groups of rates. So I need a system that will allow the user to be able to
choose which set of rates to use to calculate the premiums for that client. I
created another table called ClientRates, and that's linked to the

Client table, in a many-to-one relationship.
Creating a query that takes rates from one table and multiplies with other values, and then gives you the premiums is easy, but is there a way to

allow
the user to choose which set of rates to use for that specific instance? Some kind of drop-down list before doing the calculation. I can't imagine that's possible...but is there any other way?

Here's an image of the tables and their relationships.
http://img106.exs.cx/my.php?loc=img1...ationships.jpg

Thanks a lot for all the help. I hope I made enough sense.
Dejan



Nov 13 '05 #4
Hi HJ
thanks a lot for your help. Just went through the db and adjusted all the
tables, relationships, etc....took a while to clean it up, but it's done
now. I realised that, even though it might not be critical, it'll be much
cleaner design, and will allow for possible future events, whatever they may
be. As for the query you suggested, that works great! I appretiate your help
very much!!! It's wonderful when things start to work :-) Now i have to get
my design skills out and create nice forms.
Thanks again for your help!!!
Dejan
"HJ" <hj********@spamhotmail.com> wrote in message
news:41***********************@news.xs4all.nl...
Hi DP,

If I primarily focus at your query, and if I do not use any VBA code, you
can have a look at http://www.xs4all.nl/~hjm/images/dp/QueryForDP.jpg (SQL
statement is printed below; image stays online for only a few days).

You see a few adjustments to the tables and one supplement to the query.
That is the Left Join for the tbl_ClientRates table. I have now only
adjusted the calculation for the PremiumBuildValue field; you can do the
rest.

In the example for the PremiumBuildValue you see that if the
ClientSpecialRate Yes/No field has been selected (=Yes), then the special
build rate is being used. If the ClientSpecialRate field has not been
selected, then the general CountryBuildRate is used.

Beware of the Left Join to the ClientRates table. You do need that type of
relationship, because you may not have special rates for every client in
your database.

HJ

To make it easier for you to rebuild the drawn query, here is the SQL
statement:

SELECT tbl_Client.ClientName, tbl_Property.PropertyName,
tbl_Country.CountryCurrency,
[tbl_Property.PropertyBuildValue]*IIf([ClientSpecialRate],[tbl_ClientRates.C lientBuildRate],[tbl_Country.CountryBuildRate]) AS PremiumBuildValue,
[tbl_Property.PropertyContValue]*[tbl_Country.CountryContRate] AS
PremiumContValue,
[tbl_Property.PropertyStockValue]*[tbl_Country.CountryStockRate] AS
PremiumStockValue,
[tbl_Property.PropertyElecEqValue]*[tbl_Country.CountryElecEqRate] AS
PremiumEleqEqValue,
[tbl_Property.PropertyEQCover]*[tbl_Country.CountryEQRate] AS
PremiumEQCover, [tbl_Property.PropertySGValue]*[tbl_Country.CountrySGRate]
AS PremiumSGValue,
[tbl_Property.PropertyBICover]*[tbl_Country.CountryBIRate] AS
PremiumBICover, [tbl_Property.PropertyRoDCover]*[tbl_Country.CountryRoDRate] AS PremiumRoDCover, tbl_Property.PropertyNotes
FROM ((tbl_Country INNER JOIN tbl_Client ON tbl_Country.CountryCode =
tbl_Client.CountryCode) INNER JOIN tbl_Property ON tbl_Client.ClientID =
tbl_Property.PropertyClientID) LEFT JOIN tbl_ClientRates ON
tbl_Client.ClientSpecialRateID = tbl_ClientRates.ClientRatesID;

"d.p." <no@spam.never> wrote in message
news:41**********************@news.zen.co.uk...
thanks a lot HJ!
this sounds very possible. I haven't had a chance to mess with it the past
2
days, but I'll definintely give your suggestion a go. I'm not that skillful
at Access, but learning slowly. I hope I can figure this out. I'll give a shout if i run into things :-)

Oh, about the primary key for the client...I made it ClientName because I know definitely that it'll be different for every client (it's just the

way
this company names it), although I'll consider just giving it an ID field, just for consistency at least.

You also said this at the end:
Then in your premium calculation query you have your formulas looks at the ClientSpecialRate Yes/No field. If Yes, then use the data from the
corresponding row in tbl_ClientRates. If No, use the country info.


Sorry to be a bit less knowledgable now, but how would an SQL statement

look
at a check box and then determine what to use? Here's the SQL statement

that
was generated by Access, so you can see the current query. If you have a
diff suggestion, please feel free to say:

SELECT
tbl_Property.ClientName,
tbl_Property.PropertyName,
tbl_Country.CountryCurrency,
[tbl_Property.PropertyBuildValue]*[tbl_CountryInfo.CountryBuildRate] AS
PremiumBuildValue,
[tbl_Property.PropertyContValue]*[tbl_CountryInfo.CountryContRate] AS
PremiumContValue,
[tbl_Property.PropertyStockValue]*[tbl_CountryInfo.CountryStockRate] AS
PremiumStockValue,
[tbl_Property.PropertyElecEqValue]*[tbl_CountryInfo.CountryElecEqRate] AS PremiumEleqEqValue,
[tbl_Property.PropertyEQCover]*[tbl_CountryInfo.CountryEQRate] AS
PremiumEQCover,
[tbl_Property.PropertySGValue]*[tbl_CountryInfo.CountrySGRate] AS
PremiumSGValue,
[tbl_Property.PropertyBICover]*[tbl_CountryInfo.CountryBIRate] AS
PremiumBICover,
[tbl_Property.PropertyRoDCover]*[tbl_CountryInfo.CountryRoDRate] AS
PremiumRoDCover,
tbl_Property.PropertyNotes

FROM
tbl_Country INNER JOIN ((tbl_Client INNER JOIN tbl_CountryInfo ON
tbl_Client.CountryCode = tbl_CountryInfo.CountryCode) INNER JOIN
tbl_Property ON tbl_Client.ClientName = tbl_Property.ClientName) ON
(tbl_Country.CountryCode = tbl_CountryInfo.CountryCode) AND
(tbl_Country.CountryCode = tbl_Client.CountryCode);

Thanks so much for the help! I really appretiate it!

Dejan

"HJ" <hj********@spamhotmail.com> wrote in message
news:41***********************@news.xs4all.nl...
There are a lot of ways to accomplish this. I will describe one method, which may of course not be the optimal one for you; and others may

disagree
or come with alternatives.

First, I would like to make a note about the relationships you have

defined
between the client, client rates and property tables. You base these
relationships on the ClientName field. That is not a good thing to do,
because you may have two clients with exactly the same name. It is

therefor
better to add a ClientID field to the tbl_Client table that has the
AutoNumber type. And in the tbl_ClientRates and tbl_Property you add a
corresponding field, e.g. ClientID or ClientRatesClientID and
PropertyClientID. (The names only matter for your own reference, as long they are Number (Long Integer)).

Then your actual question. You may add two fields to the tbl_Client table: ClientSpecialRate (Yes/No) and ClientSpecialRateID (Number, Long Integer). On your form you add a checkbox, e.g. chkClientSpecialRate, and a combo box,
e.g. cboClientSpecialRate. I suppose you will have the checkbox unselected by default and the combo box disabled (greyed out) by default.

The combo box' control source is your new field ClientSpecialRateID
and
the
row source is something like 'Select ClientRatesID, ClientRateName
From tbl_ClientRates Where ClientRatesClientID = ClientID'. When you select

the checkbox you can have the combo box enabled.

Then in your premium calculation query you have your formulas looks at the ClientSpecialRate Yes/No field. If Yes, then use the data from the
corresponding row in tbl_ClientRates. If No, use the country info.

I hope this helps.

HJ

"d.p." <no@spam.never> wrote in message
news:41**********************@news.zen.co.uk...
> Hi all,
> I'm using MS Access 2003.
> Bare with me on this description....here's the situation: Imagine
insurance,
> and working out premiums for different insured properties. The rates for > calculating premiums are dependant on the country in which the client is
in.
> Therefore, we have a Country table, with its list of rates, a client

table
> and then the property table. Getting this is great, works fine,
easy! > Problem is, now I need to work out a way for special cases - a client within
> a country might have their own rate instead of using the "global" rate for
> the whole country. And what's worse, a client might have several

groups
of
> rates. So I need a system that will allow the user to be able to

choose > which set of rates to use to calculate the premiums for that client.
I > created another table called ClientRates, and that's linked to the

Client
> table, in a many-to-one relationship.
> Creating a query that takes rates from one table and multiplies with

other
> values, and then gives you the premiums is easy, but is there a way to allow
> the user to choose which set of rates to use for that specific

instance? > Some kind of drop-down list before doing the calculation. I can't

imagine
> that's possible...but is there any other way?
>
> Here's an image of the tables and their relationships.
> http://img106.exs.cx/my.php?loc=img1...ationships.jpg
>
> Thanks a lot for all the help. I hope I made enough sense.
> Dejan
>
>



Nov 13 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Robert Wille | last post by:
I have a number of very common queries that the optimizer plans a very inefficient plan for. I am using postgres 7.2.3. I vacuum hourly. I'm wonderingwhat I can do to make the queries faster. Here...
1
by: Robert Wille | last post by:
I have a number of very common queries that the optimizer plans a very inefficient plan for. I am using postgres 7.2.3. I vacuum hourly. I'm wonderingwhat I can do to make the queries faster. Here...
15
by: Richard Hollenbeck | last post by:
For example, one college course has only 24 students in it, but the following code says there are zero As, 20 Bs, 16 Cs, 4 Ds, and 8 Fs. When it prints it then says 0 As, 40 Bs, 32 Cs, 8 Ds, and...
14
by: Jim Andersen | last post by:
I have a problem with this standard employee-supervisor scenario For pictures: http://www.databasedev.co.uk/self-join_query.html I want to show all employees "belonging" to a specific...
6
by: jjturon | last post by:
Can anyone help me?? I am trying to pass a Select Query variable to a table using Dlookup and return the value to same select query but to another field. Ex. SalesManID ...
73
by: Claudio Grondi | last post by:
In the process of learning about some deeper details of Python I am curious if it is possible to write a 'prefix' code assigning to a and b something special, so, that Python gets trapped in an...
14
by: dba_222 | last post by:
Dear experts, Again, sorry to bother you again with such a seemingly dumb question, but I'm having some really mysterious results here. ie. Create procedure the_test As
11
by: Bruce Lawrence | last post by:
Ok, I'm baffled... I'm making a query in access 97 between 2 tables. There is a field in both tables called "DWGNO". OPENORD has a record with a DWGNO of "00000012345" DIEDATA has a record...
7
by: fcolon75 | last post by:
I'm an experienced Access user, but very new to coding VBA in Access. I'd like to do the following: 1) Develop a basic query in the query designer. 2) Call that query from a VBA script 3)...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.