|
|
Combine multiple records by
Andre Grujovski
I have a table with 3 columns. Last Name, First Name,
Amount. There are multiple entries for each name, eg:
Smith, Jane $50
Smith, Jane $100
Smith, Jane...
|
|
3 |
230 |
|
|
|
August 5th, 2004 01:27 PM
by Snide
|
2 |
554 |
|
|
|
|
3 |
127 |
|
|
|
|
1 |
612 |
|
|
|
|
6 |
106 |
|
|
Function to convert TEXT to a STRING by
Andre Laplume via AccessMonster.com
I know there is a MSAccess function: Cstr(value) that will convert a
numeric field to a text field. What is the function that takes a text
field (that always...
|
|
2 |
158 |
|
|
|
|
1 |
141 |
|
|
|
|
2 |
95 |
|
|
Combining data - remedial question :) by
Andrea
I have the fields LastName and FirstName in a datatable.
I need to combine this information into the format "LastName, FirstName*".
Can anyone help me do...
|
|
4 |
166 |
|
|
How can I round to the next month by
andrea
If an employee's probation period ends between the 2nd and the 30th of a
month, he/she will be eligible for benefits the following month, how can I
create an...
|
|
2 |
85 |
|
|
Concatenation by
Andrea
I have a query that I am trying to concatenate more than
2 fields. This new field is set up as a parameter that
asks the user for a value that equals the...
|
|
1 |
288 |
|
|
|
|
1 |
538 |
|
|
Quey Bug??? .... or is it just me by
Andrea
Here is a simple query that should match
Buy.ID with Sell.BuyID
SELECT Buy.ID, Sell.ID, Sell.BuyID
FROM Buy INNER JOIN Sell ON Buy.ID = Sell.BuyID;
But here...
|
|
3 |
150 |
|
|
Unique records by
Andrea
I understand the unique values property, but how does the
unique records property work. I have tried to use it,
but without any luck. Can someone give me a...
|
|
1 |
376 |
|
|
Changing records in a table by
Andrea Barton
I have two tables. One table is the main record holder (name, address, etc).
Within that table is a lookup field from the second table. The second table...
|
|
3 |
131 |
|
|
|
August 25th, 2005 11:52 AM
by fredg
|
1 |
219 |
|
|
Help! Not criteria by
Andrea McKee
I need to exclude all records have a particular value. Using the criteria
not like "steve" does filter out all of the Steves, but it also filters out
all...
|
|
2 |
110 |
|
|
Parameter Query Text by
Andrea Stimson
Hello,
I have a query set up which relies on the user entering a date. When it
prompts the user to enter a date the message (Now) comes up to enter the...
|
|
3 |
254 |
|
|
|
|
1 |
70 |
|
|
how do I query for date values? by
andrea5977
I have my date values set up as 00/00/0000. Is it possible for me to query
for all entries in a specific month (i.e. all June birthdays)?
|
|
1 |
127 |