Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. AutumnBlues

    Union query produces same results after changing WHERE

    ...name1], [mailing address1], [mailing address2], [mailing city], [mailing state], [mailing zip5] FROM LOCATION WHERE [location name1] like "dick*" and [location name1] like"*sporting*"; UNION SELECT [company], [address1], [address2], [city], [state], [zip] FROM sheet1 ORDER...
  2. AutumnBlues

    how do a retrieve only select records?

    Try it like this... select [UNIT NUMBER], [DATE OF MAINTENANCE], [MILAGE] from (select [AUTO MAINTENANCE].[UNIT NUMBER] as TopUnit, Max([AUTO MAINTENANCE].[DATE OF MAINTENANCE]) as TopDate from [AUTO MAINTENANCE] group by [AUTO MAINTENANCE].[UNIT NUMBER]) AS Tops inner join [AUTO MAINTENANCE]...
  3. AutumnBlues

    how do a retrieve only select records?

    Sorry, I screwed up. Try this instead... --------------- select [UNIT NUMBER], [DATE OF MAINTENANCE], [HOURS] from (select [UNIT NUMBER] as TopUnit, Max([DATE OF MAINTENANCE]) as TopDate from [LIFT TRUCK MAINTENANCE] group by [UNIT NUMBER]) AS Tops inner join [LIFT TRUCK MAINTENANCE] on...
  4. AutumnBlues

    how do a retrieve only select records?

    It's not as difficult as it might look. All you need to do is start a new query as normal, but don't add any tables in design view. Move across to the SQL window and then paste in the above SQL statement. Where it says 'YourTable' in the SQL, type in the name of your table (if your table name...
  5. AutumnBlues

    how do a retrieve only select records?

    Paste this into the SQL window and save it. Then base your report on the new query. (You'll need to change YourTable to your table, and UnitNumber, Date, Miles to match your fields) ----------- select UnitNumber, date, Miles from (select UnitNumber as TopUnit, Max(date) as TopDate from...
  6. AutumnBlues

    Hello, I am using MS Access 2000

    I understand that the listbox is populated automatically, but, normally, no item within the listbox would be selected until the user clicks something in there. So if no item is selected in the populated listbox, the textbox should be empty. And it should remain empty until such a time as a...
  7. AutumnBlues

    Hello, I am using MS Access 2000

    Not sure I'm with you, but if I am... Wouldn't it be better to clear the textbox on open, so when you open the form, nothing is selected in the list box (as happens anyway) and nothing is selected in the text box? If not, then I guess the way you'd do it would be: In the Open Event, select...
  8. AutumnBlues

    =IIf EXPRESSION - ERROR

    Code seems to work fine. What's supposed to happen when the score is 1?
  9. AutumnBlues

    Autonumber Anger

    There may be a few dirty records in there. Try copying the table (data-definition only) and starting again. If that doesn't work you might want to try (you might want to do this anyway) changing the autonumber field to a regular number field and setting up a function that gives you the next...
  10. AutumnBlues

    Autonumber Anger

    Have you got New values set to 'Increment'?
  11. AutumnBlues

    How do use the inputbox to search through a table to find a record?

    ...is a diferent kettle of fish. That runs an action query. So if you want to delete everything in a table, you'd type... DoCmd.RunSQL "delete * from myTable" OR Dim strSQL as string strSQL = "delete * from myTable" DoCmd.RunSQL strSQL The DCount function is a bit...
  12. AutumnBlues

    How to COMBINE data in rows using query?

    SNAP! (ish)
  13. AutumnBlues

    How to COMBINE data in rows using query?

    Paste this into the SQL window and then flip back to QBE(you'll first need to change the table name to fit) SELECT First(Person) AS Person99, GroupID, Sum(Sales) AS SumOfSales FROM Table1 GROUP BY GroupID;
  14. AutumnBlues

    How do use the inputbox to search through a table to find a record?

    Here's the idea you want; you'll need to tart it up a bit though. -------- Sub Whatever() Dim x as integer Dim strSQL as string Dim dB as Database Dim Rec as Recordset x = InputBox("Enter Number") strSQL = "select count(ProjectNumber) from ProjectList where ProjectNumber =...
  15. AutumnBlues

    no current records - query code definition.

    with rst if .recordcount = 0 then ' whatever.... end with
  16. AutumnBlues

    Looking for professional advice

    Hi there, From experience (from which I've since moved on)... The first thing you've got to accept is that there are going to be things that need fixing - maybe lots of things. Proper testing of your dB depends upon your ability to manage the process fault finding and subsequent fault...
  17. AutumnBlues

    Verify against a table push a msgbox and open form

    Hi Unless I'm missing something, it just sounds like regular run of the mill dB stuff. Something like this should do the job -------- Sub Whatever() Dim intColor as integer Dim strSQL as string Dim dB as Database Dim Rec as Recordset intColor = txtColor strSQL = "Select...
  18. AutumnBlues

    Verify against a table push a msgbox and open form

    Hi Unless I'm missing something, it just sounds like regular run of the mill dB stuff. Something like this should do the job -------- Sub Whatever() Dim intColor as integer Dim strSQL as string Dim dB as Database Dim Rec as Recordset intColor = txtColor strSQL = "Select...
  19. AutumnBlues

    Sum query

    Sabavno Here's the SQL, you just need to change the table name (assuming you have a Yes/No field type rather than text that says 'yes' or 'no')... ------------------- SELECT Transit, Sum(IIf([USRoaming]=True,120,100)) AS Charges FROM tblExample GROUP BY Transit; ------------------- I'll just...
  20. AutumnBlues

    Count checked Check Boxes on a report

    If you can't receive opposing ideas without becoming over-emotional, you shouldn't enter into debate. Sneering comments are not appreciated - others have expressed the same opinion. Quit talking down to people, lose the arrogant tone and lighten up. AutumnBlues

Part and Inventory Search

Back
Top