Unusual Query – Advice Needed Please

Bit Of Advice Needed Please
Hi all,

This is my first post here and was just hoping for a bit of advice, what it is my dad wants me to create a small database for him and was hoping for some advice on how to tackle it. What he wants is listed below. I have some ideas but the most confusing aspect I found was how to update a persons age from the computers date.Heres what he wants and hope you can give me some advice. Thanks in advance John

Fields (free text unless otherwise stated) for people;

First name
Surname
Age
Further Education level - drop down menu for "GCSE/A level ,HNC/HND, Degree, MSc, PhD"
Degree held? - drop down menu "yes" or "no"
Chartered engineer - drop down "yes" or "no"
Professional Quals - free field for these
Skill base 1 - drop down for " Manager - Operations, Production, Maintenance, Engineering; Engineer - Mechanical, Instrument, E&I, Electrical, Rotating Equip, Process, Asset Integrity, Inspection, QA/QC; Superintendant/Supervisor - as above; and any others (think of all KPO Ops parented people)
Skill base 2 - as above
Skill base 3 - as above
Professional ladder job title
Grade - drop down menu BG3,BG4. BG5
Hay points
Date of birth
Age - can this be generated from entry above and current date?

Current Assignment job title
Current Assignment start date
Current Assignment Asset
Current Assignmnet end date
Current Assignment location (eg Cairo, Idku etc)
Currnet Assignment type - drop down menu rotation 14/14, rotation 28/28, expat

Next assignment options
Comments


Then set of data fields for posts

Post job title
Post type - drop down rotation menu as above
Likely Start date
Location
Asset
Sponsor in Asset


People Reports

People - All data
People - Listed by current job end date
People - Listed by skills (if Mechanical in any of three fields above, list him), will be repeats of names in list (as have more than 1 skill but thats OK)
People - List of those with degrees
People - List of those chartered
People - Listed by current job end date
People - Listed by current job end date
People - Listed by current job end date

Job Reports

View Replies !

---

Advice Needed
I built a DB for work (Access2000) which is on the network and is for inputting maintenance request. Nothing complicated about it and at any time there would probably only be 3-4 users logged on at a time, and then probably only for a few minutes each. This DB got corrupted yesterday and I had to recover from teh backup. I compact and repair manually on a weekly basis(usually). My question is would it be less likely to get corrupted if I split the DB? Would it help to set up an automated complact & repair to run overnight?
Thanks
RussG

View Replies !

---

Help - Advice Needed
Hi

Im currently building a database which holds customer delivery options, quantities, unit and delivery price and so on.

It has all been going fine until now...!

I am trying to setup the billing aspect. My main headache is that each customer could have a delivery every day, of different quantities. Now there will be times when this customer goes on holiday and of course doesnt need to have anything delivered - my only problem is getting the billing to adjust accordingly.

I have my SubForm which contains:

UnitName
UnitPrice
Mon
Tues
Wed
Thursday
Fri
Sat
Sun
DeliveryCost
TotalCost


at the moment in the main form the holiday period is put in and i convert this then into a number of days value - this is then subtracted from the total of units (count of Mon to Sun) x UnitPrice + Delivery.

My problem is that if a customer has 2 days off which are Mon and Tues, how do i get it to only remove the mon and tues values from the unit amount - instead of just removing a figure assuming that they have only 1 per day - wihch in most cases they don't.

Can i somehow assign the day values to each day field in the subform and get the correct days from the holiday or something!

i dont know its just breaking me down!!!:mad:

Any help greatly appreciated

View Replies !

---

Advice Needed
I have a database that has one aspect that is highly dependent on certain payroll information. For example:

When a pilot begins entering his flight for the day at the bottom of the entry form it tells him the payroll dates are from x to x and you have worked X number of days in this pay period.

This part I have gotten down quite nicely using a payperiod table. Problem is that I must enter that information manually and it is time consuming to do that for the whole year. Point of fact I only put the first day of the pay period in this table. Our pay periods are every two weeks.

I also generate a report for payroll based on these pay periods.

