Search results

I have all the queries... I just don't know how to create the forms and the report to do what i need to do... I have forms and reports but I don't know how to get it to do what I need to do. Please give me more specific guidance as to get the commands right on the form/report...

yes... more guidance please... I'm a bit lost there.

Hi, I apologize ahead if I am posting this in the wrong area. It has been awhile since I've done anything with form/report in MS Access. I am seeking guidance on how to do this effectively and efficiently. What I'm trying to do is build a database that would generate a report for each...

Hi Yall. I have this long text string: 09 Apr 2010 02:22:32 [] - Ambiguity limit of 32 paths exceeded. Apparent culprits: [a_container_type], [a_item_name]. (Line is: Ointment Vitamin A & D Ointment 1 Pound Jar)\line I want to get everything to the right of "Apparent culprits:" How do I do...

I'm using both. I don't know how to do this in Access either.

Thanks! It works!

I have a field with data and I want to take what's left of a comma to a different column. How should I write this formula? Example: band, the => band Thanks

I have a field with data and I want to take what's left of a comma to a different column. How should I write this formula? Example: band, the => band Thanks

Ah. That makes sense. Thank you.

Thank you!! That works wonderfully! One additional question, how do I order desc for column count?

hi i'm trying to do a distinct count of [SUM] but using the group by is not producing correct data. SELECT [Sum GT 2].[MFG], [Sum GT 2].[MFG_CODE], Count([Sum GT 2].[SUM]) AS [Count] FROM [Sum GT 2] GROUP BY [Sum GT 2].[MFG], [Sum GT 2].[MFG_CODE]; how can i rewrite this to give me a distinct...

Do you know a better way to convert Julian dates to include where the data is 0 or null? Thanks

I have 2 columns that have 2 set of different numbers. But column one has column 2's data also. how can i identify them and delete them from the table. for example; column 1 column 2 12345 67891 67891 12345 I want to identify the conbinnation of [67891 12345] which is a...

Thank you!! This forum has always been a great resource for me!!

How to I do a query to match numbers but exclude the leading zeros? I have 2 tables that i'm doing an equal join to. The 2nd table has leading zero to the numbers so it's making it difficult for me to find any matches. ex table 1 table 2 12345 012345 But not all numbers on...

I'm not sure how to verify this. Where is this located?

I'm linking a new table and received this error. Does anyone know how to fixed this? ODBC -- call failed. [Oracle][ODBC][ORA-00932: inconsistent datatypes:expected %s got %s (#932) Thanks.

Thank you that works.

hi i have a database with multiple date entry of the same record id. how do i write a query so that it pulls up just the last date value? thanks