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
Insert a default record for all values by Anthony
I have a table with station names for ex. SS-MICU, SS-MIMCU, ect. I need to have a query fun and input a value of SS-MICU 00000 for all records that have a...
March 12th, 2010 03:00 PM
by John Spencer Go to last post
3 249
Add a space between two values by Anthony
I have a query and I have to add a space between two values, see my exp below: Station Name & Item: ! & ! This currently displays it as SS-HVICU04521 and I...
March 12th, 2010 01:45 PM
by Anthony Go to last post
3 232
I need to always Round UP if greater than zero at all. HOW? by RP
I am in office 2007 Access DB - I have quantities that are greater than Zero but the Round function will round down to 0, if the number is not over .5 - how...
March 12th, 2010 05:45 AM
by David W. Fenton Go to last post
9 417
Sequential Grouping by blobmiester via AccessMonster.com
Hey all, I have a column in a table that goes something like this: 1 2 3 5 6 7
March 12th, 2010 03:13 AM
by John W. Vinson Go to last post
4 214
SQL question - Cross Tab query by cinnie
hello gurus I have a Cross Tab query that works fine. The SQL for this query ends with... PIVOT tblData.Region I've noticed that the column headings in...
March 11th, 2010 10:43 PM
by Duane Hookom[_4_] Go to last post
2 214
How to populate a column in a row based on a value in another colu by PhatAdo
I have several tables and I’m having a problem with my last one. I have two columns in this table, ‘License’, which are populated using combo boxes,...
March 11th, 2010 09:40 PM
by KARL DEWEY Go to last post
3 218
Update query to replace everything after comma by richb
I'm trying to remove everything after the first comma in a column of addresses. It seems like it should be simple but I can't get it to work. I have...
March 11th, 2010 09:09 PM
by John Spencer Go to last post
2 155
Iif Statement Problem by csandbrook
I am trying to run the below query to simply find data in a column that is a certain criteria, then taking data in another column and multiplying it and it...
March 11th, 2010 08:14 PM
by John Spencer Go to last post
2 171
select queries that calculate the Median base on group by by Zb Kornecki[_2_]
I have 2 questions. 1)Is it possible to create additional aggregate functions in MS Access 2007? If yes than this leads to: 2) I would like my select quries...
March 11th, 2010 07:23 PM
by ghetto_banjo Go to last post
1 297
days between end of one record and start of another by Bibi
I have a rental database. I need to be able to calculate the number of days a property is vacant. Nothing I have tried has worked. I do not write code. ...
(Multi-page thread 1 2)
March 11th, 2010 06:05 PM
by Bibi Go to last post
12 483
How to Return all Records with Blank Cells? by Chris
Might be an easy question, but how do I return all records which have empty cells for the specified FIELD Example: Name School Home Child 1. ...
March 11th, 2010 05:11 PM
by Jeff Boyce Go to last post
2 203
Compare 2 Fields by carl
My data looks like this: Sym Price1 Price2 A 11.3 11.3 B 8.75 8.75 C 7.8 7.8 D 6.75 6.75 E 5.75 5.75 I would like to create a new field that will compare...
March 11th, 2010 03:53 PM
by Chris Go to last post
1 165
Hours for month as value in query by AccessKay
Hi Everyone, I don’t know if this is a simple or complex request but it’s definitely complex for me. I want to have a field in my query that does the...
March 11th, 2010 03:05 PM
by AccessKay Go to last post
7 168
March 11th, 2010 03:00 PM
by carl Go to last post
0 162
Crosstab query to include fields with Null value by Peggy Ball
Hello ~ I have created a report based on a crosstab query for student attendance. Row = Name Columns = DR, Ed, FE, ILL, RH, TEX, TRP, TUN, UNV, UNX (absent...
March 11th, 2010 02:30 PM
by John Spencer Go to last post
2 227
Need to Make Query Run Faster - SLQ? by bassstuf via AccessMonster.com
I need to make my query run faster and I am not sure if any improvements to my SLQ can help. It caculates off of 2 very large Tables Table 1: Formation -...
March 11th, 2010 01:52 PM
by bassstuf via AccessMonster.com Go to last post
2 169
Is it possible and how can it be done? by Hallgeir[_2_]
I have a table looking like this: Id TaskLeader PreviousId .... 4 Hans 2 5 Kari 7 6 ...
March 11th, 2010 08:25 AM
by Hallgeir[_2_] Go to last post
5 154
DISTINCT or GROUP BY? by Kathy R.[_3_]
Using Access 2007. My table is as follows tblIndividual IndID (autonumber, primary key) OLD_FamID (not unique) LastName (not unique) OLD_MembID (unique) I...
March 11th, 2010 04:04 AM
by Kathy R.[_3_] Go to last post
4 199
Query that will look for duplicate in two tables. by John
I have two tables that were originaly Excel tables and imported them into Access. Import went well. Both tables consist of columns named - Name, Department...
March 11th, 2010 03:13 AM
by John W. Vinson Go to last post
3 156
vintage hardware by raismisuaween
the vintage vintage apparel vintage toy catalogs vintage wear la vintage
March 11th, 2010 12:55 AM
by raismisuaween Go to last post
0 159
Post New Thread


Display Options
Showing threads 901 to 920 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:50 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.