My question/advice is a new way of going about this pay period deal without having to enter it in manually every year.

We have these wonderful computers but I feel I am doing too much work but just don't see a different method around it.

A bit wordy but I wanted to be clear. Any advice in a new direction?

View Replies !

---

Advice Needed
Hi all,:)

I'm looking for some advice: the problem is that I've got 13 sections in which people are working, and administrative assistants that are taking care of 1 or more of these same sections.

In addition to the usual security, there is also a requirement to make the AA's only output their own sections reports.

The way I see it there are two ways to ensure this:

1) put in a field in the users table that would indicate which sections the AA was responsible for ie

userID 1
respFor 56,34,45

userID 2
respFor 41,3

userID 3
respFor 42

... etc respFor would have to be a text field with a delimiter between each sectionID

sectID 41
sectName AAA

sectID 42
sectName BBB

2) have a separate table that will form a "union" between user and section tables ie User&Section

userID 1
sectID 56

userID 1
sectID 34

userID 1
sectID 45

userID 2
sectID 41

userID 2
sectID 3

userID 3
sectID 42

Now for my question: Can you advise me on which way is best for this circumstance? or perhaps you've got another way to go? Have you got an example ?

Your advice please...

TIA

View Replies !

---

Advice Needed
Greetings! I am setting up a database in Access 2003 for a Seniors Program. Through this db I need to set up forms where they can add information on individual members, denote which programs they participate in/pay dues for, etc.

Any advice you all could give would be greatly appreciated.

EDITED TO ADD: I'm basically a newb when it comes to Access...I can do the basics, but need to go beyond what I know to do this project...

View Replies !

---

Not Sure Where Togo With This - Advice Needed
All,

I am new to access and despite reading what seems to be a mountain of stuff I'm a bit stuck. Can somebody point me in the right direction to achieve the following.

This is a simplified version of my problem, but it is the principle I'm after.

I have a query, the results of which look like

FIRSTNAME SECONDNAME ITEM ITEMSIZE

There are multiple results with the same firstname and secondname but different item info. e.g.

Bill Smith Shoes 10
Bill Smith Shirt 16

I need to be able to produce some output - table/report/query (to be export to excel) where there is only one record per (FIRSTNAME SECONDNAME) of the form

FIRSTNAME SECONDNAME ITEM1 ITEMSIZE1 ITEM2 ITEMSIZE2...ITEMn ITEMSIZEn

e.g

Bill Smith Shoes 10 Shirt 16
Fred Jones Hat 12 Jacket 48 Shirt 16

Can this be done without resorting to VB code? I'm no programmer.

Thanks

Chris

View Replies !

---

Newbie Advice Needed
Hi,

I wonder if someone could help me, i have started to create a database which will be uses for a gardening service company.

I have created the customer database table and form which him quite impressed with the say ive never done it before.

I also followed a tutorial from the net which was based around a video rental shop, ive put in in the transdetail and masterquery forms also as said in the tutorials as it will basically need a databse for the customers, then i will need to create invoices from services we do for the customers i:e lawn cut etc.

this is where im stuck really, i have tried variuos things but it doesnt seem to be tying into what i want it to do, i think ive tried to overcomplicate it. If anyone could give me any advise on what i need to do to create this very simple database i would really be grateful.

so customers
service and products
then invoices

thanks

Kazza

View Replies !

---

Bank Holidays: Advice Needed
hi

i'm trying to build something that knows when to notify someone that they can call a trade, given 1) a callable date 2) a notice period and 3) the relevant cities

e.g.

?NotificationDate(#28-jun-2008#,10,"LONY ")
16-06-08

the good news is, i've done it, with this code:-


'---------------------------------------------------------------------------------------
' Procedure : NoficationDate
' Date : 28/03/08
' Purpose : to calculate the date of notification for an EMTN, given the call date & notice period & cities
'---------------------------------------------------------------------------------------
'
Public Function NotificationDate(dtCall As Date, intPeriod As Integer, strSixDigitCities As String) As Date

Dim intWorkingDaysBefore As Integer
Dim strCities(2) As String
Dim dtLoop As Date

strCities(0) = Left(strSixDigitCities, 2)
strCities(1) = Mid(strSixDigitCities, 3, 2)
strCities(2) = Mid(strSixDigitCities, 5, 2)

dtLoop = dtCall
intWorkingDaysBefore = 0

Do
dtLoop = dtLoop - 1
If Left(Format(dtLoop, "ddd"), 1) <> "s" And IsBankHoliday(dtLoop, strCities(0)) = False _
And IsBankHoliday(dtLoop, strCities(1)) = False And IsBankHoliday(dtLoop, strCities(0)) = False Then
intWorkingDaysBefore = intWorkingDaysBefore + 1
End If

Loop Until intWorkingDaysBefore = intPeriod

NotificationDate = dtLoop

End Function


'---------------------------------------------------------------------------------------
' Procedure : IsBankHoliday
' Date : 28/03/08
' Purpose : to see if it's a bank holiday
'---------------------------------------------------------------------------------------
'
Public Function IsBankHoliday(dtInput As Date, strCity As String) As Boolean
Dim rs As DAO.Recordset

Set rs = CurrentDb.OpenRecordset("SELECT * FROM qry_Tass_All_Hols WHERE CITY = '" & strCity & "' AND HDATE=#" & Format(dtInput, "mm/dd/yyyy") & "#", dbReadOnly)
If rs.RecordCount > 0 Then
IsBankHoliday = True
Else
IsBankHoliday = False
End If
rs.Close
Set rs = Nothing

End Function



BUT it runs like arthritic toad, it makes a minute per execution and i was hoping to scale it up to 4000 records => 2 days of run time :eek:

any ideas on how to attack this problem...even guesses appreciated, i can try things out and see if they work


thanks in advance

View Replies !

---

Data Entry Advice Needed
Hi. I am developing a db for juvenile salmon-focussed fishery survey data and have encountered something of a conundrum which I could use some advice on. Apologies in advance for the length of the post.

Background
Juvenile salmon move from freshwater to saltwater. During this transition they require time to adapt physiologically and are thought to seek out nearshore areas with intermediate salinities, or with freshwater overlaying the saltwater. They also experience problems with elevated temperatures.

We are interested in tracking salinity and temperature information at each site where we sample for fish to aid in interpreting our catch results.

Data Collection
Our convention is to collect temp/salinity at the surface and at 3-feet below the surface wherever we beach seine (or just at the surface if the site is shallower than 3-feet). However, we use a depth-temp-salinity data-logger attached to the lead-line of a lampera net for openwater sets. The logger provides measurements of depth/temp/salinity every 5 seconds during the set, down to depths of 20-30 feet.

So, for some 'sets' we have one or two measurements of depth/temp/salinity, and for other sets we might have over one hundred measurements.

Problem

1.How best to get that data entered into the db?
2.I'm just starting to get my toes wet with VBA

Ideally, I could directly enter the values into a subform for sets with only one or two measurements, but could instead 'import' the extensive data for those sets where the logger was used. Entering the logger data manually would be ridiculously time-consuming.

Existing DB Setup
Records for temp/salinity subform/table linked to other set information by a unique Set_ID field.

Subform for depth-temp-salinity information bound to a dedicated depth-temp-salinity table. The subform is currently viewed as a continuous form.There would be one excel file for each set where a data logger was used, but no excel files for sets where no data logger was used..

My thoughts so far.

Somehow create a subform with the ability to enter up to two records manually or else click a button that imports the data from an excel file. One thought is to pop open a window to navigate to the excel file that contains the data for that set. However, I'm thinking that if I place all such excel files into a particular directory and name them using the appropriate Set_ID number convention, that maybe clicking the button with be able to find the file directly, without navigation required, and bring in the records automatically.

Is this possible? How would I go about creating a subform that provides both an 'import data' button and allows for manual data entry of up to two records?

Can anyone show me a similar example for both the data entry (form) and for how to automate the importing of data from excel files to append to an existing database table?

Aim:
The eventual goal of this is to have a command button that could be clicked on the form/subform that would produce a popup window containg a scatterplot graph of salinty versus depth. another button to produce a scatterplot of temperature versus depth. A third button to open a line graph with time on the x-axis, and temperature/salinity series on the y-axis. Before I can get there, however, I need to get the data into the table somehow.

I would appreciate any input/advice on this matter, (especially custom code! ;) ) As, I mentioned, I'm just starting out in VBA and I have a lot to learn. I know how to open a MsgBox, but have no clue on what the command is to open an explorer 'window'.

