Recent content by obuspider

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

Thanks. I thought that might be the case

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

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

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...

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

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...

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...

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...

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

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

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...

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...

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...

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?