Presto731
Last Activity: Aug 27 '08, 01:49 PM
Joined: Jul 17 '07
Location:
-
i was only kidding, it was very simple.... -
Time is not on my side!!!
Ok, here is my query quandry
This may be more of a math question but I need help anyway. I should have paid attentionin high school i guess
I have a large amount of data that that is entered each day into a database. Two peices of the data need to be divided by each other to arrive at a percentage. Both types of data are time. However both come to me in a different format.
Here is an example of how they... -
Do you have a simpler way :D
Thanks!...Leave a comment:
-
Capital Letters
HOW do i make the letters in various fields on a form always be capital no matter if they used capital letters or not when typing? -
Thanks Stewart that was exactly what I needed!!!Leave a comment:
-
that looks like what I was needing. Thank you i will try it...Leave a comment:
-
Maybe IIF, I don't know Round 2!!
I would prefer to do this with an IFF statement as it would be the easiest way for me to continue with the project.
Here is what I need. in a table will be a number. based on that number three values can arrise, we will call that number x and the threshold will be y and the resulting value will be z
Here are the three resulting values
if X is less than Y, then Z will equal a calculation based on a certain... -
The categories are weighted and are reflected in the amount of points they get within each range, each percentage range is also different for each category.Leave a comment:
-
Maybe IIF, I don't know!!!!!
I have a table that monitors employees performance on 10 different categories. For each category they receive a percentage. Each range of percentages is assigned a number.
For example. If for category 1 they have 85% their score would be x. So 0-19% is one pint, 20-29% is 2 points, so on down the line to 100%. each category has different ranges and point values.
I have never had to write such large IIF statement for... -
Macro fun!!!
I need to create a macro (or whatever else works) to copy a SQL table to update an existing Access table on a daily basis automatically.
Ideally i would like it to run once a day.
I am linked to the SQL tables i need but they are killers to run as the work and data they retrieve is quite large. I am trying to avoid slowing down by updating my access tables with the data and running all my queries from them.
... -
IIF-EEEEE proposition
I have a query pulling from another that takes into account two columns to arrive at one on the new query.
I need to get my IIf statement working correctly, but cannot seem too. Here's an example
ColumnA is a yes or no answer, if the answer is yes it pulls the data from another column, call it ColumnB. but if the answer is no, then the column should be zero. So if ColumnA=Yes and ColumnB=100, then ColumnC=100, however... -
Date Me!
I have a date field in my query. How can I make it so when the query opens you can selct a range or a month to show only those dates. I really need it to show a month. -
Command My Button
I have a query that has the information on 35 different stores, each has their own id. I want to make a form that has a map of the USA and each store will have a button and I can click it to open the queery record on that store.
My question is how do I apply that filter to my button so it oinly opens the correct queery record. Do I need seperate macros for each/ Can I apply the filter in the on click property. I tried to wirte the... -
I figured as much. But i will still take suggestions
Can i out tables that are only used to look up information on each local machine, would that help?Leave a comment:
-
Boost My Speed!
I have a database set up that 5-10 people on my network may be using at any given time. The majority of the tables they feed from are in a master database seperate from the one they use. I do this mainly so a table doesn't get accidentally deleted or ruined even though I back both databases up often.
Is there any way to to speed up the reports, forms and queries they run? I run the compact and repair often as well.
... -
will do, thank you for your help...Leave a comment:
-
where exactly do i type that codeLeave a comment:
-
lol, thats the long and short of itLeave a comment:
-
the table with the data looks like this:
point 1 point 2 mileage between them
xxx yyy 1234
yyy zzz 5678
zzz xxx 9101
etc............ ............... ....
there are about 1200 total
both point colums have the same info. so point xxx has mileage to all but xxx, yyy has mileage to all but yyy, so on............
my goal...Leave a comment:
-
Query look up!
I have a table that has mileage between two points. Each point has a unique id#
in my query I want to be able to type in the id for point 1 and then type the id for point 2 and get the mileage. I know by simply putting [enter] in the criteria field for point one i can look up that one, how do make it so you enter both id#'s and get the mileage for those two points.
any thoughts?
No activity results to display
Leave a comment: