Total Noobie Question Here.
Dec 4, 2007
Hi Folks
I need some help with this issue at the office.
I use Access to lift data from our departmental mailbox and put it onto an Excel sheet, this process was created by someone who no longer works for us so we don't have any help from that source and our IT bods seem to be avoiding our queries. The problem I have is that due to a recent e-mail server switch, Access is looking for the older server address and obviously can't find it so I need to find the part of the script where Access is calling the e-mail server so I can update it with the new one.
So far I haven't had any luck in finding this info and as I have no experience in using Access other that other peoples completed modules I simply don't know where to start. Can anyone please give me some pointers with this?
:confused:
View Replies
ADVERTISEMENT
Jan 29, 2007
Is there any clear cut way to directly access a cell in a table via code?
Ive looked as far as my eye can look to try and find something quick and easy that allows me to cherry pick data out of a table, but ive had no luck.
For instance, I have a table named tblSANConnections with a field in it named fldServername.
I want a command button to go into tblSANConnections and snag information from fldServername of the current record displayed on my form, and hell, I dont know put it into a variable.
Can someone toss out a few key codewords that I can lookup to accomplish what im after? thank you
View 2 Replies
View Related
Dec 1, 2007
Hello there,
I have been bashing my head off of my laptop trying to get a query to return records where a date field is between two dates.
1. The field has a datatype of date/time
2. There are only two records in the database where the field Client.Refdate of record one is equal to 05/12/2007 and record two is equal to 05/01/2008.
3. The SQL was like this:
SELECT Client.clientMarital, Client.clientFirstname, Client.clientMiddlename, Client.clientSurname, Client.clientGender, Client.clientAddress1, Client.clientPostcode, Client.clientRefdate
FROM Client
WHERE (((Client.clientRefdate)>(#04/12/2007#) And (Client.clientRefdate)<(#06/12/2007#)));
However when I ran the query no results are returned.
I searched the forums and found this post: http://www.access-programmers.co.uk/forums/showthread.php?t=139619&highlight=dates
So amended the sql like so but to no avail:
SELECT Client.clientMarital, Client.clientFirstname, Client.clientMiddlename, Client.clientSurname, Client.clientGender, Client.clientAddress1, Client.clientPostcode, Client.clientRefdate
FROM Client
WHERE (((Client.clientRefdate)>DateAdd("d",1,#04/12/2007#) And (Client.clientRefdate)<DateAdd("d",1,([Client].[clientRefdate])<#06/12/2007#)));
Can anyone point out my error, or any potential things I have missed...I am going bonkers!
tenderfoot
View 5 Replies
View Related
Sep 16, 2005
Hi, i know i have done this before but its been so long and i know its real simple so here goes:
Say i have a record in a table and i want to add records to that record in another table does simply creating a relationship between the two tables make sure the information is relevant to that record and how do i add more than 1 tables information to a form so i could show the record from the first table and say all of that persons orders from another table?
Thanks for your assistance
Alex
View 1 Replies
View Related
Jul 23, 2015
I am trying to create a query that has a self referencing running total based on the values (point totals) of itself (running total of values in the running total column that have already been calculated for all previous records) plus the total of new points being added in the current record, less the total of points being removed in the current record. This running total can never go below 0, if it does, the running total should restart at zero and add in only new points and begin the process again with the next records
I am able to do this in Excel in less than two seconds so I know there has to be a way to port this into a query. I've attached an excel example of what I am exactly trying to do
If it takes multiple queries to complete the required output I am ok with it. In my previous outtakes I have had up to 8 queries but just couldn't seem to do it..
View 9 Replies
View Related
Mar 8, 2008
Hi,
1) I am pretty newbie to this access programming, do forgive me if my questions sounds stupid.
2) Basically I create an application in access capturing or production information for my company. now the top management suddenly wanted whats their main concern:- Total Daily/Monthly, Quarterly, Annual Sales (By Model If possible)
3) I start with daily (Lets don't be too overly ambitious).
4) I try to let user select dates from my calender control and reflect daily sales (in Total & By Model break down) insert into my form.
5) Understand someone told me from my previous post in Calender control I can achieve it either through forms or queries, which is a better way. (in terms of flexibility to change for program maintenance/ scalibility) wise ?
PS: Please forgive my ignorance :o:(
Thanks (In advance) & God Bless.
View 2 Replies
View Related
Dec 31, 2012
I have a table with 4 field which describe clips.
ClipName (txt)
ClipSize ( Long Integer)
ClipDuration (HH:MM:SS)
Date created (dd/mm/yy).
I would like to get the total of ClipSize and also total of Clip Duration either in table down or in query.
View 13 Replies
View Related
Aug 24, 2006
I have a table with a number of fields and made a query to get some sums/totals.
In the query I made three fields :
Gast : DSum("[aantal]","TbBedrag","[Discipline] like 'gast*'")
Elec : DSum("[aantal]","TbBedrag","[Discipline] like 'elect*'")
Pumps : DSum("[aantal]","TbBedrag","[Discipline] like 'cent*'")
The first gives me the sum of ‘aantal’ where the ‘Discipline’ is Gasturbines, the second is the sum of aantal in electronics, etc.
I made another field which is supposed to give me the total of the three forementioned fields : totaal: [gast]+[elec]+[pumps]. The output of this field however does not give me the actual total, but writes the numbers of ‘Gast’, ‘Elec’ and ‘Pumps’ after another, instead of totalling the three numbers.
Strange, why would the total not give me the sum of the three calculated fields ?
View 14 Replies
View Related
Oct 30, 2005
Hello there
im having trouble summing a number of fields that contain a value of £0.00 or blank for example i have five fields on a form £2.50 £0.00 £3.00 £ £4.00 if all fields have a value then the correct total is displayed i have tried =([price1]+[price2]) ect or sum which does work but not if £0.00 or £ are used obviously the result i am after is total £9.50 can anyone help i want to be able to sum or add all fields to give a total including numbers £0.00 and blanks please no code because i wouldn't know what to do with it just keep it as simple as possible i intend to write the formula in the totals field not in the footer i would really appreciate your sugestions
many thanks Richard
View 2 Replies
View Related
Jun 2, 2006
Hi
I have made a database in access 2000, and in one of the reports i have "iff" statements in a field but if i try total the whole column it give s me a error:
=IIf([MATURITY DATE]<[DATE],0,FV(0.09569/12,[TERM],[PREMIUM ]/[MODE],-([PURCHASE PRICE]+[PREMIUM ACCOUNT]))) (EXAMPLE: of iff statement.)
this gives me the answer i want but i want to sum the whole column.
if i try sum total i get a error?
george
View 1 Replies
View Related
Apr 3, 2007
Well at the moment i'm still in the design stages, but i made a database with test fields to see how it would work out best.
Basically i have to have a form with a drop down list for each type of computer componant and when selected the total price for all the items selected so far needs to show up at the bottom of the form.
Or when a button is pressed the price could be updated, that is fine too!
The way i was planning to do it was having an orders page, in which each field was a lookup to a difference table, one for each componant
Processor; ProcID, Proc name, Proc cost
Anyone have any ideas on the easiest way to load the total value for the items selected? Would be much appreciated! Thanks!
View 12 Replies
View Related
Aug 5, 2005
O.K, I am really trying to figure this out from other postings but my limited query experience is limting my understanding of the other posts.
I only know how to use the query wiz and then a bit in design mode.
I have a Query
[ID]pk [Contest Name], [Score]
There will be many records for the same [Contest Name] in the underlying table. Therefore i want to sub total by [Contest Name] so i can then create a report. I have created the report perfectly using the Report support in another posting submitted. But the report does not allow me to order the results as the sum calc is a function on the report. Therefore I am now exploring the Query Sum [Score] order by [Contest Name].
I just need it in a Qery for dummies format.
Go into design mode and put the following in what portion of the query on what line.
I will keep on searching in the mean time
View 1 Replies
View Related
Oct 10, 2005
I have a query which returns charge_cost (based on course cost, whether it went ahead, if hospitals are eligible for charging etc) which is then used in an existing report.
I want to make another report which simply is:
Total training spend for 2004-2005:
£1276.04
And i just want that to be the SUM of charge_cost.
I cant work out how to do this - i did a new query including charge_cost and then created a new field called total_spend: sum([charge_cost]) but i keep getting the message "You tried to execute a query which does not include the specified expression charge_cost as part of an aggregate function"
I have no idea what this means...
View 2 Replies
View Related
Oct 13, 2005
Please Help. I am tring to get the Month to date, year to date and week to date total in a query. I added a parameter for a date range. Instead of giving me the mtd, wtd, ytd, I get the whole months daily total. Can someone tell me what query caculation do I need to just get one number instead of daily numbers?
View 2 Replies
View Related
Oct 28, 2005
One of the tables in the database has these fields
st1: st2: st3: st4: Date:
pass fail fail pass 10/21/05
fail pass fail pass 10/22/05
and so on. What I need to do is extract the number of passes and fails on each of the four stations and put them into a report. User will have to enter either one date or a date range.
Right now, i'm having to create a 8 queries for to find Count of Pass and Fail on each station and make a master query. And I because it's not grouping everything together I can't figure out a way to get a date range...
Please help,
View 10 Replies
View Related
Mar 9, 2006
Hello,
I imported an excel worksheet (~20,000 entries) into Access, and I am
trying to extract some information. First I wanted to find duplicates,
and rank by duplicate appearance. I have gotten that part.
In my db, I have a column 'Qty' that specifies the number of times the
event occurred. At the moment, I only have the number of times the
event appeared in the db. I would like to factor in the number of times
now.
An example of my db would look like:
ID(access) Event Qty
1 A 10
2 B 100
3 C 30
4 A 60
5 A 50
So in my initial query, I get
Name:Query1
CountofID Event
3 A
1 B
1 C
However, to take this further, I want to be able to total the Qty field for each event. So, in this case, A actually needs to be 120, B needs to be 100, C needs to be
30.
My idea is to make a second query based off the first query, where one
item would be the Event# from Query1 (because that cut out all the
duplicates), and the second would be the all the number of occurences
of that event added up.
I did some searching before posting and this thread seems somewhat similar to what I need, but he is looking for a moderately different solution.
http://www.access-programmers.co.uk/forums/showthread.php?t=103526
Any help is appreciated, Cheers.
View 1 Replies
View Related
Apr 5, 2006
Hi. In my query I have a Name column, day column (With a drop down box for the 7 days) and 10 task columns showing hours worked on each task.
I need to try and find a way automatically calculate to show the total hours worked for each specific day for each person and show each total value on a report and in a form.
Any Ideas?????
View 1 Replies
View Related
May 16, 2006
i'm on a stump atm
how would u count the total # of client in town to show on the query
View 1 Replies
View Related
Aug 29, 2006
hmmm... found another little problem. I've got a list of ingredients with cost and amount from a table, total cost per ingredient is simply amount times cost, how would I go about getting a recipe total by summing the seperate ingredient totals?
View 2 Replies
View Related
Nov 17, 2006
This is what my query looks like at the moment:Field: Issue,Rejected,Inspected,AreaTotal: Group By,Sum,Sum,WhereCriteria:,,,[Area:]What I'd like to have is a calculated field after "Inspected" which would show the grand total of all "Inspected" for that "Area".Example:Issue, Rejected, Inspected, Total Inspected Scratched, 5, 100, 130Chipped, 1, 10, 130Dented, 2, 20, 130Any ideas on how to get the "Total Inspected" field?Thanks!
View 1 Replies
View Related
Nov 19, 2006
Hi, i'm trying to calculate the amount of employee for each company giving me a total in the queries.. how do i go about this? I'm not an person who uses Access to solve this. I have amount 20 Companies stored and over 800's employee.. Here are the field in the table:EmployeeIDEmployeeNameNumberofEmployeeThanks! Hope this helps.
View 1 Replies
View Related
Feb 4, 2007
is there a way to calculate/store total cost value of qty x unitcost in total cost field of same table. if it requires a query, would appreciate guding me how to write it.;) ;)
View 4 Replies
View Related
Jul 27, 2007
Hello all,
I again ran into something that I can't figure out.
I have a table:
Date
Time
FirstName
LastName
SSN
InAmount
OutAmount
I need a query to sum up the InAmount and OutAmount into one total based on the SSN. This query is placed into a form that is then placed onto another form. The form is to alert the user if the amount of the Inamount and Outamount of a unique SSN totals above $10,000.01 on the current date.
So for example if on 01/01/07 if SSN=111-11-1111 has an Inamount of $5,000.00 and an OutAmount of $5,000.01 thus totaling $10,000.01, then the person's name will appear on the form list. This will change/clear when the date is 01/02/07.
Any Ideas on how to accomplish this?
View 9 Replies
View Related
Dec 4, 2007
Ahhhh this is doing my nugget in!!! I have a simple table with 4 fields
ID (unique number)
DATE (date)
CAPACITY (number of SKU we can hold)
ORDERS (number of SKU on order)
the data looks like this
ID DATE CAPACITY ORDERS
1 01/01/2007 250000 250000
2 02/01/2007 250000 300000
3 03/01/2007 250000 300000
4 04/01/2007 250000 300000
So looking at the above table we can see that we have more orders than capacity in our factory, however they require to see this in graph form, so what I need is for each ID a running total of the CAPACITY and ORDERS so over a given date range i would produce a graph to find the "pinch points" where we could see if the capacity is less than the orders we have over time.
so my new table would be:
ID DATE CAPACITY ORDERS CAPRUN ORDRUN
1 01/01/2007 250000 250000 250000 250000
2 02/01/2007 250000 300000 500000 550000
3 03/01/2007 250000 300000 750000 850000
4 04/01/2007 250000 300000 1000000 1150000
etc. which i would create my graph from. Ive looked at Dsum and some other methods but cant get my head around it so any help will be much appreciated.
Thanks Steve.
View 14 Replies
View Related
Apr 2, 2005
Hey All,
I must first apologize for my total stupidity when it comes to MS Access but this is something that should be soooo easy but I can't seem to figure it out for the life of me.
I'm working on a database and the two biggest issues I have at the moment are clearing all fields when I save the record or open up the form to enter new records. The second big issue I have is when I do a query I'd like for only the records belonging to the specified customer or location to be entered into the fields.
If anybody can help please respond and I can email you a basic mock-up of my current database in hopes that one of you magical people out there can help a poor guy out. This is for my mother-in-law so you can understand my panic. hehe
Thanks in advance for any help you can provide.
axsnub (Access Newbie)
View 3 Replies
View Related
Jul 7, 2005
I have created a database that calculates a total for a week or month depending on what the customer wants.
How do I calculate the Tax it?
I have attached the Databases in case it helps
Any help would be great.
View 3 Replies
View Related