I hope the problem is sufficiently interesting to generate some response.

Cheers!

View Replies !

---

Urgent Required Field Advice Needed
I'm looking for advice on the best method to accomplish the following from the esteemed members of this Forum (You all have provided excellent advice in the past to this Access Dummy, with my thanks), (I've also searched the forums without result):

I would like to make several fields "required" fields on my form, easy enough, in that I set the Required property on the table to "Yes".

What I would like to happen on the form is that when a user tabs out of a required field, a message box pops up that says "This is a required field" and/or when they click any of the following command buttons I've created, "Save Record", "New Record" or "Close Form", that a message box pop up and list the required fields that they missed.

Any ideas, with code, macros, or other solutions would be greatly appreciated, keeping in mind that I'm just not that swift to start with.

Many Thanks,
Photoguy

View Replies !

---

Payroll Database- Advice Needed On Relationships/normalisation
Hi,
I would like to get your advice on my table setup and relationships for this payroll project. The company is an engineering company with Projects (or construction sites) around the world.

The 'Candidates' are current or potential employees and contractors. There are three main pay categories:

1.Shift-workers
All shift workers doing a particular job on a particular project are paid the same rates e.g. all welders on a particular project or site in England are paid the same as each other. For that reason I want to link the pay rates with the job description for these workers. This avoides creating 50 records for 50 welders on the site in England to say that they make £10 an hour normal time (or whatever it is) etc.

2. Contract
Contract workers usually get paid a flat rate per hour. As these are negociated on an individual basis I would need to have this information linked to each individuals job (M_CandidateJobDetails).

3. Salary
Again this information needs to be input for each individuals job.

For the contract and salary people the pay frequency can vary (weekly, bi-weekly or monthly). So can the currency they are paid in. I haven't got as far as the currency issue yet.

The reason for the one-to-many relationship between M_JobClassifaction and M_CandidateJobDetails is that many candidates can have the same type of job e.g. there can be many employees that in the job classifaction of 'Electrician'. For many of the jobs at managerial level e.g. 'site manager' there will only be one.

I will have a table with the hours worked by each person per week. I can use this for those on shift work or contract to calculate what they will be paid.

One of the main reasons for this database is so that the company can print reports to see what is paid out in payroll for each site and in total (in euros). These will be gross figures and I don't need to take expenses, vacations, bonuses or taxes into account. They other thing we will need to be able to do is assign candidates to vacant positions and change them from one position to another - possibly between different projects.

So basically does anyone have any comments on the relationships, normalisation or anything else. Is this the best way to do it?

I've attached a screenshot of the relationships.

View Replies !

---

Some (expert) Advice Needed Please (linking Field With String In Other Field
Hi,

I hope someone can help me, I have a database compiled from different sources which means that information in fields that need to be linked are written differently, meaning that I can't just simply make a relationship between them.

The two tables I would like to link are,
Table 1 has the fields OCCUPATION and AMOUNT and contains over 740,000 records.
Table 2 has the fields COMPANY_NAME and TICKER and has 500 records.

I need to find a way for all COMPANY_NAME fields in table 2 to be cross-referenced with the OCCUPATION field, so if COMPANY_NAME is part of the string in the OCCUPATION field then the TICKER (of that company) can be attached to the record in table 1 (specifically to AMOUNT).

The problem is that the OCCUPATION field is not written in a standard form and can include either only the occupation, only the company name, or both in either order.

I can make a seperate query for each company by using as criteria "like "*[COMPANY_NAME]*", but then I would have to do this 500 times!!! Is there a way to automate this?

The final purpose is to link the AMOUNT to TICKER so as to find the sum of all the amount associated with a company.

I really hope you can help, I have little programming knowledge and it will save me the time of making 500 seperate queries. The final use is for my thesis studying private contributions in the american elections.

Thanks in advance (I hope),

Onur

View Replies !

---

Unusual Linking Question?
Hi.
I have a table with contract numbers and acceptable start date and end date for training.
And I have a different table which has records for individuals with fields which include a contract one that is a combination of a vendor name and the contract number, plus the individual's training start date.

Anyway, I need to run a query which would check to verify that the individual's start date falls within that contract's acceptable start range.

How would I link the 2 tables? There really isn't a 'firm' related field. Or, is this impossible.

Russ

View Replies !

---

Unusual Changes To Information In Form
I have previously posted this on another message board with no responses. I am hoping that someone here can help.

I have a form that has several subforms. The forms are linked Child to Master using a Company Name Contol. In the table where the Company Name is set up, it is not indexed.
It is not a primary key. When the EU (in test) enter data with the company name a second time (a second record for the same company), all the information in the first record populates the second record. If any changes are made to the second record, then it is also reflected as changed in the first record. I hope that I am clear in my explanation. What have I done to cause this?

Alan

View Replies !

---

Unusual (?) 'too Many Fields Defined' Problem
Hi.
I have a dtabase (Access 97) and all ahs been well. I needed to adjust some field sizes. But if I try to even reduce 1 field's size or to increase 1 field's size and save the table, I get a message that it cannot be saved due to too many fields defined. But I am only adjusting size of an existing field.

Ideas??

Russ

View Replies !

---

Very Unusual Mail Merge Problem
I've created a vb.net application that stores various information for the user in an access database file. This works perfectly. Now, I want the user to be able to use mail merge with this and query for a given field or fields and return a single result as a mail merged document so that they can print out reports with different information but identical formatting. Seems simple enough... and it was... sort of.

On this computer I'm running visual stuido 2000 and on some other machines this software needs to work on they have visual studio 2003. Now, this shouldn't be a problem but it is. My computer can do everything I want exactly as I want it, however when I try to use word 2003 with the access 2000 database file some problems arise. Mainly it can see the database, and can properly merge it with the fields....but only if I make it return merged documents for EVERY row of the database or the first one. Anytime I query for any entry in the DB it returns only the first record in the DB. This, obviously, is of no use to me in this form.

Is there a known issue of compatibility between access 2000 and 2003 software? I've been seraching but have yet uncovered nothing of this sort but the problem occurs on multiple computers in the exact same way. Thanks for any tips or help.

View Replies !

---

Import CSV File From Database PRO To Access: Unusual Record Splitting Problem
Hello everyone,

I'm trying to import data from our current Database Pro v1.0 DB to an Access DB that I'm creating.

Our DBPRO is essentially a flat-file data entry program. It has a "subform" for history events that isn't actually in it's own table, but all concatenated in a single [History] field.

Basically, when viewed in DBPRO, it's broken into different records, yet it's actually stored as one. DBPRO uses °, ±, □, and 0's to separate the different "fields", but Access can't seem to break it down automatically.

When I export the data to a CSV file, everything else comes through with minimal problems. The [History] field, of course, comes in as a huge block of concatenated records.

I've attached an example of this below. I included only the field in question, ([History]), and the primary key, ([Last Name/Cust]). The first tab in my example is a single record, recently imported. The second tab shows how I need it to be, broken into multiple records.

Is there anyway I can split these records, while maintaining the primary key? It's my goal to have all the other information in one table, and the history records in a separate one.

Thanks so much for your help! I've researched all over, and just can't seem to find a similar problem, or solution. :(

Ben Bolduc

View Replies !

---

Advice - Query?
Hi,

Before I post on here I always try to look back through the posts for similar problems – however I don’t know where to start looking to solve my problem.

I use access to store and record the details of my sales. As well as the prices, I also store the date of the sale.

I want to be able to add up the value of the sales for each day so I can see how much we sold – but I don’t know how to go about it. I’ve tried performing a query and then applying a filter by form – however when I click on the “Date” column, the drop down selection displays a list of identical dates:

12/05/07
12/05/07
12/05/07
12/05/07
12/05/07
12/05/07
12/05/07
12/05/07
11/05/07
11/05/07

rather than just one date:

12/05/07
11/05/07
10/05/07

And when I click on one of the dates it only shows the data for that individual record, rather than the data for all the records on that date.

Could anyone please nudge me in the right direction? Should I be looking to perform a normal query? Or do I need to work on a different type/advanced query?

Eventually my intention is to create a form which links the queries to a report so I can print out the data, however for now I’d be overjoyed to simply be able to display the values in a table.

Any help would be greatly appreciated!
Thank you for your time.

View Replies !

---

Query Advice
Hi :DFirst off, i am a complete novice in this area, so be kind:D I’m currently doing a Bsc in Computing, and we have a database module ( my worst subject :( ) the current assignment is to create a DB for a specific task, and one of the objectives is to create a login page for the DB . I tired to use Access's built in 'user and permissions wizard' but had no luck there.I have a staff table, and linked that to a permissions table, I assigned each member of staff a user level (5 levels in all). I then created queries to filter each of the 5 levels, and used parameters in each of the 5 queries to prompt for a username and password. I then created a form for each of the queries. i then tested each of the forms, and it asked for the username and password, and I was in, I thought my idea had worked, however, if I enter I wrong username or password, the form will still appear :( .I’m wondering if there is a way to validate the query parameters? or is there an easier way I can do this? I know i am probably going about this in completely the wrong way. All I need is a main login page, which will offer each user a different GUI.Any advice will be greatly appreciated. As aforementioned, this is not my best area, and this is the first time I have actually used access :(.Thank you in advance :)*EditI have searched th eforums, and cannot seem to fidn anythign on parameter validation, but did find a lot of ways to code a login page. i do not want to do this so i will stick with using access's built in users and permissions. I know that to login you need to click the shortcut that is created, but if i take my DB elsewhere how can i get that login page to be displayed? becuase if you click directly it will nto let you in , u need to click the shortcut, so how could i get around that?? thank you :D

View Replies !

---

Query Advice Required
Hi All

Im after some help with a query im building.

I have a table called QuizResults which has 10 Yes/No fields. The table also has a field called Site.

Each site will take a quiz and the problem I am having is with the statistics side of things.

What I need is a query that will work out the percentage correct for each site. All the data is stored in this 1 table. There are no relational fields as they are not required. I have tried a few different ways but each method I use involves me making many many queries to work this out.

To summarise I need 10 percentage correct fields, broken down by site.

Please can anyone help?
Many Thanks
Dazstarr

View Replies !

---

Advice On Structure For Table/Query
Good evening all!

Part of the function of my Db is to produce quotations. I specifically need one table containing line items and will use another table (update query) which will contain the 'quoted for' items. Transfer will be based on numbers of users required. I have the basic idea in mind; i will have a form with drop down to select numbers of users and then some Vb to take records from one table to the other. I can do that fine. The bit I am struggling to structure in my mind is as follows:

In a quote there will be typically three line items

1) Software
2) Installation / Configuration
3) User Training

