I am attempting this now but it seems like this might work. I have
#include <stdio.h>
#include <math.h>
Is there anything else to include? For dispence?...
cori25
Last Activity: Jan 6 '09, 06:08 PM
Joined: Oct 15 '07
Location: Milford, CT
-
The max withdrawal is set to 500. I can set the simulation as I wish since the parameters were not given. This is to be a very simple source code since I have yet to learn float, cin, cout, ect.. I was thinking more along the lines of an if statement saying if it != 30, then do the amount divided by the bill but I am lost as to how to count the amount of bills as I said. Hope this makes sense. I usually can figure these out but spent 6 hrs attempting...Leave a comment:
-
ATM simulation
Hello,
I am creating a simulation assuming that the ATM only has $10, $20, $50 and $100 bills. I need the output to look like this:
Say the withdrawal amount is $90
Dispense: 1 - $50
2 - $20
I am having difficulty creating a function that will dispense as shown. I know that if i divide the withdrawal amount by 20 I will know how many 20's it would take for the amount but... -
Query Error: "Expession is too complex"
...Code:Paycode': IIf([Project Code]="01","Meeting",IIf([Project Code]="02","Training",IIf([Project Code]="04","Special Project",IIf([Project Code]="05","QC",IIf([Project Code]="06","MDU",IIf([Project Code]="07","UG",IIf([Project Code]="08","2nd Man",IIf([Project Code]="09","Sr Tech Other",IIf([Project
-
Determing data changes in access query
I have data in a table for the entire month which breaks out by date, each day I am running the data and updating what currently exists for that day so any changes made will be captured. For example, today, 9/12/08, I run the updates and want to determine if any of the data has changed from what was currently there. My first appraoch was to create a query where the table with the current data for 9/12/08 and the updated data for 9/12/08 would be... -
What email application are you sending from? outlook, groupwise??Leave a comment:
-
What kind of a chart do you need this done in? Excel, word, access?Leave a comment:
-
Thanks everyone for all the feedback! I actually got it to work by using an IIF statement to look st anything with more then 56 hours per month(seven 8 hour days).
Thanks again!
:)CoriLeave a comment:
-
I have already attempted the group by and min, max, count approach with no luck. I ws thinking more along the lines of having an IIF statement of some sorts, but it is a little tricky.
Thanks anyway...
I will continue trying to determine if this can be done
Thanks again
Cori...Leave a comment:
-
Determining if data is consecutive in VB
I have a query which displays the employee name, month, date, exception. I need to have the query display when an employee has more then 7 consecutive days with a certain exception. Meaning the same employee name and month has to be >= 7 days which would be "Blocked" anything under this is "Intermitte nt". I though about and iif statement but it has to have the same employee name and month so I get thrown off.
... -
Thanks so much for the great feedback! Too bad access can't do everything we want, haha :)
-CoriLeave a comment:
-
Hi Stewart,
The fields are Date, Shift, Total Out, Month, Day. I understand where you are going with the concatenated field. Now the next problem I did not think of until actually attempting this was that the Total Out field represents if there is more then 1 shift available. Meaning that if I have 2 of the same date,shift, ect. available. So if I have 1 shift signed up for all I want is for the Total Out field to subtract 1. Therefore,...Leave a comment:
-
Thanks for the response but this will not work in my case. It is a little more complicated then I explained. Basically, I have employee's who sign up for OT shifts(tbl_Sign edUp). The shifts are located in tblAvailability . Query_SignedUp has both of these tables and only includes data that has the same date and shift. Meaning, if it has been signed up for that it should no longer be present in tblAvailability . So I need to have the the fields from...Leave a comment:
-
Delete Query Question
Is it possible to delete data from one select query from a table?
Example:
I want to delete Query_SignedUp from TableAvailabili ty. The fields are the same I just can not figure out if this is possible in a delete query.
Any help or suggestions greatly appreciated.
Thanks
-Cori -
no, you need it in a format that is legible as rows and columnsLeave a comment:
-
SELECT IIf([table1]![ID]=[table2]![ID],"Yes","No")
FROM table1, table2;Leave a comment:
-
It is possible in a macro, you would have to do a transfer spreadsheet for each table and define which sheet it should go to.
Although, I try to avoid transfer spreadsheets and do it in a module.
If you need more assistance, just let me know.
ThanksLeave a comment:
-
This is occurring because there is so much data. It will go to the last record if you let it finish. If you have already pulled in your data based on specific criteria so that it will not pull in everything, then the only other option is to make it "Group By". This may speed things up a little.
Otherwise, it may be the table you are adding in(dbo_INIH). Instead of bringing this in directly, create another query and pull...Leave a comment:
-
Hello,
In order to have either a query, macro, module run on open of access all you need to do is create a new macro. Select the RunMacro that you would like to have run on open, when you save this macro you must name it "autoexec". You must spell it exactly like I have done here. Then when you open the database, your macro will run.
Hope this helps, if not let me know because there are other methods although...Leave a comment:
-
This error sounds like it is because the two tables do not have the same value(text, number, etc...). In order to append from one table to another they must be the same. Therefore, check the tables in design view and ensure they are matching.
Let me know what happens.
Thanks!Leave a comment:
No activity results to display
Leave a comment: