|
|
IIf AND by
Gringarlow
I want to determine if a field is between two values.
If RecTime is between 1000 and 1200, return Y, otherwire return blank.
Thank You
|
|
3 |
179 |
|
|
Help with a query... by
Nuno Gomes
Hello all,
I have table Customer with the field CP
I have the table Cpostal with the field CP_NUM
The relation between this two tables is Customer.CP 1-N...
|
|
8 |
233 |
|
|
Converting text to a number in query by
Stephanie
I'm having trouble with a conversion in order to get a formula to work. I
have text that = numbers. Example: G++=1, G+=2, G=3,G-=4,G--=5, etc. I
need a...
( 1 2)
|
|
16 |
415 |
|
|
memo field in the select query by
inungh
I have a memo field in my select query and only return 255 characters.
Do I need specify any return type using select query for memo field?
The query is for...
|
|
2 |
176 |
|
|
Want a counter for Access Query results by
Stegra
I want to create a counter for a query by selected field results
Main sort - req number
Second sort - Date or Name or Time ...etc
Output1
Have counter...
|
July 2nd, 2008 03:48 PM
by Stegra
|
8 |
197 |
|
|
Calculate Age nearest by
J
Any ideas on a formula to calculate someone's age on their closest birthday
(last or next)?
For example:
Birthday = 1/7/1943
Effective date = 8/1/08
Age...
|
|
7 |
142 |
|
|
Inventory Control Query? by
Suzann
I need to develop a way to keep track of gift cards received and sold by our
company stores. We have 4 different card types and over 600 stores. I
receive...
|
|
3 |
242 |
|
|
Too many tables by
Ian Belcher
Hi,
I have a query that uses several subqueries. If I run this query several
times I get the error of too many tables open. I don't have any tables open,...
|
|
1 |
141 |
|
|
|
July 2nd, 2008 02:52 PM
by Klatuu
|
15 |
265 |
|
|
|
July 2nd, 2008 02:41 PM
by Sajit
|
0 |
160 |
|
|
|
|
4 |
185 |
|
|
|
|
7 |
186 |
|
|
|
|
3 |
195 |
|
|
|
|
4 |
250 |
|
|
Adding Calcs to a Crosstab? Or Form? by
carriey
I have finally figured out my first crosstab query and it does about half of
what I need it to do. I get a table that I have put into a form which
displays...
|
|
4 |
193 |
|
|
Roundup Function by
aMack
I can get the roundup function to do what I need in Excel - it does not give
the same results in Access.
Excel:
=ROUNDUP(2161/36,0)
Result is 61 in Excel....
|
July 1st, 2008 10:17 PM
by aMack
|
2 |
235 |
|
|
Trying to find values that are not equal by
Cindy
Hi;
I am a new user... I have the same field in two different tables. I tried a
query to find the records where the values are not equal. I used the...
|
|
1 |
156 |
|
|
Update Query to a SharePoint List by
Lori J.
I use Access and SharePoint daily, but just switched from 2003 to 2007
versions.
I have a list that was created in SharePoint that I have linked into...
|
|
0 |
152 |
|
|
|
|
4 |
185 |
|
|
Sum values of column by
NeoFax
I need to write an expression that sums the values of a query based on
the date. Here is the query setup:
Helo#(Dbl) Sample: 14701, 14702,...
|
|
1 |
201 |