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
Vlookup type function by Snara
Hello - I am considering transferring our data recording system from an Excel Spreadsheet to an Access database. I work in a school and one of the key things...
July 21st, 2008 12:26 AM
by John W. Vinson/MVP Go to last post
2 220
Calculating the Number of Days between two dates by [email protected]
I need to calculate the number of working days (MondayFriday) between two dates, for example 10/07/08 - 18/07/08, would be a total of 7 working days. On...
July 21st, 2008 12:24 AM
by Ken Sheridan Go to last post
4 154
Searching field for Text and Numbers by Gus
Hello, Thank you for your time. I am trying to create a query that would let a user type any criteria such as a letter(s) or number(s) and have the query...
July 20th, 2008 05:29 PM
by Bob Barrows [MVP] Go to last post
1 141
Convert number to time by Floyd Forbes
I have field with numbers like 28815. How do I convert this number to 8:00:15 AM time format. Is there an easy way to convert numbers to time? Floyd
July 20th, 2008 12:21 PM
by Bob Barrows [MVP] Go to last post
1 133
Select query not allowing change by mav51 via AccessMonster.com
Hi there, I have a form that is generated by a simple Select query showing all records where the field 'booPass' is true. I would like users to have the...
July 19th, 2008 03:34 PM
by mav51 via AccessMonster.com Go to last post
3 170
matching more than one continous form field on other form, possibl by efandango
I have two forms, the first is a continous form containing a list of addresses. On another tab I have the 2nd continous form which filters for any occurance...
July 19th, 2008 03:17 PM
by efandango Go to last post
0 113
Equivalent of DROP TABLE IF EXIST? by Mike Walsh[_2_]
I am fairly new to access but have used MySQL for a while. The problem I currently trying to solve makes use of a temporary table via a SELECT INTO...
July 19th, 2008 01:37 PM
by Mike Walsh[_2_] Go to last post
5 161
Crosstab Query shows age 1,2,3,4,5 etc totals, I want 1-2,3-5,6-10 by ken957
My database contains many tools bsed on wafer size and includes their age. I do not need a count of each individual age, but rather want totals for ranges...
July 19th, 2008 10:49 AM
by raskew via AccessMonster.com Go to last post
3 200
Update Query by Greg
I am working on an auction database where each buyer has a buyer number. I have a buyer receipt that prints. When I click on the Buyer Receipt button a...
July 19th, 2008 08:14 AM
by miss031 Go to last post
2 125
Corrected divide by zero errors, now no formatting of numbers by kahaymon
I used the info in this help article: http://office.microsoft.com/en-us/access/HA010550731033.aspx?pid=CL100570041033 to correct divide by zero errors, and...
July 19th, 2008 05:07 AM
by Allen Browne Go to last post
1 143
Query help needed by dave
Access 2003 I have a field (Forman) in a table which is a lookup to another table. I an storing the ID not the name. When I use the field in a query for a...
July 19th, 2008 04:14 AM
by fredg Go to last post
1 106
Error 3071 for dates after July 3 2008 by Ary
I have several reports giving this error. The reports all require To and From date parameters. They all work perfectly fine for any datae range provided that...
(Multi-page thread 1 2)
July 19th, 2008 01:56 AM
by David W. Fenton Go to last post
11 249
Update Query - One Field, Mutiple Posibilities... by John
I have a field in one table that must have one of 18 (string) different values deplending on the value of a cost code. The table fields a ! - The cost...
July 18th, 2008 11:49 PM
by John Go to last post
4 116
Union Query by broncojim
I am trying to combine the results of several different select queries. Two of the select queries are listed below. The problem seems to be with the ...
July 18th, 2008 10:11 PM
by KARL DEWEY Go to last post
3 118
Delete Related records by stvlai
Hi I have a Table that have 4 Fields : ID, Serial_No, Status, Model_No. Contents of my Table ID Serial_No Status Model_No 1 11 ...
July 18th, 2008 10:07 PM
by John Spencer Go to last post
2 124
Rank after Sort by CJ
Hi Groupies: I am creating a database for a golf tournament. After the Thursday and Friday scores are input, I need to flight the players for Saturday. I...
July 18th, 2008 09:44 PM
by KARL DEWEY Go to last post
1 101
joining on dates by joemeshuggah
is it possible to join on dates? for example inner join mytbl on date() = mytbl.eff_dt and date() = nz(mytbl.exp_dt,date())
July 18th, 2008 08:04 PM
by Bob Barrows [MVP] Go to last post
4 178
access 2003 join not returning expected records by dbnoodler
I have a table of records of lead contact info and another that has territory numbers assigned to zip codes. I have joined the tables at their zip code...
July 18th, 2008 07:51 PM
by dbnoodler Go to last post
5 180
Query to show all records of one table and updated info from anoth by Bob Dancer
I am setting up a query to get updates on one table (A) of over 1000 records from another table (B) of over 90,000 from the Bureau Work Com. The tables are...
July 18th, 2008 05:57 PM
by Marshall Barton Go to last post
3 121
DateDiff function by RL
I am trying to work out the number of days between two dates, EXCLUDING WEEKENDS to monitor our order order turnaround time. I am using the datediff funtion...
July 18th, 2008 04:43 PM
by RL Go to last post
3 125
Post New Thread


Display Options
Showing threads 9841 to 9860 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:38 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.