I can easily do as described above but that relies on the main table being pre-populated with all three line items. however, I'd prefer to have the ability to have prices for daily rates, relating to installation and training, in another table so as to be able to change/update them and not have them fixed in a table.

So I think I would want to have the three line items update query across buy somehow control the list price of the services element controlled elsewhere.

Any advice? Many thanks.

View Replies !

---

Advice On Structure For Table/Query
Good evening all!

Part of the function of my Db is to produce quotations. I specifically need one table containing line items and will use another table (update query) which will contain the 'quoted for' items. Transfer will be based on numbers of users required. I have the basic idea in mind; i will have a form with drop down to select numbers of users and then some Vb to take records from one table to the other. I can do that fine. The bit I am struggling to structure in my mind is as follows:

In a quote there will be typically three line items

1) Software
2) Installation / Configuration
3) User Training

I can easily do as described above but that relies on the main table being pre-populated with all three line items. however, I'd prefer to have the ability to have prices for daily rates, relating to installation and training, in another table so as to be able to change/update them and not have them fixed in a table.

So I think I would want to have the three line items update query across buy somehow control the list price of the services element controlled elsewhere.

Any advice? Many thanks.

View Replies !

---

Query Design Problem - Advice?
Hi all,

I have a table of employee sickness / absence records with the following structure and data:


