Subquery as a Calculated field

[Pusher]

Hi all,

Can I make a field2 in my table that will be the result of another query that has the field1 as a chosen value. The Query is from another table that is connected to the first table. I really have a problem with this so if someone can help me.


Thanks a lot

 

[Pusher]

Re: Subquery as a Calucated field

Can some one help me? Or direct me to a place were i can get instructions or an example of calculated query field (

 

[vbaInet]

Re: Subquery as a Calucated field

The problem here is not that we can't give you the solution. The main problem is that we don't understand your request. This was the same problem I had in your other post.

Can you explain this a different way.

 

[Pusher]

Re: Subquery as a Calucated field

I have a simple problem but I don’t know how to solve it. The statistic that I’m doing is incorrect because of some changes that are done that I did not take into account. The error – ONE Location ONE type of Device. The problem is - that ONE location can change the device occasionally so when counting the errors on a single type of device on that ONE location - it has an incorrect value. Anyway I figured out I put a new field in my table that will put the current device in every record of an error. That way I can count the errors accurately. Now the HARD part… I want to make that when I enter the location [ID_RASKRSNICE] in my form IZVESTAJ – I fill my field ID_UREDJAJA in my table IZVESTAJ automatically (type of the device that is currently in that location (from the [RASKRSNICA] table – ID_UREDJAJ) .
I don’t know a different way of knowing what device was on what location WHEN. I can make a different table that will have the exact date of change of the device for example (DATE-LOCATION-DEVICE), but I don’t know how to make a query that will take into account the devices when they were on that location and then when they were not.

Here is my db for you to look and help if you can.

 

[Pusher]

Re: Subquery as a Calucated field

Can this be done with some appending query that will fire when a new record is made. Please help

 

[vbaInet]

Re: Subquery as a Calucated field

Pusher, I haven't had a look yet.

 

[Pusher]

Re: Subquery as a Calucated field

Ok no rush, thanks

 

[vbaInet]

Re: Subquery as a Calucated field

Don't worry, I will have a look soon. I just need some time to read your post and try to understand it

 

[Pusher]

Re: Subquery as a Calucated field

Here is my newer DB I Copy Pasted the Device name in my IZVESTAJ->ID_UREDJAJA field so i can show you what i want to be done automatically when I enter the ID_RASKRSNICE. Ignore the ID_UREDJAJA1 that is just for testing.

 

[vbaInet]

Re: Subquery as a Calucated field

You didn't mention what the name of the form is? And what steps I need to take? Write it in bullet points.

 

[Pusher]

I’ve decided to make a new table that will be filled with an update query – that will have a date location device and error. I just have to figure out how to do it and what will be the event that will fire that update query… And than i can make my statistics from that table.

 

[vbaInet]

Alright good stuff. It's always good to re-think your design in order to come up with a viable solution.