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
New Totals Query by Jay
This is from famous "Northwind" DB example. Suppose you have an Orders table that has both a Freight field and a ShipCity field. You can create a query that...
September 19th, 2005 04:06 AM
by Duane Hookom Go to last post
3 116
Query with minimum field value by Jay
I have an Orders table that has a Freight field, a ShipCity field, OrderId field, and CustomerID. I want to create a query that displays Order ID...
September 19th, 2005 04:23 AM
by Duane Hookom Go to last post
1 94
How do I combine data from two fields into one using a query? by thjofe
I am working on a project and there is an existng table which includes a FirstName and a LastName field. I am trying to design a query to include the data from...
September 19th, 2005 05:07 AM
by thjofe Go to last post
6 142
Sync Columns by DavidMCarr
I am trying to get the column order in the Design View of a query to match the order in the Datasheet View. I know how to move columns in each view but if you...
September 19th, 2005 05:41 AM
by '69 Camaro Go to last post
1 90
duplicate query within an If statement by Alan
Hello All I have a data base which I have inherited and Im trying to sort ... In my data base I have an employee number which is unique to the...
September 19th, 2005 08:38 AM
by [email protected] Go to last post
1 87
concatenate equivilent by tina
Hi How do I write expression eg 1 of 3 where 1 is field and 3 is field in excel I would use concatenate but I don't know how to do in access TIA Tina
September 19th, 2005 11:35 AM
by Dennis Go to last post
1 89
Please Help!!!? Select * From by A. Smart
I have been given a solution to an earlier post that I understand but can't get to work. Is the Select * From function used in Query Criteria box or elsewhere?...
September 19th, 2005 01:03 PM
by Jeff Boyce Go to last post
1 115
attetching a Macro to a action Queries by Twb
How can I attach a macro to a action querie so i can create a button that will run the action querie?
September 19th, 2005 01:28 PM
by Allen Browne Go to last post
1 124
Crosstab query - odd field by SusanV
Hi all, I have 2 stored Crosstab queries which are basically the same in structure but which pull data from different sources: qryXtab_tblTemp: TRANSFORM...
September 19th, 2005 02:27 PM
by SusanV Go to last post
2 80
User Selected Fields from Form by Validlyte
Hello~ I am trying to create a form that would allow the user to select the fields they would like in a query and then to execute the query. The number...
September 19th, 2005 02:59 PM
by Validlyte Go to last post
2 70
Having trouble joining a table and query by Mel
I am trying to join a table and a query. The qryJulysales gives manager, acct, itemrange, sales, disconinv. The table has acct, item range, discoffinv. This...
September 19th, 2005 03:47 PM
by Mel Go to last post
4 91
Group (Query) By Date by SKB
I have data stored with Date and TIME, but want to group by Calendar Date. Which fuction do I use in the calculated field? (since the query wants to group by...
September 19th, 2005 04:42 PM
by SKB Go to last post
1 67
More Help withthe WHERE Clause by tamxwell
This is a complex query that shows debt agings for all our customers from CURRENT, 1-30, 31-60, 61-90, 91-181, 181-360, 360+ days. I have 2 tables joined,...
September 19th, 2005 05:23 PM
by tamxwell Go to last post
2 87
Please Help!? Multiple Check Boxes in Query! by A. Smart
In my query there are a number of Check Box Fields. I would like to be able to filter out all the other check boxes when a check box is selected from a combo...
September 19th, 2005 05:45 PM
by John Vinson Go to last post
3 247
Doesn't work Like "*" [Forms]![SearchCriteria]![StrAddress] "*" by Bill Wilson
I'm using a Form to have the user enter/select search criteria, eg a property's address, then use the query criteria expression: Like "*" !! "*" , but the...
September 19th, 2005 05:51 PM
by John Vinson Go to last post
3 98
Excluding row based on trailing text by Kevin G
I know it's going to be a real simple answer but I'm trying to exclude records based on the last three characters of an 11 character text string. I want to...
September 19th, 2005 07:42 PM
by Kevin G Go to last post
3 144
Select Data by Stefan
Is there a way to use the LEFT() function to take all the characters until a space is encountered? I am trying to normalize data I imported from another...
September 19th, 2005 08:26 PM
by John Spencer (MVP) Go to last post
2 106
Simple Query or not? by Barry
ID SDate TenantID State Parm Notes 1322 19/09/2005 13:52:29 MRC Raise T1 0 Man: £2200,L141 1323 19/09/2005 13:52:36 MRC T1 Sent 0 Man: £2200,L141 1324...
September 19th, 2005 08:31 PM
by Barry Go to last post
5 110
Problem using form as criteria in query by franky
I have a form with an input box that has a default value set. I then have a query that is using this value as criteria (Forms!frmTest!txtValue). When the...
September 19th, 2005 08:33 PM
by Ofer Go to last post
1 77
Date Summary Report by Rod
Hello, I have a tblCandidates. Calls are made to candidates. The date the call is made is stored. The result of the call is stored, i.e. "message" left. ...
September 19th, 2005 08:42 PM
by Rod Go to last post
4 74
Post New Thread


Display Options
Showing threads 10141 to 10160 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:23 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.