2 Queries And A Form, Please Assist
Aug 24, 2006
This is probably more easier than my brain is allowing it to be. I have 2 queries
AccountsClosedToday_qry
SELECT UCase(Users.UserName) AS Associate, Count(Information_tbl.IsActive) AS [Closed Today]
FROM Information_tbl INNER JOIN Users ON Information_tbl.Associate = Users.UserID
GROUP BY Users.UserName, Information_tbl.ClosedDate
HAVING (((Count(Information_tbl.IsActive))=True) AND ((Information_tbl.ClosedDate)=Date()));
AccountsClosedTotal_qry
SELECT UCase(Users.UserName) AS Associate, Count(Information_tbl.ClosedDate) AS [Total Closed]
FROM Information_tbl INNER JOIN Users ON Information_tbl.Associate = Users.UserID
GROUP BY Users.UserName, Information_tbl.IsActive
HAVING (((Information_tbl.IsActive)=True))
ORDER BY Count(Information_tbl.ClosedDate) DESC;
I am wanting to get the results from 'Closed Today' and 'Total Closed' onto one form. I am thinking I may have to create a table and have this information either go through an append or an update query each time the database is loaded, I am sure there is a better way of this which is why I am posting here. Thanks.
View Replies
ADVERTISEMENT
Jan 2, 2006
I have a form that pulls data from a table. Basically the form is just a postcard. I have our company name, address, PO Box, city, state and zip in the upper left corner. My fields in the center of the postcard tie back to a table that contains the contact companies name, street address, PO Box, city, state and zip. My question is this: How do you format the contact company, address, PO Box, city, state and zip so that it appears uniform when printed? Some of the contact companies will have a street address but not a PO Box. How can I have the form print so the PO Box does not leave that field blank and pulls up the city, state and zip into that empty space? Also if one company's city is shorter than another how can it be formatted to pull over the state to make it uniform?
Any help on this would be greatly appreciated. I am under heavy deadline to have this form corrected and working by the end of the week.
Thanks in advance,
cnut1
Attempted to add the database but it would not upload for some reason. Will try again tomorrow. I am sure the way I am doing some things are not necessarily the best or easiest way since I am still learning Access. The form I am looking for help on is frmpostcardJanfrt.
View 3 Replies
View Related
Jan 2, 2007
I made a database for models witch uses a controller. open the picture ballow to understand my problem better.
15939
The problem i have is that i want when focus is on one of the bleu balls a small discription come in the box show in the picture. i tried usig a label and a caption code but this isn't working. If anyone i able to solve this problem i would be very tankfull.
greetz
View 2 Replies
View Related
Nov 11, 2005
I am trying to figure out how to have a field work like the auto number (automatically fill in the next number) but I need it use a prefix that doesn't change. IE: IN82806*** with the *** being the auto fill numbers. I have read that I can make a macro to do this, but have been unable to figure out how. Any assistance would be greatly appreciated.
View 1 Replies
View Related
Aug 15, 2013
I have a database from sharepoint which has 250 fields based on a survey. I imported the database into Access where I made 10 queries.
I want to know is there a way to display those 10 queries in one queries or in one form.
Given that some queries has result to display and others haven't yet.
View 4 Replies
View Related
Aug 8, 2013
I am trying to determine the best method for linking back to a form from Queries.I have a Form that has info filled out for customer service calls that come in. Among which is a case#. From the Log of information stored from these forms queries have been made to organize the info in different ways; all of which have the case#. What I am trying to do is that in looking at a the queries I want them to be able to click on a case number and be transferred to the appropriate form. This way they can update the form as the case progresses.I am trying to improve upon what was created by another.
View 1 Replies
View Related
Aug 17, 2006
Hi All,
I want to create a form with a Command button, when we click on the command button it needs to bring the Query from a particular mdb, the path for this mdb will vary so we should be able to provide the path info, after bringing the query it needs to be run, how do I do this by just clicking couple of Command buttons?
Thanks
View 2 Replies
View Related
Mar 28, 2013
I have a query that retrieves one of its criteria from a form. I have referenced correctly the value on the form from the query, and it works, but what I wanted to do is a bit more complicated: when the form is closed, I want to launch the query with a "default value". I tried to do it in 2 different ways:
a) Defining an "IIf" at the query criteria: I would need a function that checks if the form from which I retrieve the values is open.
b) Defining public variables with a default value, which would be changed from the form: I don't know where/when to initialize the value of the variable.
Query gets criteria from form when it's open. If form is closed, query uses default value.
View 1 Replies
View Related
Sep 8, 2005
Hi this advice was give to me however i am not sure how to develop the needed queries
"Yes, you should be able to do this in Excel. What I would do if I were doing it, is develop queries that fetch just John's data from each of the tables that contain it. Then I would export each query to the same Excel worksheet and assign a range name to each different portion of the data. This is so that I could import from Excel back to Access as easily as possible. Then send it to John via Email, or however. When it comes back, I would spend a bit of time vetting it and, if all was OK, then import each different range of cells into the appropriate table."
thanks.
bb
View 1 Replies
View Related
Mar 11, 2005
hi,
i have a Main form with 2 command buttons on it, cmdOld & cmdCurrent
can i assign in One Form's Record Source 2 Queries? not at the same time for sure...let me give the correct figure
i have a Main form with 2 command buttons on it, cmdOld & cmdCurrent
when i click cmdOld i will load a Form with record source qry_old,
when i click cmdCurrent i will load the same Form with record source qry_Current,
is this possible, if yes what is the coding of it please
thank you
View 1 Replies
View Related
Apr 17, 2005
Is there a way to add a parameter query question into a form?
So for example, I could have this in my form ::
What is your second name? [________] SEARCH
And then when someone types something in the blank space and clicks
"SEARCH", it will add it into the query's search criteria?
View 6 Replies
View Related
Jul 2, 2005
If you open the attached db and then run the frm 'frmEnterTimeSheets' you will be presented with a text box asking for a name. Type in Alldridge and click the add work time button. You will now be presented with a list box.
Now what I want to happen next is for the user to select one of the names and then be able to input some time against that user. However after you select the name you want to add times against, the time entry form has a clientID of 0 (there are only IDs of 4 and 8 as shown inthe list box).
I would like to see is the first and last name of the client (concatenated together).
View 1 Replies
View Related
Jan 11, 2006
Hey guys;
What I'm looking to do is setup up an invoicing-type system. I want to create a form wherein there will be several list/combo boxes to select various parameter (ie. product id, accessories, materials etc). As well on this form I want to put a "submit" button that will open up a report which will have the information from the various inputs(such as a breakdown of costs and such). I think I can figure the button bit on my own, but I was wondering how I would go about utilizing the boxes. I tried using a parameter-type query but this opens a dialogue box when the form is opened which I don't want. I want the selections to be stored until the submit button is pressed.
Any suggestions on how I might be able to accomplish this?
Thanks in advance
View 14 Replies
View Related
Jan 11, 2006
Sorry about the double thread posting, please look at the other thread with the same name.
Thanks in advance for the help
View 4 Replies
View Related
Apr 4, 2006
I have a form where I want the user to be able to select different options and get appropriate results according to the selectin.
Now I have already created the query I am just wondering how to I connect the Form to the query so that when the user selects what he wants to see and the query will pop up.
Or is my idea wrong on how to use form to see results from a query ?
regards
Frodo
View 3 Replies
View Related
Jul 10, 2006
I'm stuck trying to figure out how to update a query I have already saved. Here's my situation, I have already created a query called "REPORT_STMT_Breakout" and I want to be able to change this query based upon some date variables on a form. I'm using this query to create a pivot table. I can create the basic query, but I cannot figure out how to modify the saved query to accommodate the variables. Any help would be appreciated.
Here's the current query SQL:
SELECT PARENT, TYPE, SUM(TOTAL) AS COMBINED
FROM [
SELECT
tblStmt_Tracking.Parent_Carrier_Name AS PARENT,
'1. IND_Amount' as TYPE,
IND_Amount AS TOTAL
FROM
tblStmt_Tracking INNER JOIN tblCheck_Log ON tblStmt_Tracking.Check_Assignment_ID = tblCheck_Log.Check_Assignment_ID
UNION
SELECT
tblStmt_Tracking.Parent_Carrier_Name AS PARENT,
'2. SBG_Amount' as TYPE,
SBG_Amount AS TOTAL
FROM
tblStmt_Tracking INNER JOIN tblCheck_Log ON tblStmt_Tracking.Check_Assignment_ID = tblCheck_Log.Check_Assignment_ID
UNION
SELECT
tblStmt_Tracking.Parent_Carrier_Name AS PARENT,
'3. IND_Bonus_Amount' as TYPE,
IND_Bonus_Amount AS TOTAL
FROM
tblStmt_Tracking INNER JOIN tblCheck_Log ON tblStmt_Tracking.Check_Assignment_ID = tblCheck_Log.Check_Assignment_ID
UNION
SELECT
tblStmt_Tracking.Parent_Carrier_Name AS PARENT,
'4. SBG_Bonus_Amount' as TYPE,
SBG_Bonus_Amount AS TOTAL
FROM
tblStmt_Tracking INNER JOIN tblCheck_Log ON tblStmt_Tracking.Check_Assignment_ID = tblCheck_Log.Check_Assignment_ID
UNION
SELECT
tblStmt_Tracking.Parent_Carrier_Name AS PARENT,
'5. Licensing Fees' as TYPE,
Licensing_Fees AS TOTAL
FROM
tblStmt_Tracking INNER JOIN tblCheck_Log ON tblStmt_Tracking.Check_Assignment_ID = tblCheck_Log.Check_Assignment_ID
UNION
SELECT
tblStmt_Tracking.Parent_Carrier_Name AS PARENT,
'6. IND Misc Expenses' as TYPE,
IND_Misc_Expenses AS TOTAL
FROM
tblStmt_Tracking INNER JOIN tblCheck_Log ON tblStmt_Tracking.Check_Assignment_ID = tblCheck_Log.Check_Assignment_ID
UNION
SELECT
tblStmt_Tracking.Parent_Carrier_Name AS PARENT,
'7. SBG Misc Expenses' as TYPE,
SBG_Misc_Expenses AS TOTAL
FROM
tblStmt_Tracking INNER JOIN tblCheck_Log ON tblStmt_Tracking.Check_Assignment_ID = tblCheck_Log.Check_Assignment_ID
UNION
SELECT
tblStmt_Tracking.Parent_Carrier_Name AS PARENT,
'8. Other Receivables' as TYPE,
Other_Receivables AS TOTAL
FROM
tblStmt_Tracking INNER JOIN tblCheck_Log ON tblStmt_Tracking.Check_Assignment_ID = tblCheck_Log.Check_Assignment_ID
UNION
SELECT
tblStmt_Tracking.Parent_Carrier_Name AS PARENT,
'9. Unknown_Amount' as TYPE,
Unknown_Amount AS TOTAL
FROM
tblStmt_Tracking INNER JOIN tblCheck_Log ON tblStmt_Tracking.Check_Assignment_ID = tblCheck_Log.Check_Assignment_ID
]. AS BREAKOUT
GROUP BY PARENT, TYPE
ORDER BY PARENT, TYPE;
I plan on adding date variables to this query.
View 1 Replies
View Related
Nov 14, 2005
If its possible, can i have a querie that lets the user find a specific record, say based on flight number or flight date (for an airport) right from the switchboard?,
I can do this within the main form, but ir returns the table view of the record, which i dont want, i would like the form view of it? This possible
Thanks
View 4 Replies
View Related
Oct 25, 2006
Hi,
I want to have some queries run during the database is closed, like the functiona with "Repair on Close". But I don't want to use a form with a VBA code doing it. Is there any other possibility to do it? :confused:
Thanks in advance for answers.:)
View 14 Replies
View Related
Sep 18, 2006
:confused: G'day, can anyone tell me how to quickly create form based queries using the design view interface. I want my users to be able to specify the various criterias using drop down menus. :confused:
View 1 Replies
View Related
Feb 2, 2005
Hi, I was wondering if it's possible to use one form to display the results of different queries.
I have a form to make a booking, an identical form to display booking search results and another identical form to display today's bookings.
When I update the database, I make identical changes to all 3 forms. Is there a way of displaying results in one single form?
Thanks,
Rich.
View 3 Replies
View Related
Oct 6, 2004
I have a report with the same subreport appearing twice. The two instances of this subreport have different queries.
For instance boys and girls information. The only difference is the queries (one would have sex=M the other sex = F)
Is there any way of doing this without copying the subreport and giving it another name (this of course would allow me to assign different queries to each subreport).
Thanks
View 3 Replies
View Related
Dec 16, 2004
In theory this would work, but I'm not sure how to implement it.
I have a table with several fields (10) and I would like to create a form that would allow a user to search by entering in as much information as they know. So, they may only know a date and a location, but not anything for the other 8 fields.
Is there a simple way to do this in Access? I'm having issues when the search field is left blank in the form.
Thanks in advance!
View 4 Replies
View Related
Aug 14, 2013
I am driving a query through a form and everything works fine....except when the first letter of the field is the same..
So here is my criteria...Like [Forms]![frm_Delinquency By Tier]![Tier/Program] & "*"
I only want the results if the Tier/Program matches what I have selected. If I select B for example, it returns the results for B and anything else in that field that starts with B. I have a Business Tier/Program and so I get results for both B and Business.
My question is, how to set the criteria up so that I only get B when I select B and not anything that starts with that letter.
View 3 Replies
View Related
Feb 28, 2014
Is there anyway to enable a query that pulls up just the basic information from a table and then click on the primary key field to open up a form I have created that contains all the information in a table in a more user friendly form that I created.
The two images attached show the data sheet results of a simple query. I'd like to be able to click on the JT# for each record (i.e. 201400426838) in the data sheet (query result1.jpg) and have it automatically open the form as shown in (resulting form.jpg).
View 1 Replies
View Related
Jun 18, 2015
I have a form that is basically just a matrix/visual of a query. Is there a way to "toggle" between the use of queries/data?
i.e. have a drop down and select query, "SH-LS", "FPH-ENV" or "FPH-Asset" and it will show the corresponding data. The queries are all set up the same, just gathers/calculates different criteria.
View 7 Replies
View Related
Mar 23, 2006
Good Afternoon,
I am trying to create a form where a user will enter in a value into a text field. Afterwards, when the user clicks "Enter", a query will run and will LOOK FOR THE VALUE THAT WAS ENTERED INTO THE TEXT FIELD. i.e.
User enters their address into the field and clicks the enter button.
Afterwards, a query will run like
select * from customers where address = @address <== the value the user entered into the text field. This is where the mystery lies. How do you pass values?????
Thanks,
Nervous Jervous
View 6 Replies
View Related