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
IsLoaded by Maureen
I have copied the IsLoaded module from the Northwind DB into my own DB. I have successfully used this code in a macro condition. Can I use the IsLoaded...
May 29th, 2004 04:28 AM
by Van T. Dinh Go to last post
1 324
Query design - select fields always default to "group by" by Tripp Knightly
When designing queries (happen to be on ODBC tables) I'll select fields and then by default "Group By" is selected under the total / aggregation row. Is there...
May 29th, 2004 11:56 AM
by Gary Walter Go to last post
2 720
Can Access make a transaction query? by Christina
Hi There, I am wondering if Access can do a transaction query like SQL server. For example, I'd like to insert records to serveral tables, if one insertion is...
May 29th, 2004 12:44 PM
by Gary Walter Go to last post
2 332
creating relations with sql by Jonas
Hi how can I create relations between tables with sql ? Regards Jonas
May 29th, 2004 01:48 PM
by Jonas Go to last post
2 427
rounding making result of calculations look incorrect by Helen
Hi all, I've got a bound form on which some text boxes are populated by a query. Other textboxes contain calculations. The results from the calculations are...
May 29th, 2004 02:29 PM
by Wayne Morgan Go to last post
6 708
Expression (Checkbook) by Tom
Just like in a checkbook, I want to create a query that contains 1 field plus 1 expression: - Expenses (field) - Remaining Balance (expression) Naturally, I...
May 29th, 2004 02:38 PM
by Tom Go to last post
0 443
sql view by charles osborne
Does anyone know why the SQL view may not be available to use for a table of form? I have read that you can get the SQL view by clicking on the view button...
May 29th, 2004 04:16 PM
by Joan Wild Go to last post
4 866
Undefined function 'Date' in expression by Doug
I get the above error message when I use Date() in a query criteria to retrieve records. This used to work in access 97. I am very dependant on being able to...
May 29th, 2004 04:20 PM
by Douglas J. Steele Go to last post
2 628
Current Date, MTD, YTD, Last Year's MTD by Gina
Say I have a date (05/29/04). Using this date: How do I get the MTD date range (which should be 05/01/04 - 05/29/04)? How do I get the YTD date range (which...
May 29th, 2004 11:05 PM
by Duane Hookom Go to last post
3 620
how do you work with time? by Annelie
I am trying to create input for a time card Start: 07:44 (shorttime format) End: 17:13 (shorttime format) HoursWorked: 09:29 (shorttime format)-...
May 29th, 2004 11:56 PM
by Duane Hookom Go to last post
1 360
Using a query with a replaceable parameter as the source of a control by Hoo
I'm stuck, trying to base the contents of a listbox upon a query with a variable parameter. The trouble lies in the fact that if I set the listbox control to...
May 30th, 2004 07:07 AM
by tina Go to last post
1 969
HELP! by Hannah Jackson
Hi! I don't know how this works but I have a problem so I'm just gonna post it up here. When I'm connected to the internet and I open explorer after about 5...
May 30th, 2004 05:12 PM
by Michael Hopwood Go to last post
1 403
Autolookup Query by Ernie
I have an autolookup query that automatically fills in employee name and rate on a form. What I would like is to be able to update the rate, for each record,...
May 30th, 2004 05:25 PM
by Jeff Boyce Go to last post
6 596
Substracting two adjacent rows by Yakimo
Hi! I have a very large table, containing some DateTime data. Is it possible to run a query that will return a resultset, containing the difference between my...
May 30th, 2004 06:01 PM
by Yakimo Go to last post
2 290
criteria in query part of field text only by MemphiDoug
In my email field, I want to query only the aol.com users. I have tried ="**", I have tried LIKE "**", I have tried just "aol.com" I can't figure out how to...
May 30th, 2004 06:02 PM
by Douglas J. Steele Go to last post
1 642
Quering 2 IDs from a single table by Paul
Hi, I need to query 2 salesman_ID from a table but I cannot figure out how. SELECT salesman_ID, FROM product
May 30th, 2004 06:23 PM
by Paul Go to last post
2 345
"append query" issues by BJMLaJolla
I have the same problem. I have 70 tables that I want into one table. All tables have the same structure with different content. I tried an Append Query but...
May 30th, 2004 08:45 PM
by John Spencer (MVP) Go to last post
1 325
criteria in query part of field text only by MemphiDoug
In my email field, I want to query only the aol.com users. I have tried ="**", I have tried LIKE "**", I have tried just "aol.com" I can't figure out how to...
May 30th, 2004 09:11 PM
by pdm Go to last post
1 558
Expr: Left([dob],4) = omitted an operator? by Jan
Getting error saying "omitted an operator" when trying a simple function. All I'm trying to do is get a list of the first 4 characters of a text field of 6...
May 30th, 2004 09:17 PM
by John Vinson Go to last post
2 378
current date less 28 days by marion
I support online learners and in this particular query I am using two tables one for the student information and one containing all the contact I have had with...
May 31st, 2004 03:19 AM
by Van T. Dinh Go to last post
5 302
Post New Thread


Display Options
Showing threads 141 to 160 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 02:19 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.