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
Parameter by Peter
HI all again..i stumbeled over something most probably very simple..but I use this in a query Field / Days:(-) Criteria / = I do not receive the result i...
June 26th, 2009 08:18 AM
by Peter Go to last post
3 117
VS2008 : Error Using IIF in Select Query by Screaming Eagles 101
Hi, Using Visual Studio 2008: I have a tableadapter in my dataset connecting to a table in Microsoft Access Database, which forces me to use the IIF...
June 26th, 2009 07:04 AM
by Michel Posseth [MCP][_2_] Go to last post
4 134
Removing excess spaces in data by paulhk88
I import data from spreadsheets into Access. Sometimes I get data that contain excess spaces within a field such as description. For example: " AAA BBB ...
June 26th, 2009 04:31 AM
by Tom van Stiphout[_2_] Go to last post
6 215
Run query in another database by RoBo
Could anyone help me with the following problem: I created a form in a database. This form is used to specify criteria for a number of queries. The queries...
June 26th, 2009 04:11 AM
by MGFoster Go to last post
5 156
Unmatched query help by PieterLinden via AccessMonster.com
Opal wrote: Running Access 2003, I have the following query as a basis for a chart I run on a report: SELECT Count(Review.RevID) AS CountOfRevID,...
June 26th, 2009 12:50 AM
by PieterLinden via AccessMonster.com Go to last post
0 102
Adding to combo box by Leo
I have a combo box and the list of choices are drawn from a table. But the choices are not limited to the table (Limit to the the list is No on combo...
June 26th, 2009 12:12 AM
by Leo Go to last post
5 146
Crosstab Query based on Query by Renee
I created a query where it would prompt and ask for records between two specific dates (i.e., Between And . Then I created a crosstab query based on that...
June 25th, 2009 11:25 PM
by John Spencer Go to last post
5 146
Total numbers by month by Total fields by month
I have a database that holds a intial contact date as well as several check boxes confirming reciept of information. I would like to have a query/report...
June 25th, 2009 10:26 PM
by Jeff Boyce Go to last post
2 105
querying based on a form by joemeshuggah
i have a form that displays rep name (RepNm combo box), but also has an ad id (hidden). i want to have a cascading combo box automatically populate ad name...
June 25th, 2009 10:05 PM
by KARL DEWEY Go to last post
7 110
Union query - sort of by Stephanie
Hi. I am trying to combine two queries, I think. What I would like to see is the # of incidents in the current timeframe against the # of incidents in the...
June 25th, 2009 08:56 PM
by Stephanie Go to last post
4 106
Calculating and Updating Number of Days Between Fulltime Employmen by Jeff H
I have table of client activities that contains employment data (fulltime and part-time). I need to be able to calculate the number of days between a...
June 25th, 2009 08:48 PM
by Jeff H Go to last post
6 142
Simple query of Sharepoint List locks up computer by Dale Fye
I'm using some Sharepoint Lists as tables for an Access application (mdb file in 2007 for compatibility across all users). The query looks like: SELECT...
June 25th, 2009 08:13 PM
by Jay Ward Go to last post
1 99
Auto Notification by David McLean
Hi Everyone, I'm trying to figure out a way to have a form pop up in my database automatically on the first day of each month that would show a query. would...
June 25th, 2009 06:05 PM
by David McLean Go to last post
5 136
How to do a rolling average on a query that asks for input by AJ
I am probably not going about this the easy way, and I'm sure my database looks nightmarish to most, but i am having problems calculating a rolling average. ...
June 25th, 2009 05:12 PM
by AJ Go to last post
8 168
Search for number in memo field by 2Blessed4Stress
I have a qry that uses a form as it's criteria. The user will enter a number (ex. 945) and the qry should search in a memo field for 945 exactly. Their may...
June 25th, 2009 04:54 PM
by 2Blessed4Stress Go to last post
8 174
Count and assign by Dana
I have a query that selects records based on whether a field is blank, Query1. From this query I developed a make table query where another cell is blank,...
June 25th, 2009 03:11 PM
by Dana Go to last post
2 117
Query question by Jeff Cichocki
I am a newbie to Access so please forgive me if I don't use the correct terminology or if I'm missing something that would better help you to help me. I am...
June 25th, 2009 02:31 PM
by Douglas J. Steele[_3_] Go to last post
8 150
Dragging Joins in Access 2007 QBE Grid by tjarus
We recently switched to 2007 and have had a great deal of difficulty dragging table joins in the grid. The table scrolls up and down and you can't complete...
June 25th, 2009 02:12 PM
by Dale_Fye via AccessMonster.com Go to last post
1 214
select latest records by John_Bavin
How do I select the current or latest record in a table. For instance a price list where we have new prices for the same product code with an effective...
June 25th, 2009 01:17 PM
by vanderghast Go to last post
1 104
projecting due dates by Judy
My database has an Annual Review Due field with quarters (1st, 2nd, etc.). I need to produce a weekly report showing a 60-day projections of items that are...
June 25th, 2009 01:11 PM
by Klatuu Go to last post
3 117
Post New Thread


Display Options
Showing threads 4201 to 4220 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 06:36 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.