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
Retrieve all record if check box = 0 (Not checked) by Silvio
Hello, I would like to see ALL (0 and -1) records if my check box in my form is not checked (0) and if checked (-1) I would like to see only record with -1...
May 28th, 2010 04:24 PM
by John Spencer Go to last post
5 950
How to find text that is surrounded by a wild card, specificly an by Dan
I am looking for a way to query for the following: *T* The problem is the T is surrounded by an * which is a wild card. It pulls all the records with a T...
May 28th, 2010 04:14 PM
by Dan Go to last post
4 952
Blank Fields in NOT Null Query Criteria by Steve Stad
Why would a few blank fields show up in a query where I am using 'Is Not Null' in the criteria. The rest of the Nulls are filtered out - but there are 7...
May 28th, 2010 03:19 PM
by KARL DEWEY Go to last post
5 1,025
Next to Last Date by slotmgr70
I have a table that tracks each customers visit to my store. I hold promotions on occaision that bring customers that haven't visited my store in awhile....
May 28th, 2010 02:58 PM
by Wolfgang Kais[_4_] Go to last post
2 1,066
Help on muliple table queries by Natalie
Hi all, I wonder if you can help. I have 5 tables of data with the same column names. I want to run a query which includes all records from all tables within a...
May 28th, 2010 02:31 PM
by Wolfgang Kais[_4_] Go to last post
1 871
Joins on NULL Date values by Andy
I have some queries whereby I need to join two tables based on two date fields that are in both queries. Sometimes date 1 or date 2 will have NULL values,...
May 28th, 2010 12:01 PM
by Andy Go to last post
3 1,088
Currency Format Lost in Union Query by Jill
Thanks to John Spencer, I resolved one problem in my union query (Thank you, John). But I have another problem. Some of my fields in my union query are...
May 28th, 2010 03:42 AM
by Allen Browne Go to last post
1 1,095
Update Query with Parameter by sg
I have an Update Query that asks for 3 fields with parameters. The first parameter is the criteria in the query to identify which record we are updating. ...
May 28th, 2010 03:40 AM
by John W. Vinson Go to last post
3 949
How to use txtboxes and Combo boxes in a form by sebastico
Hello Foro Access 3003. In a form I'm trying to design a search where user only enter data in three textboxes. In a query I have the following parameter...
May 28th, 2010 01:02 AM
by sebastico Go to last post
2 813
two level make table query and sorting??? by tcek
I am creating a table with a "make table" query. I want to query by customer number than by date of order. I want the customer number to be ascending while...
May 28th, 2010 12:36 AM
by KARL DEWEY Go to last post
2 883
adding new columns by joemeshuggah
what is the best way to go about doing this? i just created a report that first runs a query for current month info in teradata sql assistant and exports to...
May 27th, 2010 11:01 PM
by joemeshuggah Go to last post
0 811
Access 2003 by S.E.
I get a "type mismatch in expression" when saving a query. Why do I get this and how do I correct this? My suspicion is my customerID and barcode fields are...
May 27th, 2010 11:01 PM
by S.E.[_2_] Go to last post
7 815
Update Query not updating selected table by MKuria
I have created an update query to update a master file. When I run the select query to view the records I need to update - I see the correct data. When I...
May 27th, 2010 10:58 PM
by Daryl S[_2_] Go to last post
1 942
IF ISNUMBER FIND in query design expression by gator
I use the following formula in Excel and it works...I now want to do this in a query. Can I add it as an expression in the design grid in a seperate column...
May 27th, 2010 10:56 PM
by KARL DEWEY Go to last post
1 723
Parameter Error for Year 2010 by AccessKay
Not sure if anyone knows the answer to this but I welcome any suggestions for things to try. I have a crosstab query layered off of a Union query. I also...
May 27th, 2010 10:53 PM
by AccessKay Go to last post
7 857
aggregate calculation works in select query but not an update quer by bicyclops
The below query works well as a Select Query. But when I turn it into an update query, I get a whole lot of nothing in the results. Interestingly, if I try...
May 27th, 2010 10:44 PM
by bicyclops Go to last post
4 886
min query by Siew-Ming
Hi, How do I get the 2nd minimum value and the 3rd minimum from a table after I have done MIN query for the 1st minimum value? SELECT dbo_CON.SC,...
May 27th, 2010 10:42 PM
by Jerry Whittle Go to last post
2 728
version by arlene ramirez[_2_]
Does your query have a start time and end time. If so, you can't run the query to see your time on Paper with Paper still open as you will not have an end...
May 27th, 2010 10:19 PM
by arlene ramirez[_2_] Go to last post
0 683
Change colour of a field by Daryl S[_2_]
DontKnow - You can use Conditional Formatting on the field. You are limited in the number of options you have, but it can do what you want. -- Daryl...
May 27th, 2010 10:08 PM
by Daryl S[_2_] Go to last post
0 695
append crosstabs by dtoney
can you append the results of several crosstab queries into 1 table? I'm calc different categories & customers and need to capture "hours" for each area for...
May 27th, 2010 10:05 PM
by dtoney Go to last post
2 732
Post New Thread


Display Options
Showing threads 81 to 100 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:43 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.