|
|
Cross Join - Please Help! by
MichaelR
Hi,
I have two tables - one has all of my company sales data (MCB Sales Data)
with many columns and the other (Rep State Product Assignment) has the states...
|
|
5 |
193 |
|
|
Time format changes during merge to Word by
Destin Richter
Hi, using a medium format for a HearingTime field, showing up fine on the
queries, but when I merge the data out to Word, it shows up as 3:15:00 PM - I...
|
|
3 |
154 |
|
|
How do I query a query? by
Antavas
I have a parameter query that allows me to enter a date range using the
"Between and " this returns all issues opened during a certain time
period.
What I...
|
|
1 |
119 |
|
|
|
July 15th, 2008 03:55 PM
by KK
|
2 |
132 |
|
|
VB Functions not found by
Kevin
I'm using Access as a database without a GUI. We are querying the data and
obtaining result sets from a Windows C# app. I've written some VB functions
in a...
|
July 15th, 2008 03:06 PM
by Kevin
|
4 |
123 |
|
|
Delete characters up to a space by
David#
I have a field that I need to delete all characteras up to and including the
first space. The first space may occur anywhere from the second to the
eighth...
|
|
1 |
200 |
|
|
|
July 15th, 2008 12:59 PM
by Ron2006
|
4 |
162 |
|
|
Format Value within iif statement by
alecgreen
Hi
I have this formula - Margin%: IIf(=0,"****",(-
)/*100), and I want to format the result (if not zero)
to 2 decimal points.
Mant Thanks
Alec
|
|
4 |
151 |
|
|
|
|
1 |
140 |
|
|
Expression builder trouble by
Miki
I got a trouble in using commas in the expression builder. Somehow all commas
in the expressions got converted to vertical bars so all my previous query...
|
|
1 |
190 |
|
|
Like and Multi-criteria with Multi-Values by
roccogrand
I have a form in Access 2007 that uses a query with multi-value fields. The
query has multiple criteria that uses two parameters (on two different lines
in...
|
|
4 |
134 |
|
|
Group Totals in a Report by
CDG via AccessMonster.com
I would like to have separate grand totals for 2 groupings in a report. The
groups are sorted in the grouping/sorting section and they have a
header/footer. ...
|
|
3 |
271 |
|
|
VB Code - Query by
Rus925
I have VB code for a query, but I don't know how to turn it into an actual
query. Any advice? Thanks!
Here's the basic code (from...
|
|
3 |
131 |
|
|
Count queries -- make zeros show by
kahaymon
I need a count query to tell me when there are zero records, rather than
nothing show up. How do I accomplish this?
|
|
5 |
182 |
|
|
Please help with my query by
Please Help
Hello all,
I have two tables: one with data on how much we get charged from our vendors
(Table 1) and one with prices from the industry (Table 2).
Table 1...
|
|
1 |
127 |
|
|
Please help with my query by
Please Help
Hello all,
I have two tables: one with data on how much we get charged from our vendors
(Table 1) and one with prices from the industry (Table 2).
Table 1...
|
|
0 |
108 |
|
|
What's wrong with my IIF Statement? by
MB
I'm using this expression in my query and it works great:
PressureSco
IIf(=80,"0",IIf(=100,"2",IIf(=120,"4",IIf(=140,"6",IIf(=141,"8")))))
However,...
( 1 2)
|
|
10 |
230 |
|
|
dropdown decimal places by
News Boy[_2_]
I have long integers formatted as fixed with zero decimal places. They
appear correctly on the form's control boxes, but on the drop-down list
displays them...
|
|
7 |
175 |
|
|
Multi-query issue by
Antavas
I have a data table that contains an open date and close date for each entry.
I've been asked to create a report that does the following 3 things:
allows a...
|
July 14th, 2008 08:40 PM
by Antavas
|
3 |
115 |
|
|
Passing Parameter by
Atif
I have a Select Query based on Two Crosstab Queries.
I want, when User execute the query, it ask for Parameter to Privide,
instead Text Box i want a List Box...
|
|
1 |
131 |