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
IIF Statement by Sean
Can some one look at this and let me know why it isnot working?? The filed, (., is a field in the query that is prompted. Based on this value, I wanted the...
February 14th, 2007 10:20 PM
by Duane Hookom Go to last post
8 185
Simple Calculation Question by johnny
I've done this before, but can't recall how, it's been awhile. I have multiple duplicate lines containing same customer name in one column and in the other...
February 14th, 2007 09:29 PM
by Marshall Barton Go to last post
2 153
Duplicates in Union Query by Anon
I have a quick question. . . If I have duplicates in Table A and I run a union query between tables A and B, will it eliminate the duplicates in Table A, or...
February 14th, 2007 09:27 PM
by Marshall Barton Go to last post
2 133
crosstab query by prairie smoke
I have a crosstab query that is returning correct data. One field is a date that returns months, i.e. Jan, Feb, through Dec.. Is there any way to have the...
February 14th, 2007 09:12 PM
by prairie smoke Go to last post
1 134
How do I query for past date and totals? by DJTI via AccessMonster.com
Thanks in advance for any help or guidance. I am trying to query for a report and am not sure how to go about getting the last quarters totals. Some accounts...
February 14th, 2007 09:05 PM
by DJTI via AccessMonster.com Go to last post
9 336
Creating a query that tracks changes by owliyz28
i need help creating a query that will track where and when something has changed from year to year. i have 2 databases with lists of names and categories. i...
February 14th, 2007 08:29 PM
by John Spencer Go to last post
3 155
Case statement issue by ZIMMJE
The value from the first statement is the value that is always returned even if = 31 to 60 or 61 to 90 I still get the value from the first statement...
February 14th, 2007 08:22 PM
by John Spencer Go to last post
2 222
comparing two tables by imranmp
Hi, I want to compare records from two tables: TempTable - has all the records that i have imported, i want to check if there are any new records that do not...
(Multi-page thread 1 2)
February 14th, 2007 07:30 PM
by John Spencer Go to last post
10 482
select distinct by sierralightfoot
I want to add: SELECT DISTINCT .email1 FROM ; to the following query in an accrees database but I just can't seem to get the syntax right SELECT...
February 14th, 2007 07:25 PM
by John Spencer Go to last post
5 153
Appending Overwriting, instead of appending by Anne
I can't figure this one out - an append query is overwriting the first record in the table, instead of appending it to the end. Please help - thank.
February 14th, 2007 07:05 PM
by Jerry Whittle Go to last post
2 214
How do I get the numeric data from a look-up to show as text? by mh7800
In my query, I have a field (Vendor) that pulls data from a look-up table. When I run the query, I only get the vendor # and not the vendor name. How do I...
February 14th, 2007 07:01 PM
by Jason Lepack Go to last post
3 194
Import data by Renetta
I have a weekly excel spreadsheet that I need to import. One of the columns reflect SSN's, however those SSN's reflecting a leading zero(s) drop off during...
February 14th, 2007 06:51 PM
by Jerry Whittle Go to last post
1 134
Date expressions that can exclude weekends by michelle
When using the expressions Date()-1 and - is there anyway I could get them to not count weekends? Date()-1 works well until I need it to show Fridays totals on...
February 14th, 2007 05:29 PM
by Jamie Collins Go to last post
1 182
Query to extract data help please by Terry DeJournett
I have one field in a table that contains 5 different values, each seperated by a ",". (Example: Value1,Val2,V3,Value4,Valu5). Each value may be of different...
February 14th, 2007 04:57 PM
by Jerry Whittle Go to last post
1 148
‘dashboard’ Form/Query to provide different data from the same fie by efandango
(I was really not sure how to title this question, but here is the problem) I want to create an all-purpose form that will give me the information in the...
February 14th, 2007 04:28 PM
by efandango Go to last post
0 138
Something like a three-tiered JavaScript menu... by cprav
I have a database in which someone has entered various organizations. Included in the fields a County Town Organization Name I want to create a...
February 14th, 2007 03:05 PM
by John Spencer Go to last post
1 141
Multiple option query to calculate a value by CP
I can do forms and designs but I am completely lost when it comes to calculations. I can work how to place them and understand that result one can be used...
February 14th, 2007 03:02 PM
by John Spencer Go to last post
2 206
Error Message 3075 by Len
I have been running this standard query for two years. All of a sudden I get this error message. Run Time Error 3075 I am searching for the first character...
February 14th, 2007 02:46 PM
by John Spencer Go to last post
3 176
Consolidate rows by BruceM
This is the SQL for a select (Totals) query that shows me the number of parts per category that have been processed according to a particular Technical...
February 14th, 2007 01:22 PM
by BruceM Go to last post
3 149
Update query using a sub select by Admingod
Hi Guys, I have having trouble updating a table with the result of a query to sum a value. The sql is: UPDATE Invoices SET Invoices.SubTotalFees = (SELECT...
February 14th, 2007 09:21 AM
by Jamie Collins Go to last post
4 272
Post New Thread


Display Options
Showing threads 20141 to 20160 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 12:04 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.