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
writing syntax by aubrey
can you write a syntax that says if text in one field is "x" take the date from another filed add 45 days and populate a third field any help would be...
July 3rd, 2008 07:47 PM
by strive4peace Go to last post
7 191
WHERE help for button code by [email protected]
Thanks in advance for your help. I posted this in a previous thread but I'm afraid that it's faded into oblivion. Two things happen when I click my preview...
July 3rd, 2008 07:46 PM
by strive4peace Go to last post
5 343
Case or IIF? by NBullock
Might there be a better way? I am trying to pull text from a field in one table and then assign those records to that result. For example, if the printer...
(Multi-page thread 1 2)
July 3rd, 2008 06:45 PM
by NBullock Go to last post
18 322
Count number of times an entry for list B shows up in List A (cont by BlueWolverine
Hello, MS Access 2003 on XP Pro. I have two lists, A and B. B contains a comprehensive, unique list of all possible CCC codes. A contains records of work...
July 3rd, 2008 06:43 PM
by Ken Sheridan Go to last post
1 181
Query Question - I don't know by Golfinray
Is there a way in a query to have let's say three fields and do this: If this field is not null OR if this field is not null OR if this field is not null then...
July 3rd, 2008 05:06 PM
by Michel Walsh Go to last post
4 180
Help Designing a Query to Count Classes by Robert T
Hello: tblClasses ----------- I thought designing this query would be easy, but it's turning out to be harder than I anticipated. Obviously I'm doing...
July 3rd, 2008 05:01 PM
by Robert T Go to last post
7 189
Help needed with SELECT query by PO
Hi, I need some help with constructing a SELECT query: WONUMBER PARENT AMOUNT HASCHILDREN =========================================== 1234 ...
July 3rd, 2008 05:00 PM
by John Spencer Go to last post
2 216
Checkbox & Textbox Used As Criteria For A Query by hfrupn
I need to see all records where the field AssignTo is null or has been assigned to a specific person. If the checkbox is true all records with null value...
July 3rd, 2008 03:09 PM
by hfrupn Go to last post
4 260
Crosstab Query by acccessaccess2003
I have a crosstab query created and generates the following result set. 1 5 4 2 4 2 3 3 0 Is there any way...
July 3rd, 2008 02:49 PM
by Michel Walsh Go to last post
2 155
Combo box use as a Query... any help by fossy
I have a query (qryTrainingByTile) and a form (frmUpcomingTraining). In the form is a combo box (Select Title) that selects the title record from a separate...
July 3rd, 2008 02:03 PM
by Michel Walsh Go to last post
3 191
Query on a Query by Brampton76
I have a query that has presented the following result: Name, Competition Name and Playing Option. I also have a separate table that contains the...
July 3rd, 2008 08:03 AM
by Brampton76 Go to last post
4 187
"Setwarnings" option not available by theintern
I'm trying to supress those warning messages everyone else is annoyed with too, but I don't have the "setwarnings" option in the pull down menu of the...
July 3rd, 2008 04:16 AM
by Allen Browne Go to last post
2 222
Can anyone translate this SQL statement for me? by tmwilkin
Something in this below query is not returning all the values I need, so I need to examine it a bit further to see what it is doing. I don't know IIf...
July 2nd, 2008 10:31 PM
by John Spencer Go to last post
2 204
Annual update of Queries by mimf
Is there a shortcut to updating the table name that is in all of my Queries? Each year we start with a new table again and I have to go in and manually...
July 2nd, 2008 10:27 PM
by John Spencer Go to last post
4 173
Switch not working by Student Databaser
So after trying about a million things, i figured out how to use the switch function, but now for some reason it is excluding some records. When i run the...
(Multi-page thread 1 2)
July 2nd, 2008 09:05 PM
by Student Databaser Go to last post
10 305
Total count for crosstab query by HOCSMGR
I am working on a query to show the vendor_name and the total number of pieces the user completed for a certain date. I am pulling the info i need but having...
July 2nd, 2008 08:13 PM
by KARL DEWEY Go to last post
5 149
Query set-up help by Michelle
I need some help. I have multiple tables that I want to combine. All of the tables have the exact same setup. Let's say there are 2 fields, ID and Amount...
July 2nd, 2008 07:10 PM
by KARL DEWEY Go to last post
1 166
Nested SQL Statements causing slowness and errors by Joel Maxuel[_2_]
I am working on a query for one of my reports. It takes a percentage of selected diagnoses (and some diagnosis groups). To save the number of queries, I...
July 2nd, 2008 06:49 PM
by Joel Maxuel[_2_] Go to last post
7 288
Which Query by DNork
Situation: I have a table with many fields including a "status field" and a "dues amt" field. Status is either "member, "Non member" or "LOA Member". I am...
July 2nd, 2008 06:36 PM
by Jeff Boyce Go to last post
3 169
Number format resulting from an aggregate query by Sajit
I get numbers formatted as, 27.0000005960464 41.8999988585711 resulting from an aggregate query. I tried setting the format of the field to General, Fixed...
July 2nd, 2008 06:14 PM
by Sajit Go to last post
7 163
Post New Thread


Display Options
Showing threads 10101 to 10120 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.