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 Chriss Miller 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. obuspider

    Deleting duplicate records

    JamesLean, You are right. Unfortunately, I'm working off a db that was created and is maintained by someone else.
  2. obuspider

    Deleting duplicate records

    Thanks. I thought that might be the case
  3. obuspider

    Deleting duplicate records

    I just discovered to records in my sql db that are duplicates. I need to delete them, but apparently have the wrong syntax. Can someone help? The records look like the following site overp 003 1
  4. obuspider

    one table or two tables to contain information?

    Thanks for the help. I'm working on it and will let you know.
  5. obuspider

    one table or two tables to contain information?

    Free, Paid and reduced are just numbers--types of meals. I'd be pulling them all at the same time. The meal types are breakfast and lunch. The equiv and s equiv are related types of meals, but are not broken down into breakfast and lunch. I'm thinking because they are not broken down, I...
  6. obuspider

    one table or two tables to contain information?

    Hey. Thanks for the help. Not sure what to tell you except that it would be helpful to be able to access it all from the same table. The report I need to generate will look something like follows grouped by date. Hopefully this helps. b free|B Paid|B red.|l free|l paid|l red.|equiv|sequiv
  7. obuspider

    one table or two tables to contain information?

    MeanGreen, Thanks for the input. I think it would help if I could put them in the same table. Is the following how you would do it though? The last two columns are the ones not broken out by meal type date meal_type free reduced paid equiv sequiv 1/1/03 breakfast 378...
  8. obuspider

    one table or two tables to contain information?

    MeanGreen, Thanks for the input. I think it would help if I could put them in the same table. Is the following how you would do it though? The last two columns are the ones not broken out by meal type date meal_type free reduced paid equiv sequiv 1/1/03 breakfast 378...
  9. obuspider

    one table or two tables to contain information?

    I need to create a table in a db for historical data. Most of this data is broken up by meal type so I would have the following fields; date,meal type, free, reduced, paid. However, I have two other numbers that are not broken down by meal type. Is it better to create a separate table for...
  10. obuspider

    formula for determining current school year?

    Thanks for all your help. I knew there had to be any easier way.
  11. obuspider

    last day of month

    Is There a way to easily determine the last day of the month?
  12. obuspider

    formula for determining current school year?

    mbarron, thanks for the info. This is assuming that I have a specific date range. What if I want the date where you have 2002,8,1 to be dynamic and change with each year. I need to determine if the current month is in the fall. If it is, then the year for the fall sem is the current year...
  13. obuspider

    formula for determining current school year?

    I'm trying to create a formuala that would determine the current school year which runs from August to May. Right now, I have it set up as a formula to determine the fall, and another to determine the spring, however, it isn't working. Any ideas? This is what I have right now If...
  14. obuspider

    Moving an Excel Spreadsheet over to Crystal

    I have a fairly complicated Excel spreadsheet that I need to move to Crystal Reports so info is recieved dynamically from a db. The following is a basic idea of what it needs to look like. The easy part is grouping by month and year to get the actuals. Is there a way to add the forecast info...
  15. obuspider

    grouping by year(date)?

    I need to group my recordset by year(date). I created a formula to isolate the year, but when I group based on that formula, it changes my date to a number with a decimal. Is there a better way to do this or to fix my problem?
  16. obuspider

    joining and summing two recordsets into one

    rac2, Thanks. It didn't quite work right, but I think I have it now.
  17. obuspider

    joining and summing two recordsets into one

    Okay, I did manage to get the following to work. Is there a way to write it so that when the recordset comes up, it doesn't list two site colums though? Select * from (Select schools.site, schools.area, schcat, schoolName, sum(d_tot_meals) as 'total meals' From schools, tbl_scanned_sales...
  18. obuspider

    joining and summing two recordsets into one

    I have two separate queries that I need to somehow combine into one recordset. I actually need to sum the total meals and the total working hours. however, the first query yields 37 records while the other only yields 2. How can I combine the two so that I get one recordset with the total...
  19. obuspider

    passing information through formulas

    The following code is used to pass from and to dates to Crystal Reports through an ASP page. Can anyone tell me if there is a way to modify this or my Crystal report so that I can pass a text string instead of a date? set session("f")=session("orpt").formulafields set...
  20. obuspider

    ASP page for displaying db metadata and table names

    Tarwn, Thanks for your post. They will give me an account and password for connection. They even have an asp app that they had running on a previous server until they moved to a new server, but now they are saying we just need to create our own since they don't want us having that kind of...

Part and Inventory Search

Back
Top