|
|
Group by query question by
Joseph Greenberg
I have a query which is supposed to (and does) return the earliest record
from a table that might have multiple records per "person" (famno). "dis is
a...
|
|
2 |
186 |
|
|
Need help sorting a query by
Iram
Hello,
I have a combobox that is called "Category". This combobox runs a query that
has two fields "Category" and "Team" from a table.
I need to sort the...
|
|
3 |
176 |
|
|
|
April 23rd, 2010 11:48 PM
by JohnW
|
2 |
154 |
|
|
Multiple "Not Like" not working by
Iram
Hello,
I need help writing a query that will exclude certain data.
I can successfully exlcude one item but when it comes to excluding multiple
I can't get...
( 1 2)
|
|
10 |
366 |
|
|
A spin on a common question. DateAdd by
Flopbot
This is a spin on a common question. I have a query with a field labeled:
Day: Format(,"ddd, mm/dd/yy"). I need it to display the day along with
the date...
|
April 23rd, 2010 11:33 PM
by Flopbot
|
2 |
207 |
|
|
#Num! in Link File by
Mike
I am trying to link an excel file into my database. However when it is
finished linking, I have #Num! throughout the file. Certain fields in the
file contain...
|
|
1 |
184 |
|
|
5 Fields Multiple Values by
Ripper
I have five fields that can contain either 1 or 0. Let's call them Fields A,
B, C, D, E.
I need to write a query that will select them if any of the Fields...
|
|
5 |
201 |
|
|
Multitable query problem by
atledreier[_2_]
Hey.
I have a problem I can't wrap my head around.
I have a database with mostly normalized data.
I have a few tables with a common key, so they are no...
|
|
7 |
184 |
|
|
Requesting Help Ranking Sales Values..... by
CBender
I have a field in a table named "Ext B/O" that lists the extended Backorder
Value for parts sold. There may be duplicate values and they should show the...
|
April 23rd, 2010 04:46 PM
by CBender
|
6 |
206 |
|
|
Numeric Field Overflow by
Mike
I am trying to run a make-table query which has limited data from an excel
file. It errors out and gives me "Numeric Field Overflow". However, when I
compact...
|
|
1 |
199 |
|
|
|
|
1 |
197 |
|
|
|
|
2 |
147 |
|
|
Export empty columns to Excel by
atledreier[_2_]
I have a database, and some data in that needs to be imported into
another database through Excel. I have no control over this, that's
the way it needs to be....
|
|
1 |
155 |
|
|
pass through query variables by
SimonT
Hi Guys,
I am looking for some help with a pass through query. I have a number of
reports that allow users to select values from combo box's and want to...
|
April 23rd, 2010 09:54 AM
by SimonT
|
6 |
193 |
|
|
Change format of date in query? by
Flopbot
Can this be done? I hope I’m missing something small. A query named “Qry
Monthly Volunteer Email” has a field named . Right now it returns
4/24/2010...
|
April 23rd, 2010 02:23 AM
by Flopbot
|
3 |
171 |
|
|
|
|
1 |
192 |
|
|
Running queries via forms by
Dragon
is there a good tutorial out there on how to make forms that run queries and
reports? I've gotten all turned around on it all.
|
|
2 |
235 |
|
|
Help with Query to find Month by
AccessKay
I need some help please. I want to build a query based on a form with two
combo boxes for Month 1 and Month 2 and then have a report that has two
columns...
( 1 2 3)
|
|
25 |
588 |
|
|
Query criteria based on table entries by
Robbro
I have a report based on a query to report our "10 worst" customers based on
a couple of factors. Certain customers however are just buying our off
quality...
|
|
2 |
236 |
|
|
Trying to update a field by
Brian T
Hello all,
I have created a query that has project details such as the award cost and
want to determine the total cost of the project by bringing in the...
|
April 22nd, 2010 07:16 PM
by Brian T
|
2 |
144 |