Over 1 million tech questions and answers.

Access Query: Display Airlines like Calendar in Access

Q: Access Query: Display Airlines like Calendar in Access

Hi,

Can anyone help me design airlines website like calendar in access.

Like, when it shows, the date and the availability and the price of ticket.

Thanks,

RELEVANCY SCORE 200
Preferred Solution: Access Query: Display Airlines like Calendar in Access

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

A: Access Query: Display Airlines like Calendar in Access

Read other 12 answers
RELEVANCY SCORE 81.2

For some reason I cannot access southwest.com - on any of the three computers I own. At home these three computers access the internet via a wireless modem that connects with the comcast host. When I travel with either laptop the same problem happens. It also happens using Firefox. When I attempt to open southwest.com I get a connecting message and it will grind away for a half-hour or so before finally timing out. Sometimes the southwest site will partially open. I have tried deleting cookies, but that doesn't help. Any suggestions.

Thanks.

Rob

A:Cannot access Southwest Airlines

You might have SW on your banned URL list. Check 64.57.78.148 to see if that connects.

Read other 17 answers
RELEVANCY SCORE 81.2

I cannot access Delta Airlines url (www.Delta.com) from any of the 3 computers on my Home network anymore. I can take my Laptop to another network and access perfectly. All PC's use XP.

I have access to all other url's (websites) from any of the 3 computers except the Delta Website.

Any help is appreciated.

A:Can't access Delta Airlines url

Click Start => run type in CMD press OK. When command prompt opens up type in Ping www.Delta.com and press Enter. Please copy and paste the results back into this thread

Read other 1 answers
RELEVANCY SCORE 79.6

I am trying to built an application to display the availability of data from different tables in a form of calendar.I have a table A, B, C.Now, I will have to display data availability on a certain date.if A, B and C are available display the date in the calendar as Green.if only A is available, then display the date in Orange and like wise.Kindly assist.
 

A:Access form to display data availability like a calendar

Read other 7 answers
RELEVANCY SCORE 78.4

Hi!, I created a table containing student records in Access. Two of the fields are student name and student ID. After that I created a simple form and put a combo box where I populated all student IDs.

Then I creted a query to retrieve a name of the student from the table corresponding to a selected student ID from combo box. Until this point, things worked perfectly.

Then, I created a label (Student Name) on the form to display the retrieved student name. This is where I have totally failed. I don't know which mechanism or a piece of code should I use to assign this student name to the Student Name Label (Caption). Pleezz help!!!

Ishak
 

A:How To Display a Query Result to the Label (Caption) in Access

Read other 6 answers
RELEVANCY SCORE 75.6

NOTE: I could not post code because I must be really careful to protect proprietary information.

I work in an assembly plant and I've designed an Access 2003 program to deliver a set of 4 crucial parts to the floor all within a very narrow degree of tolerance. Further, the program integrates FIFO.

Ive done this by assigning each of the essential measurements codes and then running a series of queries:

Query 1 identifies the oldest Part A by sorting the available parts by the date they were inspected then by serial number (to break ties) and delivering the TOP 1.
Query 2 identifies the oldest Part B that is compatible with that Part A using the same method.
Query 3 identifies the oldest Part C that is compatible with that Part B.
Query 4 identifies the oldest Part D that is compatible with the other end of Part A. I have the parts in this order because we can begin assembly if we don't have a Part D on hand, but we must have Parts A, B, and C.
Finally, query 5 simply pulls the information from those queries into one location for a report.
As long as we have enough stock, life is good; but the moment a match cannot be made, it blows up. I cannot figure out how to make it go back to choose the next Part A. I need to figure out how and where to add code to each query to tell it that if no stock is compatible with the Part A produced by Query 1, to go back and pick the next one in line.

Can anyone help? Is the way I've gone about matching parts completely... Read more

A:Access 2003 – Query Based on Query – need code to rerun earlier query

Read other 11 answers
RELEVANCY SCORE 73.6

