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
Range Problem by pas926
I have a field that contains sequential numbers. The user want to run various reports on different ranges, more specifically like this "3280 And 3314"...
June 2nd, 2004 04:25 AM
by Mr Sir Go to last post
2 238
HELP!!!!! Subreports by Chris
I need to display on the same A4 paper sheet more pages of the same report, and, after the A4 paper sheet is over to continue on the next A4 paper. Can I...
June 2nd, 2004 04:27 AM
by Duane Hookom Go to last post
1 235
HELP!!!! Subreports by Chris
I need to display on the same A4 page more pages of the same report, and, after the A4 paper sheet is over to continue on the next A4 paper. Can I insert it...
June 2nd, 2004 04:44 AM
by Larry Linson Go to last post
4 321
Latest Dates by Bill
Hi, I would need your help to set the query for searching the latest date of any five dates. example: Field1 Field2 ***** ****** Date1 -...
June 2nd, 2004 09:07 AM
by Billy Yao [MSFT] Go to last post
2 265
DoCmd.OutputTo into multiple worksheets in excel by marcus.
Hi, I have a number of queries from which I want to export to excel. I can export a query to an invidual workbook. But how do I export another query to form...
June 2nd, 2004 10:14 AM
by Nikos Yannacopoulos Go to last post
1 1,122
Query for blank fields by Thorpe
I have table that has a field that can be empty or contain a string. I need a query pull out on entries that have empty fields how can I do this thanks
June 2nd, 2004 12:31 PM
by John Spencer (MVP) Go to last post
2 583
Exporting query to Excel showing related months grouped by Terri
I have this query I'd lide to export to Excel and group related monthly data allowing a space between the grouped monthly data. Is this possible? The data...
June 2nd, 2004 02:43 PM
by Gary Walter Go to last post
4 396
query result inquiry by David Bartosik MS MVP
If you run this and the Birthdate is 9/1 I come up with -1 for the result. Wondering why this would not be zero or...
June 2nd, 2004 03:14 PM
by John Spencer (MVP) Go to last post
1 368
Odd error message by Marc
Hello, I have a make table query that is the last in a string of several queries, which it uses to create the table. When trying to run it a second time I get...
June 2nd, 2004 03:17 PM
by Marc Go to last post
4 279
Using a module in a query by Fatz
I am trying to call the following module (which I borrowed from "The Access Web") to calculate the number of business days. Here is the module: Function...
June 2nd, 2004 03:17 PM
by Ted Allen Go to last post
4 677
Currency without decial by Pat Diminico
I need a function to remove the decimal point not the decial place. I need to provide a data file with dollars and cents without the decimal. Thank you
June 2nd, 2004 03:48 PM
by Allen Browne Go to last post
1 325
Data length by Nick Read
Hello All I trying to create a query in Access that will only select data from a table when it exceeds a certain length i.e. Col A | Col B Row 1 A ...
June 2nd, 2004 03:53 PM
by Ted Allen Go to last post
3 322
REALTIME UPDATES by BobHt
I have a MAKE TABLE query that updates the information from one database to another. Now I would like to have this table updated automatically. I have linked...
June 2nd, 2004 04:03 PM
by Go to last post
2 292
Parameter Query Help by mark
hello all i am attempting to create a parameter query, which is where you would put in the "criteria" section in order to have access prompt you with a text...
June 2nd, 2004 04:40 PM
by Newbie Go to last post
4 888
surely a form with a ListBox can be used in a query? by 1.156
Fred and Tina were kind enough to try to help in an earlier thread but I'm still getting nowhere. I have a simple query that works fine but the user must type...
(Multi-page thread 1 2)
June 2nd, 2004 04:54 PM
by tina Go to last post
14 1,719
Struggling with append query by KJ
I was trying to execute an append query that gets input parameters from a form using a macro but I think what Help just told me is that I need to use the DoCmd...
June 2nd, 2004 05:15 PM
by John Spencer (MVP) Go to last post
2 1,016
Query in a query by PPerry
I have a query (thanks to this group) which returns the very last date in a sequence. This query works great. I now want to use it in another query where I...
June 2nd, 2004 05:53 PM
by Michel Walsh Go to last post
1 1,239
Masking Inputs to Query Criteria Prompts.. by TexasTOny
I have a query with as the criteria for a field I use to request a password from a database user. The poroperties for the reaponse field suggest that the...
June 2nd, 2004 06:13 PM
by Go to last post
2 280
Help! Write Selection Criteria by news.insightbb.com
I have a request to create a Query and not sure how to go about this. This query will look at purchase history of part numbers by a distributor over the...
June 2nd, 2004 06:59 PM
by MikeB Go to last post
2 235
Help with simple query by Aaron Weintraub
Hi, I have a products table linked to a shipments table which tracks the dates of the shipments of each product. The tables are linked by ProductID. How can...
June 2nd, 2004 07:25 PM
by Aaron Weintraub Go to last post
5 523
Post New Thread


Display Options
Showing threads 201 to 220 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:20 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.