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
Crosstab Query?-NOT BLANK by efwerwerr
i want myspace.... "KARL DEWEY" wrote: You can do it with multiple queries. PMLogQuery-1 SELECT "X" AS x, Sum(1) AS FROM TblPMLog WHERE...
February 23rd, 2007 08:16 PM
by efwerwerr Go to last post
0 120
Annoying String Sorting Problem by David M C
It seems Access isn't so clever at sorting strings. Each different type of string requires a different sorting method. For instance, given a field,...
February 23rd, 2007 07:49 PM
by Matthias Klaey Go to last post
6 165
Numeric Field Overflow Error for Macro by [email protected]
Using Access 2003, I have a table linked to an Excel spreadsheet. Running a series of append queries as part of a macro, I'm trying to generate a table that...
February 23rd, 2007 07:49 PM
by [email protected] Go to last post
4 155
query is perfect in immediate mode, doesn't work in combo box by SandyR
Here is my query: SELECT tbldayemps.empno, tbldayemps.crewno, tbldayemps.logday FROM tbldayemps WHERE (((tbldayemps.crewno)=0) AND...
February 23rd, 2007 07:35 PM
by SandyR Go to last post
3 143
Merging data - no duplicates by Carlee
Hi, I have two tables with Owner information in each. I want to create a single data set, without duplicates. Can anyone suggest an approach? -- Carlee
February 23rd, 2007 06:30 PM
by Michel Walsh Go to last post
1 140
counting visits by Jackie L Preston
I have a patient visit table structured as Name, Date, VisitCode, Date1, VisitCode1, ...Date6, VisitCode6 corresponding to the 7 days of the week. Name is a...
February 23rd, 2007 06:17 PM
by Jackie L Preston Go to last post
3 121
Query criteria by Jim Pockmire
I would like set criteria based on a value from a form, such that if the value from the form is "1" a specific recordset is returned and if the value is not...
February 23rd, 2007 06:08 PM
by John Spencer Go to last post
3 138
Making a max query by Enrique Rojas
Hello, I am trying to make a query in which I just want to show the records with the maximum values. It sounds so simple but my sql is a really rusty when it...
February 23rd, 2007 06:04 PM
by Jason Lepack Go to last post
4 190
Building SQL statement in VBA. Getting 3131 Runtime Error in FROM clause :@ by [email protected]
I'm trying to make an SQL statement on the fly using form variables to use in a query for a report. I've copied the SQL statement from the query and assigned...
February 23rd, 2007 05:54 PM
by John Spencer Go to last post
5 158
How to populate sequential ID on an existing table? by Grasshopper
Hi all, I have an exsiting table with 1 million records without an unique squential ID field and I would like add one to the table. How can I do it? Also,...
February 23rd, 2007 05:51 PM
by Grasshopper Go to last post
9 140
Matching Table value to Query Expression by [email protected]
Hello All, I am in need of some assistance. I am completely burnt out after putting together a database. My database tracks our workers efficiency. This is...
February 23rd, 2007 04:45 PM
by Michel Walsh Go to last post
1 90
Displaying records in a query from two tables by Alylia
Hello, I have two tables - Invoice Table (primary) and Debit_Credit Note Table with a 1 - 1 relationship based on invoice number. Normally I have noticed...
February 23rd, 2007 04:36 PM
by Matt Go to last post
1 124
Date Format by Chris
Here at my shop we use peoplesoft and peoplesoft uses julian dates that look like this: 107040. My question is if someone gave me a date in the format of...
February 23rd, 2007 04:36 PM
by Chris Go to last post
6 118
Automatically Adding Data from previous field under certain condit by Jim McC
I have data as follows: 01/12/07 Fri 242 01/13/07 Sat 01/14/07 Sun 01/15/07 Mon (Holiday) 01/16/07 Tues ...
February 23rd, 2007 04:25 PM
by Michel Walsh Go to last post
1 105
Error 3079 by yorkielover02
I know that I need to include the table name but it won't let me back into the query to include the table name that I am referring to.
February 23rd, 2007 04:22 PM
by yorkielover02 Go to last post
0 125
IMPORT date from text file by Lucio
I have a text file that contains a field of the type 'dd-mmm-yy' When I import, it notices it is a date/time field It does not load. It returns a conversion...
February 23rd, 2007 04:04 PM
by Dale Fye Go to last post
1 118
Legth of all columns in db by JR
I am trying to get a list of each column name in a particular table, and the maximum data element within each of the columns. So if one column had two...
February 23rd, 2007 03:36 PM
by Duane Hookom Go to last post
4 125
Trace records through a table by Mike4171
I have a table of checks. The PK on the table is the CheckNum field. The table also has a column ReissuedCheckNum to indicate if the CheckNum was reissued...
February 23rd, 2007 03:20 PM
by Mike4171 Go to last post
6 109
User interface via Net by Matti Koski
Hi, I would like to study of how to make an easy user interface via Net to Access database. Please give your recommendation. Matti
February 23rd, 2007 03:10 PM
by Michel Walsh Go to last post
1 118
Email Merge Based upon a One to Many Form Query by Robert T
I am testing two different Email Merges based upon queries of the current record from Access 2003. It's our student registration database and we want to...
February 23rd, 2007 03:10 PM
by Robert T Go to last post
0 101
Post New Thread


Display Options
Showing threads 19921 to 19940 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 08:46 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.