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
Display multiple fields in one field by Ray
I use the following code to display multiple fields in one field successfully. Expr2: +", " & +", " & Results: Susan Wu, John Ni, Echo Peng, Chen...
November 7th, 2004 05:20 PM
by Ray Go to last post
2 321
Recorset or calculated control? by Crag
I'm trying to create a custom autonumber that increments on a trigger (i.e. change of name in a text box containing names of staff) so that say 6 records...
November 6th, 2004 09:32 PM
by Steve Schapel Go to last post
1 246
how to get dates for a months and year by Alex
I need to generate a query with annual sales and with sales per months. I'm going to create the queries for the total year and months separately and...
November 6th, 2004 09:17 PM
by Alex Go to last post
3 317
residential question by BVG HOA
I have a residential database for a Homeowner’s Association and I’m rather new at this Access thing. I have created a table with lists of unit...
November 6th, 2004 05:32 PM
by Ken Snell [MVP] Go to last post
7 208
Help Please by D
I have: F1 F2 F3 1 12Oct 2:14 0 12Oct 2:14 0 13Oct 1:15 when is the same day and time I would like a condition that shows just the record with value in...
November 6th, 2004 02:31 PM
by John Spencer (MVP) Go to last post
2 200
Using multiple checkboxes by DrEvil
Hi My problem is this; i got Query (qryETime) that is getting date and name from form (frmETime) date is date range and name is combo, that all work fine. Once...
November 6th, 2004 02:22 PM
by John Spencer (MVP) Go to last post
1 322
Combine several fields to one column by John
I gave a table that contains 7 fields Doctor1, Doctor 2, thru Doctor7 I would like a query that will combine all the fields from the table and display it as...
November 6th, 2004 02:08 PM
by John Spencer (MVP) Go to last post
2 178
Who has the solution to this problem ?????? by Ellada
Hello, I am building a hotel reservation system. For this query there are two tables which i used "tblRoom" and "tblReservation". The query below shows me...
November 6th, 2004 01:22 PM
by Dale Fye Go to last post
3 153
Part 2 of IIf function by Jack Houck
Here is my basic IIf function that I'm using. q05z: IIf(Mid(,1,2)=1,"01"," ") It's looking at the first 2 spaces and if it's equal to 1 then it puts "01",...
November 6th, 2004 10:19 AM
by Steve Schapel Go to last post
2 180
concat strings on sum query by Mike
I need to write a sum query however one of the fields needs to be a concatenation of the detail records. for example bob 10 chuck 20 would come back...
November 6th, 2004 09:16 AM
by Van T. Dinh Go to last post
3 132
Progressive number by Student
I've a query that make a progressive number NUM: Num: (Select Count (*) FROM as AAA WHERE ..)+1 NUM | IDCLIENTE 1 | 1 2 | 3 3 ...
November 6th, 2004 09:07 AM
by Student Go to last post
0 135
sutting down dvd drivers by paul
this is the message I get when I start up my computer as I said I had 2 months problem free until a week ago A CD-recording driver is installed that might...
November 6th, 2004 01:45 AM
by Van T. Dinh Go to last post
1 154
Display query result which contains many rows of text by vv
Hi all, I want to display a query result which contains many rows of text (a paragraph). I have tried to use text box. However, I found that there is...
November 5th, 2004 11:48 PM
by John Spencer (MVP) Go to last post
2 222
Transpose like (Crosstab) query by Lee Hunter
I would like to perfrom a Transpose like query where the intersection is an actual field rather than an expression. For example, part, defect and date. I...
November 5th, 2004 08:57 PM
by [MVP] S.Clark Go to last post
1 163
Concatenating Fields by Jack Houck
Hello, I'm having problems with an attempt at concatenating fields in a query. I have data coming from a link (questions with answers) that is split up into...
November 5th, 2004 08:50 PM
by [MVP] S.Clark Go to last post
1 211
Can parameter queries working with crosstab queries. by FatMan
I have a query that gets its criteria from a form. This query is complicated in the fact that it draws part of its information from a crosstab query. Because...
November 5th, 2004 08:10 PM
by FatMan Go to last post
2 305
Rank Scorecard Results by Ndel40
I have a query that creates a scorecard and sorts the results in desending order. I would like to assign a ranking based on the results. Below is an exmple...
November 5th, 2004 07:35 PM
by Ndel40 Go to last post
2 245
Automated Email by Petra
I've created an Outlook email template designed to automatically be sent by Access, with the requirement that the contents of the email msg populates a master...
November 5th, 2004 07:16 PM
by Petra Go to last post
1 151
Identifying duplicates by Brenda
I am trying to identify duplicate + role for borrowers and collateral owners. This is not working. How can I code it? And, what does the HAVING clause do? I...
November 5th, 2004 05:41 PM
by Gerald Stanley Go to last post
1 121
Does Access have a "frequency" type function? by L.O. Monaghan
I know how to use a FREQUENCY function in Excel to count the number of occurences that fall within ranges of values. Is it possible to set this type of...
November 5th, 2004 05:35 PM
by Marshall Barton Go to last post
1 101
Post New Thread


Display Options
Showing threads 40001 to 40020 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 04:38 PM.


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