|
|
HAVING clause by
Rebecca
Having trouble with HAVING clause.
Say my table shows families with one row for each kid, labeling that kid's
gender
So Jones family has 2 girls, 1 boy;...
|
|
2 |
281 |
|
|
Validating Email Address by
Steve Stad
I want to verify/validate user has input a good email address so I am
checking for the '@' sign and a period in the email string. Is there a
better way? ...
|
December 31st, 2009 06:00 PM
by Dale Fye
|
5 |
239 |
|
|
Monthly Averages by
Nedan Nedzatra[_2_]
Hia!
How are you friends!!
Some help please;
I have a 2 column table on Access 2002. One field(ProductsSold) has inetgers
and the other dates spread over...
|
|
2 |
180 |
|
|
Date range for a report by
Tracey
Hi
I am trying to run a query and can't seem to nail down the right code.
We use the access database to track files, incoming/outgoing correspondence
dates...
|
December 31st, 2009 03:31 PM
by Tracey
|
3 |
225 |
|
|
insert rows after count by
Ginger
Query shows 5 years of data for various accounts. Some accounts may not have
5 years of data however I want rows added with the year that doesn't have...
|
December 31st, 2009 03:22 PM
by Dorian
|
1 |
191 |
|
|
|
December 31st, 2009 03:02 PM
by Dale Fye
|
2 |
232 |
|
|
Make URLs by
EllenM
Hello,
I'd like to make urls by concatenating three fields. The urls will look like
this:
a href=''Introduction/a
I think it should constructed like...
|
|
4 |
182 |
|
|
|
|
4 |
198 |
|
|
|
December 31st, 2009 02:24 AM
by david
|
1 |
200 |
|
|
|
|
3 |
173 |
|
|
|
|
10 |
314 |
|
|
splits investment transaction by
Anne
I need an idea on how to split a transaction into two. I am recording
investments in stocks and bonds, and many times only part of the shares are
sold and I...
|
December 30th, 2009 10:14 PM
by Anne
|
1 |
137 |
|
|
calculated field by
angie
i have a query with the following fields:
year, month, customer, debit euro, credit euro and balance (debit-credit).
the query returns multible entries for...
|
December 30th, 2009 07:31 PM
by Anne
|
3 |
194 |
|
|
format OXXXXXO by
Octet32
I have a field in a query called DELDAYS in the field the date reads 0XXXXX0
how can I for matt this so it will show as SMTWTHFS? This date represent the
day...
|
|
6 |
297 |
|
|
|
|
1 |
150 |
|
|
show top values by
Ian
posted to SQL Queries English with no reponse -- sorry for the repeat
I have a single table with 5 fields:
READID (key, INT), ID (user identifier, INT),...
|
December 30th, 2009 05:14 PM
by Ian
|
5 |
218 |
|
|
|
|
6 |
341 |
|
|
|
|
3 |
193 |
|
|
help with nested iif statement by
Help with complex nested iif statement
I have a table and I want to create a query that has a new field "
Type of Shipment" base on a field "Item Category"
If the item category field equals ZDIR,...
|
|
3 |
174 |
|
|
Dlookup Expression Error by
Pamela
My query is based on a table that I use to populate a cbo on a form. My
table includes: ID(pk), ShopName, and ShopCity (which stores the ID # from...
|
December 30th, 2009 02:06 AM
by Pamela
|
2 |
142 |