http://www.geocities.com/cyngorsir_ynys_mon/TBL_SICKNESS.gif

I have figure out how to write a query which displays the number of days taken for each sickness (END_DATE minus START_DATE).

http://www.geocities.com/cyngorsir_ynys_mon/QRY_DAYS.gif

My problem is that I would to write a query to display the number of days taken for each of the 12 months of the year.

In the example of Employee 4 their sickness spans two different months, I can't get my head around how to produce the correct result which should look like:-

http://www.geocities.com/cyngorsir_ynys_mon/OUTPUT.gif

The only way I can think of doing it is by recording each day of sick individually rather than just the start and end days?

ANY input / comments / observations would be greatfully received!

Thanks

View Replies !

---

QBF (Query By Form) Advice/tutorial/example Appreciated!
Hi,

I have some basic VBA and ADO recordset exposure, and would like to create a form, that:

- allows a user to search 4-5 fields (client & business name based information)
- return options of records to view that match that data
- allow user to make a selection, which then provides another form with full details of that client's record(about 20 fields)

Can anyone provide an example or perhaps guidance on a good tutorial, that will take me through this process gently (and help me understand the process)!

Regards and thanks

Mack

View Replies !

---

Help Needed With Query
Hi,

I was wondering if i could get some help here. I got problem while trying to perform sql query. I got an error message saying

"No value given for one or more required parameters".

I think i know what caused this but i just don't know how to get around this.

The query I'm trying to perform requires 3 tables and 2 queries.
Tables: Projects, Plan_Names, Reason
Queries: PSQuery, ProjectQuery

I think this is due to the fact that those two queries are empty for a start. Hence, it needs more value.

My question is how do i in the code, tell it to execute the two queries before attempting the query i want to perform.

Thank you in advance

View Replies !

---

Query Help Needed
I have a query where I need to find out the average score of employees over a date range. I have a field called date where I enter a date range (Between [START DATE (MM/DD/YY):] And [END DATE (MM/DD/YY):]) and another field where I enter the name of the supervisor. Now the table I have created contains the scores on a daily basis. So what I want is that when I enter the date and the name of the supervisor it should give me the average of the scores over that date range of all the employees under that supervisor along with the name of the employee.

View Replies !

---

Query Help Needed
I have two tables, a Property table and a System table. They are linked so that there are many Systems linked to one Property.

Each System has a risk score and these vary within each property. My Property table has a Property risk score field and in here i would like the maximum System risk score to go.

I'm just wondering how i would do this using a query? All the system risk scores have been entered already.

Any information would be great!!

Matt

View Replies !

---

Query Help Needed Please
Hello everybody,

I am unsure whether this is best done in SQL or VBA, however, I do believe it is possible in SQL so I will put it here.

I have a field 'value of purchase' in which an items cost is inserted. What I am wanting to do initially is automatically deduct 20% off the value of purchase every year until it reaches zero. Now I don't want to deduct 20% off the new value every year, for example:

The price is $1000, 20% deduction is $800. But then year 2 it will be $600 then the next year $400 and so on. So I suppose the first year 20% is taken off the original price, then for year 2 40% and so on (always off the original price not the newly found values).

I want to display this in a new field 'current price'.

I am just not sure how to create the query so it will automatically deduct these amounts per year. If anybody has any advice/help it is muchly appreciated.

Thanks :)

View Replies !

---