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
Help exporting URL format to Excel from Access Query by Dave
I have an Access query that is generating URLs for reports. I need to export it in Excel. When I do, it places an apostrophe ' in front of the text in...
June 20th, 2008 02:50 AM
by [email protected] Go to last post
1 139
Temp Variable for Criteria in Query Design by Chris F via AccessMonster.com
Is there a way to reference a set Temp. Variable in Access 07's query design under criteria. In VBA, I can call a temp variable and use it in a query built at...
June 20th, 2008 01:35 AM
by [email protected] Go to last post
1 1,027
Column headings in a crosstab query by Kath
Hi, I had tried to do the following in order to rename the column headings in a crosstab query: 1. Go into the DESIGN view of the crosstab query 2. Right...
June 19th, 2008 11:16 PM
by Duane Hookom Go to last post
1 121
Showing records with one or more null fields by FrustratedAssnt
We have a really simple database, which is nice. But someone went in and erased some of the data in some of the fields. There are a lot of records in there,...
June 19th, 2008 10:42 PM
by John Spencer Go to last post
1 120
Summary query sum from different tables by BAC
VISTA Enterprise/Office 2007 Plus situation: Two identically structured tables, and tables consist of contracts and assets with costs. there is a field...
(Multi-page thread 1 2)
June 19th, 2008 09:46 PM
by BAC Go to last post
15 275
All records in a List_Table as the criteria for query of a Main_Ta by PXK
I am getting exact matches to the List_Table using the IN statement, but... Consider a customer is inputting a "where did you hear about us" answer in to a...
June 19th, 2008 09:31 PM
by PXK Go to last post
3 128
Parse Address Field by Lisa W.
I am trying to create an Address Line 2 field; I need to parse the data after the comma in example #1 and if there is an address with no comma, I would like...
June 19th, 2008 09:24 PM
by Dale_Fye via AccessMonster.com Go to last post
2 117
Sorry! Parameter query / Again by D
Hi everyone/ Doug: So. in the below qry; I would like to do all the comparisons based on year and month: yyyymm; I need to enter when propted, yyyymm; how do...
(Multi-page thread 1 2)
June 19th, 2008 08:38 PM
by John W. Vinson Go to last post
16 180
return only last records query by Anne
Hello! I have a table that has county information by year. I would like to write a query that returns only the latest year for each county. I have used the...
June 19th, 2008 07:58 PM
by Klatuu Go to last post
3 110
plus sign applied as & by [email protected]
Access 2003 (probably other versions too) - Bless their hearts, Microsoft assumes that when you use a plus sign between two text fields in a query, that you...
June 19th, 2008 07:44 PM
by [email protected] Go to last post
4 98
Storing OLAP info locally. by -Nate
Hello, I have question about OLAP queries. I have to update about 10 pivot tables in 10 separate .xls files daily. All 10 link to the same OLAP cube...
June 19th, 2008 07:25 PM
by -Nate Go to last post
0 121
Subquery implementing MODE computation. by JMSatMetro
I have a query... SELECT tblOriginTAZ.fkFranchiseID, qryArcUniverseMin.TAZd, tblFacilities.Facility FROM (qryArcUniverseMin INNER JOIN tblOriginTAZ ON...
June 19th, 2008 07:23 PM
by JMSatMetro Go to last post
0 108
Modified Access query does not respect ORDER! by Rick Brandt
wrote: Creating a report with the wizard uses the "invisible" order by lname. While the Sorting and Grouping dialog is empty, the...
June 19th, 2008 07:13 PM
by Rick Brandt Go to last post
0 101
Number of Tables in a Access Database File by Akash[_2_]
Hi I want to know if a random access(.mdb) file is given to my code how can i find how many tables are there present in the file?? is there any query or...
June 19th, 2008 07:09 PM
by Marshall Barton Go to last post
1 114
hotmail text box is very small by Anna Wheatley
about four month ago, something went wrong with my hotmail text box. It is very small, about 2 " then as I am writing a letter, all lines disapear behind the...
June 19th, 2008 06:04 PM
by Anna Wheatley Go to last post
0 136
Query results with #Error by cjborntorun
I'm using the following formula in a field of my query: May % Billed to Fcst: ()/() How can I modify this so that I don't get "#Error" for products that had...
June 19th, 2008 06:03 PM
by cjborntorun Go to last post
2 99
Running Append Query from Combo by Scott A
I'm trying to get a combo box to execute an append query to add records to my database. My problem is not all of the relevant information is displayed on the...
June 19th, 2008 05:33 PM
by Scott A Go to last post
0 90
delayed keystrokes with multiple users by EdiebAZ
Office 2007 Access: five users prefer to work directly from the queries that are create from a form used for accounting reconciliation. Once in the query...
June 19th, 2008 05:28 PM
by EdiebAZ Go to last post
0 116
Count Yes/No with Criteria by Lynn
I have created a summary query using the Totals button. My Group By field is Employee ID & my Count field is Attended. Attended is a Yes/No data type. When...
June 19th, 2008 04:56 PM
by Lynn Go to last post
2 112
Include empty values in crosstab query by Alex
I have a table, biweektbl, that lists all the possible Bi-Weekly shifts. Is there a way to revise the following crosstab query to include all Bi-Weekly...
June 19th, 2008 04:30 PM
by S.Clark[_2_] Go to last post
5 157
Post New Thread


Display Options
Showing threads 10301 to 10320 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 11:22 AM.


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