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
Scoping Report Output using Parameterized Query by DBG
I have the following code on my report: Private Sub Report_Open(Cancel As Integer) Dim PONum As String PONum = "1276" ' Sample number for testing Dim db As...
September 8th, 2005 09:53 PM
by MGFoster Go to last post
1 107
How do I calculate an Average Daily Balance in Access? by JOhnDragt
I am required to find a daily average balance in an access database and am lost. The data that is entered is not on a daily basis
September 8th, 2005 09:55 PM
by JOhnDragt Go to last post
2 89
Adding records to a table by Petterq
I have a table consisting of several fields, where one is a customerID. I would like to repeat all records for one customerID in the table, but changing the...
September 8th, 2005 09:55 PM
by Michel Walsh Go to last post
5 111
Distinct and Concatenate by Gwen H
I've been looking at similar questions posed on this discussion board, but I can't quite figure how to do what I need. I have a Guarantors table with...
September 8th, 2005 10:12 PM
by Gwen H Go to last post
3 200
How do I import data from one table into another? by Mo Man
Hi All I have two tables - tbltaxes and tblvoters. The tables are structured the following way Tbltaxes Field Description Location Address of the...
September 8th, 2005 10:56 PM
by Mo Man Go to last post
4 100
Quiz Test Maker by Tony Dondero
Did this work? Have you done this? I was looking at doing something similar. If you got it to work I would be interested in the file if you wouldn't mind...
September 8th, 2005 11:00 PM
by Tony Dondero Go to last post
0 483
Can a field in a table get its value by referencing another table? by kelly d via AccessMonster.com
Can a field in one table get its value automatically by referrencing the value of another field in its record against another table? as best I could explain...
September 8th, 2005 11:20 PM
by kelly d via AccessMonster.com Go to last post
1 190
How can I set up a query inside a query? by jaybear
I am trying to narrow a search field down by topic. I have over 200 rows of information, that fall into 4 topics. For sake of arguement we will say 50 rows...
September 9th, 2005 12:30 AM
by PC Datasheet Go to last post
2 153
Query "N" previous records starting with this record by [email protected](donotspam)
I have a table with 2 primary keys that are in TEXT format. Date is Primary Key 1 in this format (e.g. "2005.08.30") and Time is Primary Key 2 in this format...
September 9th, 2005 12:40 AM
by John Vinson Go to last post
3 98
Trying to get a query to return certain records by jbirchal
IIf(!! In ("EAR/BAR Core"),Between 0 And 10,0) I have added the above statement to a query field critieria. I get no records returned. If I simply put ...
September 9th, 2005 12:41 AM
by Ofer Go to last post
4 118
Finding Unmatched records from two tables by Tia
I have two tables where all records should match. One table, however, has more records than the other and I haven't been able to determine why. Unfortunately,...
September 9th, 2005 12:41 AM
by John Spencer (MVP) Go to last post
4 123
Union query by tope12
I made a form with a button that generates a report based on the info that the user puts in the form. The record source of the report is a query that composed...
September 9th, 2005 12:42 AM
by John Vinson Go to last post
7 155
Query to extract data in a specified format by sattaluri
I am new to SQL and need help in extracting some data from a table. My table has the following data...
September 9th, 2005 01:12 AM
by KARL DEWEY Go to last post
1 83
HOWTO: Use conditions in FROM clause in Access sintax. by NKN
Hello all, I am triying to use condition wtih some fields in the FROM clause of an Access query. But I get an error saying that "the conbination expresion...
September 9th, 2005 01:27 AM
by John Spencer (MVP) Go to last post
5 117
sorting columns in crosstab by monia13
I have months (MMM-YYYY) in the columns in the crosstab query. I need to sort them according to time and not alpahnumeric. With MMM-YYYY formt they are...
September 9th, 2005 02:14 AM
by Duane Hookom Go to last post
6 231
full name vs first and last name by Jay
I have two tables. One has "customer full name" in one field. The other is from another database and has two fields, : "first name" and "last name". I want to...
September 9th, 2005 03:56 AM
by TerryC Go to last post
2 89
Query from Multiple tables by Ed
I have multiple tables that have the same fields. For instance, I have five tables that have the following fields: firstName, LastName, TelephoneNumber. I...
September 9th, 2005 04:05 AM
by Duane Hookom Go to last post
5 191
Query size of memo field by Janna
Is there a way to query a memo field to find out which record in the database contains the most text in the memo field? TIA
September 9th, 2005 04:06 AM
by TerryC Go to last post
1 124
Error when running Query, but not Report by Blaze
I have a Report that runs fine, but the query will not "run" by itself. Any ideas out there. Thanks, Blaze
(Multi-page thread 1 2 3)
September 9th, 2005 05:40 AM
by Ken Snell [MVP] Go to last post
29 1,520
full name from first and last name, again by Jay
I have two tables. One has "customer full name" in one field. The other is from another database and has two fields, : "first name" and "last name". I want to...
September 9th, 2005 06:23 AM
by TerryC Go to last post
1 97
Post New Thread


Display Options
Showing threads 9881 to 9900 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 10:53 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.