A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Post New Thread
Threads in Forum : Running & Setting Up Queries Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
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...
July 15th, 2008 07:31 PM
by John Spencer Go to last post
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...
July 15th, 2008 07:25 PM
by Jerry Whittle Go to last post
3 153
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...
July 15th, 2008 04:14 PM
by Golfinray Go to last post
1 119
Take data from table, make a list of unique values by KK
I have a table which has rows and rows that look like this: A, 1 A, 2 A, 3 A, 3 A, 3 B, 1 B, 2 B, 2
July 15th, 2008 03:55 PM
by KK Go to last post
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 Go to last post
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...
July 15th, 2008 03:03 PM
by Allen Browne Go to last post
1 200
Trying to merge multiple tables with access by [email protected]
Hi everyone. It's been tree days that i'm tryig to merge 7 forecasts for my compagny. They are linked on my sharepoint server and I open them with acces...
July 15th, 2008 12:59 PM
by Ron2006 Go to last post
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
July 15th, 2008 11:30 AM
by alecgreen Go to last post
4 151
Query to update qty on insert in another table by Daniel[_10_]
I have a site im working on and certain details on the page are based on the qty we show to have available.. How can i write a query or insert so that when a...
July 15th, 2008 09:20 AM
by bcap[_2_] Go to last post
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...
July 15th, 2008 03:07 AM
by Allen Browne Go to last post
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...
July 15th, 2008 03:03 AM
by Allen Browne Go to last post
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. ...
July 15th, 2008 01:55 AM
by CDG via AccessMonster.com Go to last post
3 234
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...
July 14th, 2008 11:59 PM
by Douglas J. Steele Go to last post
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?
July 14th, 2008 10:24 PM
by Bob Barrows [MVP] Go to last post
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...
July 14th, 2008 10:14 PM
by Please Help Go to last post
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...
July 14th, 2008 10:07 PM
by Please Help Go to last post
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,...
(Multi-page thread 1 2)
July 14th, 2008 10:00 PM
by raskew via AccessMonster.com Go to last post
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...
July 14th, 2008 09:27 PM
by Marshall Barton Go to last post
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 Go to last post
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...
July 14th, 2008 07:27 PM
by Amy Blankenship Go to last post
1 131
Post New Thread


Display Options
Showing threads 9921 to 9940 of 43289
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:28 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.