I'm allowing the user to choose the key from Select combo - my bound column is the key.
I want a second section of the form to go and fetch ALL occurances from another table that has the key from my first step as part of the combined key.
I've tried a subform/subreport (which I felt would be the ideal - I only want to display)
But nothing comes up.
I've also tried to use a combo box and populate it with a requery, but no luck there either. So now I've decided that my error is in the query I use for the combo box
SELECT Tenders.[TENDER NO], Tenders.TENDERDESCRIPTION, Resolutions.[RESOLUTION NO], Resolutions.[MEETING DATE], Resolutions.RECOMMENDATION, Resolutions.[TENDER VALUE]
FROM Resolutions INNER JOIN Tenders ON Resolutions.[Tender No] = Tenders.[tender no]
WHERE Tenders.[tender no] = Forms![2nd Copy of Find Tender Number and Resolutions]!Combo25
ORDER BY tenders.[tenderdescription], resolutions.[resolution no], resolutions.[meeting date];
I want tender no to be the bound column in combo25 (in vb I'd put combo25.column(0)
How do I put that in a query?
 

A:Solved: Wanting to access bound column in query access sql

Read other 13 answers
RELEVANCY SCORE 73.2

Hi there,

I'm very new to access and I hope I will get the simplest solution on my question below.

I have a table named "PurchaseOrder" and I'd want to create a query that will display the invoices that will due.

Eg:

Table1
PONo Customer Quantity SalesPrice InvoiceDueDate
3241 A 421 $12 17-Oct-2010
6589 B 521 $19 14-Oct-2010
2234 C 987 $32 15-Oct-2010
8697 D 888 $88 18-Oct-2010

I want to create 2 queries.

The first query will display all the invoices that will due 5 days before the exact due date.
Eg:
The invoice due date is 15-Oct-2010. The query will display information on 3241, 6589, and 2234.

For the second query, I want to display all the invoices that have exceeded the due date. The information on the respective invoices will be transfered from the query as mentioned earlier to the new query.

The scenario is as below:

Date: 16-Oct-2010

Query1

PONo Customer Quantity SalesPrice InvoiceDueDate
3241 A 421 $12 17-Oct-2010
8697 D 888 $88 18-Oct-2010

Query2

PONo Customer Quantity SalesPrice InvoiceDueDate
6589 B 521 $19 14-Oct-2010
2234 C 987 $32 15-Oct-2010
Date: 18-Oct-2010

Query2

PONo Customer Quantity SalesPrice InvoiceDueDate
8697 D 888 $88 18-Oct-2010

Query2

PONo Customer Quantity SalesPrice InvoiceDueDate
6589 B 521 $19 14-Oct-2010
2234 C 987 $32 15-Oct-2010
3241 A 421 $12 17-Oct-2010
Hope someone can help me with this. Really appreciate and hoping for ur help.

 

A:Query Access 2007 (how to transfer data from a query to another query)

The first query needs the following first Criteria Row of the InvoiceDueDate
between date() and date() + 5
The second query needs
< date()

I haven't tested it, just worked from memory. so let me know how it goes.
 

Read other 2 answers
RELEVANCY SCORE 69.6

I have written a macro to make a table from data in an existing table. Then I use the data in the new table to select information in another table. That select query does not allow me to update the information in the 2nd table. It is like the records are locked. Even if I create a new table myself the select queries are locked but all my pre-existing queries work fine. Is there some type of setting I am missing that causes the information to be locked in select queries? I am thinking somehow the setting may have been changed. Any thoughts would be appreciated.
 

A:Solved: Access Make Table Query and Select Query

Read other 7 answers
RELEVANCY SCORE 69.6

I've got a lending table in which we lend items out, now they can be loan or permanent.

I can run a report with the query parameter on the ReqDate_Fld criteria Between [Report Start Date] And [Report End Date]

The report prints and counts everything borrowed.

Now I want to add more records to the report to include everything borrowed that was returned during that period specified by the criteria Paramenter set in the query. But using the Return Date (RetDate_Fld)

How can I select rows from the query based on the parameter date filled in when the query ran?
[Report Start Date] and [Report End Date].

I can build a separate report just for the returns using the current parameter but on the RetDate_Fld Between [Report Start Date] And [Report End Date] set by the query.

I've got it grouping at 3 levels to get it to break by Borrower, ReqID, and Request Date

Does this make any sense?
Thanks
 

A:Solved: Access query report query paramater use the param

You would have to have another group for whether or not the RetDate_Fld was filled in or not.
Add a new column to the query with the following Heading

RetDatefilled: iif(not isnull(RetDate_Fld), 2, 1)

That should place a 2 in the new column when there is a date and a 1 when there isn't.
You can now group on that data.
 

Read other 2 answers
RELEVANCY SCORE 67.6

For a report I have a customer table, an invoice table and a revenue or payment table.

I need to produce a report that shows all the invoices created during a given month and year - that part is easy.

But then I also need to show the first payment given on that invoice. This is a situation where there is always a down payment made at the issuance of the invoice - but sometimes people will make more than one payment during a month.

Example:

I want the customer listed for each new invoice, the total amount of that invoice and what the inital payment on that invoice was: [CustomerID][Customer Name] [Invoice No][Total Invoice Amount] [Payment Amt]

So if there was an invoice issued for $100 and they paid 50 and 25 during the month it was issued and the balance on the next month, I still want to show it on this report as a $100 invoice with a $50 downpayment only.

(The tables are established and populated so it is too late to change the payment table to allow for a unique downpayment field. They all go in as payments.)

My problem is that if they made more than one payment during the month, the whole line with the customer name and invoice number shows up for each payment made. I only wnat the FIRST payment. I need a payment query that shows only the first payment in the month of invoice issuance.

Does that make sense?
 

A:SQL Query question for Access 2010 query

Yes it makes sense, I would create a pre-query that uses the Month & Year but is set to "Totals" and Date Minimum.
Then create the Report query using the pre-query linked to the new query's table via the InvoiceID this will limit both the month, year and minimum payment.
 

Read other 1 answers
RELEVANCY SCORE 67.6

I have a previously designed Access DB and there is a query that I am trying to understand. It has several tables that are queried more than once in a single query. First how do I determine the actual table name? I can only see the alias name. Also what is the purpose of using the same table twice in a query?
 

A:Solved: Access Query using tables more than once in same query

It is normally to do calculations or comparisons on prior or next records. It is the one weekness of Access Queries, the Totals function has some good arithmetic calculations like average, Count Sum etc but manipulating previous records like add or subtract values from the current record it can't do. So it requires more advanced SQl. Which is apperas you have.
Have you looked at the query in SQL view?
It should use the word "As" to designate the alias.
 

Read other 2 answers
RELEVANCY SCORE 67.2

Good morning,I have a system that has had numerous issues, mainly virus related. I have cleaned the system, and show no virus activity... but I'm still having issues.Late last week the system was stuck in a loop, it wouldn't boot to Windows at all (no safe mode, no normal mode). I resorted to a Windows repair from the install disk. It worked... to a certain degree. I am now able to get into Windows, but can not open IE and I can not install a display driver.I am unable to access Windows Update, but was able to set automatic updates to install lots of updates including SP3, but I am still unable to make any changes.Initially when I attempted to open IE I would get a window saying that IE had to close instantly. I attempted to reinstall IE, and I attempted to install a newer version of IE. Neither worked. If I chose to install the updates with the install I would get an access denied error, if I chose not to install the updates with the install it would look like it worked, but now when I click on IE I get "Error loading C:\WINDOWS\System32\inetcpl.cpl. The operating system cannot run %1"In device manager, I have no drivers installed on my display adapter. If I try to update it, it looks like it's going to install... but then I get "Cannot install the hardware. Access is Denied".Any assistance or insight into this would be appreciated.

A:Unable to access IE, access denied when updating display drivers, no windows update

On any system with a number of issues...it's often better to do a clean install to wipe the slate clean, rather than hope that you have patched all known and unknown issues, IMO.

Louis

Read other 3 answers
RELEVANCY SCORE 65.2

Hi Access bods.
Can anyone tell me how to do an expression to query from DATATABLE (the name of table), containing

ID: Auto ID key for the table
SITEID: There are multiple sites
ITEMID: Each site will have multiple Items
QUALITYID: This is set to either F, or is left blank
Id like to find the Percentage of Non-F, to each SITEID and ITEMID combo. I hope this makes sense.
 

A:Solved: Access Query, Query

Read other 6 answers
RELEVANCY SCORE 64.8

How can I setup my access 2013 database Calendar to show up in Outlook 2013 Calendar. please help me

 

A:Link a Access 2013 database Calendar to Outlook 2013 Calendar

what database are you using?
 

Read other 3 answers
RELEVANCY SCORE 62.4

Hi everyone,

I have an application that has a calendar and it display just find on my PC but when one of the user open it. The fonts on his calendar are too small when I check his setting it shows 1.7 I think. What should I do.. is only one user that is getting this calendar like that. The only thing I can think is that he just got a new PC and a service pack or something is missing!
Any help would be greatly appreciated.!

Thanks
AMD2800
 

A:Calendar in access 2000

Read other 8 answers
RELEVANCY SCORE 62.4

I have a calendar, and a subform named [time off gr upd qry subform] in that form is a [date] column. How do I bind the calendar to the subform. If I put anything in the control source box it only works partially.

I have tried:

Date
[Date]
=[Date]
=[time off gr upd qry subform]![date]

Nothing seems to work.
 

A:Access Calendar Control

Mieucher, you have to be careful using the word Date as a field title as it is also a reserved word for the "Current Date".
You should make sure that the field name is something like Dateoff etc and then in the Calendar Control Source select it from the Field list.
 

Read other 3 answers
RELEVANCY SCORE 62.4

Ok, i have a form that has a calendar...when you click on the "hiredate" or "birthdate" the calendar appears, and when you click anywhere on the detail area, it disappears...however, whenyou change a date on the calendar you must click in either the "hiredate" or the "birthdate" for it to take the change....i would like to make this automatic, so that when a person clicks the calendar the coresponding field...hiredate or birthdate, is changed....is this done with the "on update" event? any help would greatly help my grade!
if so could someone give me an example?

-Craig
 

A:Access: One Calendar for Two Fields?

Yes, well, a couple of questions, so that our solutions change your environment the minimum amount possible:

1. Are you sure that the calendar that appears is on the same form? Or is a special calendar form appearing and disappearing? You might want to poke around in the db window, and/or post back the details (macro or code behind the events, for example, on click) for hiredate and birthdate.

2. Also, what's behind the calendar? The tricky part of what you're talking about is having the same control (or form containing a control) for two different text boxes; that's why you're having to click in the appropriate box, I'm guessing: to tell the calendar which box to put its value in.

I'm guessing that you didn't build this initially? If these questions seem to complicated, just zip up an example version of the related table(s) and the form(s) in an .mdb file and send them to me. (Must be under 1MB.) But if you can post back the details on what's going on behind your controls, we can probably give you a faster response.
 

Read other 3 answers
RELEVANCY SCORE 62.4

I have several forms that have undound fields which are apopulated via a calendar on access (ocxcalendar)

One of the forms works and then if a modification is done on the form code (even if the change is not related to the ocxcalendar) the feature stops working and the fields are not populated by the calendar.

This has only 3 routines (all the forms that use the calendar have the same 3 routines), one for the ocxcalendar_click and then the start and end dates have each one routine triggered by the on mouse down event.

Any ideas?
 

A:access calendar control

Read other 6 answers
RELEVANCY SCORE 62.4

Hello all, I hope you can help me with my very first query in what I expect to be a problem-filled project.

I've researched the ActiveX Calendar control on the web and have noticed a discrepancy between the one on my form and those I have seen online: On mine, I can't change the selected date. The combo boxes at the top to change month/year work fine, but nothing happens when I click on a different date. Is this an error, do I need a patch or do I just need to add some code?

Thanks
 

A:ActiveX Calendar in MS Access 97

In design view, under properties for the calendar, make sure Enabled is set to yes and Locked is set to no.
 

Read other 2 answers
RELEVANCY SCORE 62.4

I have recently starting working as a personal assistant to an executive who is not very tech savvy. He would like me to have access to his Outlook calendar which is running from his office. I do not work for him at his office, only remotely. How can I get hooked up to his calendar from my laptop at home?
 

Read other answers
RELEVANCY SCORE 62.4

Hi! Can anyone tell me how i can put a Calendar control similar to those found in other Office apps (where there's a red circle on the current date) on a form? Thanks!!
(sorry for the initial typo)
 

A:Using that calendar control in Access 200

Tools > Active X Controls... Calendar Control.

From there on out, it works like any other Active X, that is to say more or less like a native Access control, but always with a nasty surprise or two built in.
 

Read other 1 answers
RELEVANCY SCORE 62

I have an access database with two tables (Customers and Orders) which are related by a customer ID field in both tables.

I have a form which contains a combo box filled with the Customers Names and a combo box filled with the Order Dates.

I want to use this form to "filter" information which is fed into a different form.

I want to be able to filter information by using either the Customer Name Box OR the Date box OR maybe both.

E.G. I might want to find all orders for Joe Bloggs OR I might want to find all orders made on the 1st May 2007 OR I might want to find all orders made by Joe Green on the 21sy Feb 2007.

I can't get it to work... any help wold be appreciated!
 

A:Access Query

I have posted a database that shows how to construct a Search Form, a Search Query and a Form based on the Search query. See this thread post #11 -

http://forums.techguy.org/business-...ccess-2003-import-data-one.html?highlight=obp
This is an advanced version, there is simpler version here on post #7 -

http://forums.techguy.org/business-applications/577672-access-help.html
 

Read other 2 answers
RELEVANCY SCORE 62

I have two working queries. One categorises the age ranges of our clients by year:
SELECT [CM Database].[Age Range], Count([CM Database].[Age Range]) AS [Count], Format([Date Contacted],"yyyy") AS [Year]
FROM [CM Database]
GROUP BY [CM Database].[Age Range], Format([Date Contacted],"yyyy")
HAVING ((([CM Database].[Age Range]) Is Not Null) AND ((Format([Date Contacted],"yyyy"))=[Year]));

The other calculates the financial year from the [Date Contacted] field:
SELECT [CM Database].[Date Contacted], Year([Date Contacted])-IIf([Date Contacted]<DateSerial(Year([Date Contacted]),4,1),1,0) AS FinYr, [FinYr] & "/" & Right(([FinYr]+1),2) AS [Financial Year]
FROM [CM Database]
WHERE ((([CM Database].[Date Contacted]) Is Not Null));

Can anyone tell me how to bring these together, to select the age range categories for a particular financial year?
My attempts to date, adding calculated fields, has not been successful...
 

A:Access query SQL

I can see one problem, that is the fact that the first query uses Grouping and the second one doesn't.
Have you tried basing the Second Query on the first one?
Or judging from your description basing the first query on the second one?
It is possible to actually join 2 queries together by having one of them as a Subquery, but it has very limited use as I think the Sub query can only provide one record to the main query, but it might work if it was only the Financial Year.
Can you post a dummy zipped database in Access 2000-2003 format?
 

Read other 1 answers
RELEVANCY SCORE 62

Hi Guys,

Im doing a make table query where one of the fields is blank (i,e Date:Null). Then i want to run an update query which will add in the date field i want. Now the column that i create defaults as data type binary but id like it to default as data type Date/Time. I can go in and change the type after ive created the table and before i run the update but i want this report to run in a scheduled task. If that makes any sense to anyone could you tell me how this is done?

Cheers
 

Read other answers
RELEVANCY SCORE 62

No records are displayed when you merge data from an Access 2002 query with Microsoft Word 2002?
When you open a new document you get the error message no records found, however an old document will allow the merge to work fine.
help?
 

Read other answers
RELEVANCY SCORE 62

Hello, I have made a module that will help me average out all row's yes/no answers. To properly make a query based on this, I set up a query that addresses the columns that the information will be used from.I've made the following:

Field: TableName.*
Table: TableName

Field: FldAvg: Val(RAvg([COLL-2021],[COLL-2090],[COLL-2092],[COLL-2095],[COLL-2096],[COLL-2097]))
Format: Fixed

I do this for several different tables. The thing is, I don't just choose specific columns. The column names aren't numerically perfect. They are named after tests. I don't have specific ones I want to choose from - I want them all to be evaluated. I run into an issue when I have a table with 30+ columns. If I hand jam every single column into the query, I get a "too complex" error. Can someone help me write the query to say "any column with "COLL" in it"? Actually, I don't care how it happens, haha. I'm just not experienced enough to know how to make it happen so any suggestions are welcome.

Thank you so much for the help.
Garthras

 

A:MS Access Query Help

Read other 9 answers
RELEVANCY SCORE 62

I have a query in access in which I want to use 3 dates parameters but for some reason when I run the result it is giving me the wrong total. Basically I want it to show me all results that within the date parameters that I set (more like an "AND" function) but for some reason it is doing a ("OR" function).

The date parameters are in 3 different fields. Can anyone tell me why that is doing that? PLEASE HELP
 

A:Query in Access

Read other 14 answers
RELEVANCY SCORE 62

I have created an Access 2010 Form to enter information about different clients I am serving through a grant funded program. The grant requires that we meet certain benchmarks and I am at the point now where I need to create reports that show our outcomes each month. I know very little about queries or reports in Access and do not know where to start. I need to be able to do a couple of things. The clients in the program meet with a therapist and our grant benchmark is that each client meets with a therapist at least 3 times a month. My form allows a user to enter in a date and the type of therapy they had. My first question is how would I write a query where I could generate a report that provides a list of all of the clients with the number of therapy sessions they had in a given month and also calculates the average number of times the clients as a whole met with a therapist for the month (total therapy sessions for all clients in January divided by number of clients)? My second question is a little bit more complex and only impacts the numbers for a client the first and last month they are in the program. Sometimes a client may not begin the program until well into a month and we do not want our numbers negatively impacted by this. If we don?t take into account the number of days someone was in the program the first month they enter the program or the last month they are in the program, then we could end up with numbers that show that we are not meeting our goals. For e... Read more

Read other answers
RELEVANCY SCORE 62

Hi Guys,

I am trying to create a query that calculates the number of day between 2 dates.

Colum 1: RMANUMBER
Colum 2: ENTERED
Colum 3: PROCDATE
Colum 4: NumberOfDays

Date 1 is "ENTERED" and date 2 is "PROCDATE" and i would like the number of days between to be in "NumberOfDays"

Can anyone help please?

Many thanks.
 

Read other answers
RELEVANCY SCORE 62

Hello all,
I want to make a query based on two tables. One table contains the name of a company and another contains a field that gives the type of project. I did this because there are multiple types per company. EX.(General Motors is both a car servicing company and a car manufacturing company). I need to create query to find which ones match criteria ex(companies whom service cars AND manufacture cars). How would I go about doing this query?
 

A:Access: Help with query

Read other 9 answers
RELEVANCY SCORE 62

I have an access DB that I am trying to run a query from using VBA/SQL and make it match results with the same query, only built using the query grid in Access. The only change being made is that in the VBA version I want the "Mon" value to come from a combobox. I am posting the setup of the query grid first below, followed with the SQL code I am trying to use in VBA. They are returning different results despite the month being chosen is August in both cases.

Query Grid (table = "tblRawData):

"Mon" = 'August'
"FResp" = no criteria
"Business" = no criteria
"Task" = no criteria
"Role" = 'FTS'
"HomeSite" = no criteria
"Region" = no criteria
"Trainer" = no criteria
"Hours" = no criteria
"PctOfTotal" = no criteria
"TotalHours" = no criteria
"Distuser" = no criteria

SQL (VBA) Statement:

Set QDef = DBase.QueryDefs("qryDataForFunctionalReport")
QDef.SQL = "SELECT tblRawData.Mon, tblRawData.FResp, tblRawData.Business, tblRawData.Task, tblRawData.Role, tblRawData.HomeSite, tblRawData.Region, tblRawData.Trainer, tblRawData.Hours, tblRawData.PctOfTotal, tblRawData.TotalHours, tblRawData.Distuser " _
& "FROM tblRawData " _
& "WHERE (((tblRawData.Mon)='" & cboMonth.Value & "') AND ((tblRawData.Role)='FTS'));"

I apologize for the way the SQL comes a... Read more

A:Access query help

Read other 9 answers
RELEVANCY SCORE 62

Hello,

I have returned with another MS Access issue. I have 2 Tables that have "Last Names" as a link (it's also the key in all tables). There are several rows in each table that list different tasks that are selected by yes/no. I want to make a query that can tell me what percentage is complete for Table 1 and Table 2 for Joe Smith or any other specific name. Then I want to make a query that can tell me the percentage of all individuals listed (i.e. all 20 people on the list and their individual percentage of each table that is completed). In the end I'm trying to be able to show this as a report.

Please help this newb.
-Garthras
 

A:MS Access Query Help

Hello again. Your tables should be linked via the KeyID field rather than a name, because it is possible to have 2 people with the same name.
I would need a copy of your tables with some dummy data in to create the Query(s) for you.
 

Read other 1 answers
RELEVANCY SCORE 62

I was wondering if someone could help me out with some queries in Access.

I have developped a database with the following tables.

Students - which have the students name, faculty and status (full time/part-time)
Courses - which list all the courses that a student can take
Registration - the courses that the student is registered in and the cost per course as well as if the student has paid or not.

I need to do the following 2 queries and I need a bit of help with them.

1. I need to construct a query that will return the average marks of students by faculty and status (full time/part time)

2. I need to construct a query that returns the total money paid to date by students sorted by faculty and status.

Can anyone give me a hand?
 

A:Access Query Help

Read other 8 answers
RELEVANCY SCORE 62

Hi, Just trying to make a database in Access that'll allow the user to run a query and find out all records that are 10 years or older i.e. a piece of equipment that was last serviced in May 1997 requires servicing and once that was done in november 2005 doesn't. Also, is it possible to write a line into another query that will bring up items that are nearing the replacement date? Sorry if this is simple, but i've lost track of access and forgotten it since I left college!

Dan

A:Access Query Help

In the query design view, select the fields you want to see.Under the first four lines are rows for multiple selection criteria.Just as a quick way to get you started,under a date you can enter things such as ">=Now()-7" to get records for the last week."<=Now()-364.25*2" will return records roughly over 2 years old or if you're fancy, ask the user to enter the date using 'parameters' (I'd give it to you, but am running out of time Don't use quotes.Date functions can be tricky, but if you double click the entries, Access helps with syntax.You can combine (AND) one criterion with another by writing them one above another.And if I recall, OR needs to go across, so may have to pull the field names twice.See Help for 'parameters' and 'selection criteria' and examples Access offers.

Read other 1 answers
RELEVANCY SCORE 62

Hello All,

I am having a very difficult time creating an access query to filter specific data. I am looking to create a query to filter out a latest date for customers.

For example:

Current Table Data
FName LName Company CallInDate
Jane Doe Carp 10/02/2003
Jane Doe Carp 10/05/2003
John Doe Carp 10/02/2003
John Doe Carp 10/05/2003

I would expect my query results to display the latest CallInDate specifically for each customer name, even if they are in the same company.

Expected Query Results
Jane Doe Carp 10/05/2003
John Doe Carp 10/05/2003

I am not skilled in expressions, operators, etc. so I have not been successful. Is this possible to do?

Any suggestions are appreciated.
 

A:Access Query

Read other 8 answers
RELEVANCY SCORE 62

I have asked this question before but never got an answer I understood. Could someone please tell me how to put a value from a query into a text box in a form. I no one can tell me can someone tell me where to go to get this information. I am willing to pay for it.

P.S. I am just learning MS Acess so please explain as simple as possible.

thanx
 

A:MS Access query

Read other 16 answers
RELEVANCY SCORE 62

i have 2 tables
Closed
1 hi
1 now
2 told ya
2 fine

Request
1 tmnow
1 tmhi
2 tmtrythis

i need to have them combined by the number but the issue is they could have 1 line of different data or 10
1 hi now tmnow tmhi
2 toldya fine tmtrythis

I am not the best with coding any help would be appreciated.
 

A:access query

Read other 16 answers
RELEVANCY SCORE 62

I have a field "date of Hire"
How do I add 1 year from this date
 

A:access query

Following is from the help for the "DateAdd" function:

<BLOCKQUOTE><font size="1" face="Verdana, Arial">quote:</font><HR>
The DateAdd function won't return an invalid date. The following example adds one month to January 31:

DateAdd("m", 1, "31-Jan-95")
<HR></BLOCKQUOTE>

I would check that out, but it appears as though the following will work:

DateAdd("y", 1, date_of_hire)

where "date_of_hire" is the name of the field that contains the hire date.

[This message has been edited by Mulder (edited 01-27-2001).]
 

Read other 1 answers
RELEVANCY SCORE 62

Can some on tell me how to put a value from a query into a text box in a form.

thanx
 

A:MS Access query

Make an unbound text box and set up an onClick event for a button to put the contents of that textbox into a query.
 

Read other 2 answers
RELEVANCY SCORE 62

Right ive got two queries

QryArchiveFaultReportTime: CountOfFaultReportID, Time Period
QryArchivePerishReportTime: CountOfPerishableReprotID, Time Period

The fields involved are not linked by relationship.

In both cases Time Period is a calculation of a date:
Time Period: "Year: " & Year([Date Reported]) & " Month: " & Month([Date Reported])

So 02/04/07 (dd/mm/yy) would give "Year: 2007 Month: 4"

What i want to do is merge the queries so that i have the fields Time Period, CountOfFaultReportID and CountOfPerishableReprotID in the same query.

BUT because there are some time periods that exist in one but not in the other there are problems.

Whenever i try to run a query made from these other two queries i either get repeated values for one or a lack of values for the other. ie 1=Without relationship between Time Periods 2= With relationship
 

A:Access Query

Read other 8 answers
RELEVANCY SCORE 62

I have a query that when I click on it, it asks what vendor I would like to look up, I have about 25 vendors, and if I don't type the name exact,then it will not bring up the correct data. Is there any way to create a drop down box on my main menu and then when I click on the vendor from that it takes me to that data?
 

A:access query

Like this?

http://www.theofficeexperts.com/access.htm#SearchForm
 

Read other 3 answers
RELEVANCY SCORE 62

I have 4 queries that return data in quarters of the year. How do I get these 4 queries into one report with Type of Procedure as the Row and 4 column headings as Qrt 1 Qrt 2 Qrt 3 Qrt 4?
 

A:Access Query

Normally you would use one query filtered with datepart rather than 4, but either way, I guess you could get the data into columns with dlookup or even dsum. Not very elegant, but while I did not test it, I think it should work.
 

Read other 2 answers
RELEVANCY SCORE 62

Can anyone help with an access 97 query?

What we have is basically a card index system set up with access 97 and
we wish to insert a link frrom one card to another.

EG have a box on each card called relations and names of people in that
box and when you click on a name it brings up that persons card.

Can this be done? If so then how?

Thank You

PikaPikaDude
 

A:Can anyone help with an access 97 query?

Not sure, exactly, but why don't you look up how to create subforms.

Your main form would have the card.

Subform would have related card selected.
 

Read other 1 answers
RELEVANCY SCORE 62

Hi guys,

I have a column in an access table that contains 3000 records all containing a string of characters. The problem I have is I would like to change just one character from the string in each record. Does anybody know how this might be done?

Example:

Column

X Z Z Z X Z Z X Z

X X Z Z Z X Z X Z

Z Z Z X X Z Z X Z

.....

.....

(I would like to run a query that changes the X in each column to a Z)
 

A:Access Query?

Create an expression:

=left(fieldname,7)&"z"&right(fieldname,1)
That should grab the first 7 characters from the left, put a z, then add the first character from the right.
 

Read other 1 answers
RELEVANCY SCORE 62

This is driving me CRAZY. I have a simple select query: retrieve all records with an entry date from 1/1/02 (for instance) to 1/31/02 -- i.e., just the records for that month.

The query retrieves all records EXCEPT those dated 1/31/02. However, if the parameters are 1/1/02 to 2/1/02, I get all records AND 2/1/02 (which I don't really want). This makes no sense to me.

How can I define the parameters to get just the dates I want, inclusive of the last date?
 

A:Access 97 query

Read other 12 answers