Search results

Thanks to everyone for their collective assistance. I haven't got even 5 minutes to give this a try today but I'll report back on my progress. Thanks again!

I'm hoping someone can help me figure out a problem I need to solve. At our company, plans are reviewed every 3 years after a plan is created, i.e. a plan created in 2011 would be reviewed in 2014. Most plans were created in either 2010, 2011, or 2012 however new plans can be created, albeit...

That's exactly what I needed - thanks missinglinq! :) I'll be sure to keep this little sample handy in future! Thanks too Brian for your assistance - it was reassuring to know I was close!

Thanks for the input Brian, but if I run two separate DLookups, doesn't that create the situation where I am checking to see if there is already a First Name of "John", and then I am checking (separately) to see if there is already a First Name of "Smith"? I don't care if there is already a...

I'm trying to figure out a problem I'm having with DLookup, and I think I've hit the limit of my abilities. I've created a form (frmMain) that is used to enter student records. What I'm wanting to do is to check if a student already exists in the database. Rather than wait until the whole...

I need to join two tables, TableA and TableB. These were originally Excel spreadsheets which are being converted to Access for some data massaging, and then going back to Excel. TableA has fields: Stock_Item, Price, Description, etc. With sample data: Q00001, 10.00, Blue Ball Q00002, 15.00...

Thanks! I'll have a look and see what I can find.

This is either very simple or very complex, I haven't figured out which yet. I need to know the number of tables in my database and from each table I need to know how many records are in each table. Ordinarily I would just count the number of tables then open each one up to get the number of...

Not sure if this is a Table question, a General question or what exactly. I'm working with a lot of records (millions of them). Assuming each record/field contains identical data, I'm wondering which would result in a larger overall DB size: - 10 million records, 4 fields each - 30 million...

THAT'S PERFECT!!! :) Thanks so much - that produced exactly the kind of data I was needing! I appreciate that so much!!!

The table name is Analysis. All of the fields are text strings. (I simplified my example but the data in each field is alphanumeric.) Thanks EMP!

I have a table that I need to query that looks something like this: ID Type Product ID 123 Health 323 123 Health 424 123 Dental 424 124 Health 323 125 Dental 323 What I need to see is something like this: ID Type Product ID 123...

I must be missing something or doing something wrong - I'm not getting any results back. Here's what I have: SELECT Plan, Item, Price, Description, Colour, Value, Warn1, Warn2, Count(Warn2) AS Expr1 FROM Main GROUP BY Plan, Item, Price, Description, Colour, Value, Warn1, Warn2 HAVING...

Not sure if what I want to do is possible, or at least possible the way things are set up. I have a massive table - c. 6 million rows. It contains data along these lines: Plan#, Item, Price, Description, Colour, Value, Location, etc. The primary key would be Plan# + Item. Each Plan# has...

To clarify, the data wasn't in a CSV file, but instead imported via fixed width ASCII import. I didn't lose any data - it never existed in the report I was working with. The data I'm using is from a mainframe dataset. The report was formatted in a way what I suspect was a "Group By"...

My fault - I should have been more clear in what I needed! The problem is that wherever a value is repeated in the next row, the value is omitted. So what I want is to have the data that was left blank to be filled with the appropriate value from above. So in the above example: CodeID Group...

I have a question and I'll apologize in advance because it may or may not really be an Access question. I have a large ASCII spreadsheet that I have imported into Access. It has 4 columns, and has these headings: CodeID, Group, Division, Account. Many Division and Account combinations can...

I agree, Ken, the starting table isn't in a nice format, but that is what I was given to work with. If there is a way to get the data into a better format which then makes the solution to my problem that much easier, by all means I'd appreciate the guidance. I suppose I could always...

I have a table set up like this: Client,ServiceDate,Service1,Service2...Service7,Msg01,Msg02...Msg20 The Service fields may or may not have values under each, depending on the number of services performed for the client, and they are always entered consecutively (i.e. Service1 will always have...

This is either quite simple or quite difficult, but I'm at a loss to figure out which! I have a simple table with 4 fields. A simple example with sample data: FIELD1,FIELD2, FIELD3, FIELD4 Brazil, Dog, Fido, 12 years Brazil, Cat, Boots, 3 years Brazil, Cat, Socks, 5 years Canada, Cat, Boots...