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
Can't enter data in query datasheet by Bill Craig[_2_]
I have a query (involving multiple tables) that I want to execute and then use to enter/change data via the datasheet which results from the query. On most...
April 22nd, 2010 07:08 PM
by Jerry Whittle Go to last post
1 194
Displaying data across columns by JD
I need a arrange the data from a table across columns similar to a crosstab query, but the crosstab didn't work for me. Do anyone have any suggestions? Here...
April 22nd, 2010 06:20 PM
by John Spencer Go to last post
1 213
Selecting records by rowID by Kirk P.
I've got a table of 11,000 records. Don't ask why, it's a long story, but I need 11 queries like this: Query 1: records 1 - 1000 Query 2: records 1001 -...
April 22nd, 2010 05:55 PM
by Clifford Bass via AccessMonster.com Go to last post
4 270
list box row source by deb
Access 2003 On my form called f018ContrPerfEmissGua (PK GuaID SK ProjectID) I have a list box called UnitType. I need help with the row source If UnitNo=0,...
April 22nd, 2010 04:56 PM
by golfinray Go to last post
1 153
Multiple Query questions by Jackie
I'm trying to query a database of beach rentals and need a query with more than 2 bedrooms, that rents for less than 1,000. When i put both criteria in, it...
April 22nd, 2010 04:46 PM
by John W. Vinson Go to last post
2 185
days between tweak by Bibi
I do not know how to tweak the code below to calculate the number of days available from the current day in those cases where the first day available is...
April 22nd, 2010 02:31 PM
by John Spencer Go to last post
5 138
Compare dates in two seperate records by sdg8481
Hi, I have a table that has multiple rows for person, each with a different admission date. What need to do is to build some a query that will identify the...
April 22nd, 2010 02:16 PM
by John Spencer Go to last post
8 307
Extracting the numbers from the Text Field by Irshad Alam
I have a table in which in a text field is having Equipments models and data entry is been not properly entered, the data is as below...
(Multi-page thread 1 2)
April 22nd, 2010 02:13 PM
by John Spencer Go to last post
10 685
combine multiple recs into one with repeating fields by K Essmiller[_2_]
I have a file with beneficiary names for life insurance. The input file has multiple names for the member. The file format I need to load into our system has...
April 22nd, 2010 06:21 AM
by John W. Vinson Go to last post
2 239
Date Brackets as an IIf statement by Gary
Looking for help writing two IIF queries that will put some dates into brackets. I have some sku's that have a expiration date and the idea is to put the...
April 22nd, 2010 06:15 AM
by John W. Vinson Go to last post
3 212
Help with 3 scenerio query by Cam
Hello, I am trying to put a formula in the query so that if any date in the the date field is 5 days from today, return "5 days", if 10 days from today,...
April 22nd, 2010 05:24 AM
by KARL DEWEY Go to last post
1 148
Date criteria problem by PayeDoc
Hello All What's wrong with this: SELECT staffs.DOB, CDate(retirementdate(,)) AS retdate FROM staffs WHERE (((staffs.DOB)#1/1/1901#)...
(Multi-page thread 1 2)
April 22nd, 2010 02:39 AM
by John W. Vinson Go to last post
19 388
crosstab query by John
I have a crosstab query for a two year period. How can I get it to return a zero value if there is no incidents for that year. I want to ensure I have all...
April 22nd, 2010 01:20 AM
by Duane Hookom[_4_] Go to last post
3 173
Query between 2 tables with one-to-many relationship by gueser
I have a report that I generate via a query which promptme me for a value for one field of one table. I want to generate all the entries from another table...
April 21st, 2010 10:01 PM
by Ron2006 Go to last post
2 160
Special Characters in Access 2007 by RC
I'm working on a database that has fields filled in with sizes (i.e. 1.5", 2", 3", etc.) I know the " shouldn't have been used but it was. When writing a...
April 21st, 2010 08:22 PM
by RC Go to last post
2 164
Append if Not Exist by QB
I created the following basic Append query INSERT INTO tbl_Clients ( ClientName ) SELECT . FROM GROUP BY .; But now I need to add a twist, I need to only...
April 21st, 2010 07:06 PM
by Jeff Boyce Go to last post
6 365
Negative Figures In A Query by Bateman28
Hi I have greated a query that sums up alot of different fields into numbers, the only problem is the numbers always return as a negative! How do I need to...
April 21st, 2010 04:25 PM
by John W. Vinson Go to last post
4 181
Producing combined table grouped by categories by Zaur Bahramov
Hi! I have two tables: Categories and Expenses. Categories table has 3 fields: CategoryID CategoryName CategoryDescription 1 Stationaries ...
April 21st, 2010 02:17 PM
by John Spencer Go to last post
3 140
I want year in one table to be less or equal year in another table by Cecilia
Hi I have some problems writing a query and I hope someone can help me. I have a database with serveal tables. In one table I have this information, Lake...
April 21st, 2010 12:55 PM
by kc-mass Go to last post
1 147
Customizing the print view for a crosstab query by Afsaneh
Dear All, I think it is difficult to make a report out of a crosstab q. due to variable columns. since my culmns are not date or month ,they are names (and I...
April 21st, 2010 11:57 AM
by Afsaneh Go to last post
0 174
Post New Thread


Display Options
Showing threads 441 to 460 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 09:41 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.