Search results

Thanks all, I seems to have managed to work something out. I just did a collumn down and displayed all the inputs based on the ID fields. It looks okay. I would had like to display them horizontally but this will do. Thanks all.

hmm.. still having problems with this.. Does anyone have any other ideas. I couldn't get the others to work. The results must be displayed in a form. How about a SQL statement to say something like, Select * initials from table2 where id.table1 =id.table2. Any ideas on how to get the...

Thank you all. I will try the aboves and will let you know how it works. Thanks again for all your posts.

Jarad, Have you tried to copy the form and paste a copy of it as a different name and then try to open the new renamed form to see if there is an error?

Try a compact and repair. Sounds like the form might be corrupted. Let me know how it goes.

Hi, hope someone can help. I have two tables. Table1 and Table2 Table1 has three fields. Id, book, initials Table2 has two fields. Id, initials Table1 is linked to Table2 on the ID to ID I need to have all of Table2's initial data combined into Table1's initials field. The inputs are...

Hi, hope someone can help. I have a process and needs to find a short cut. I have many users (about ten to twenty people). These folks uses a custom crystal reports to export field from a database into excel files. All the excel files are saved in their own local machine. Ex...

I'm not too sure what you are saying. Can you help clarify?

Hi, hope someone can help. I have a only one table. Fields are: FirstName, LastName, SSN, Address, City, State, Zip, ID_Type (combo box), ID_Number, Race(combo box), Gender(combo box), and Purchase_Amount. I don't know how to do this. I need this to occur, when the user begins a new form, as...

Thanks for the Post.. Sillie me... I've tried the statement with OR and it works fine.. now.. I've did it before and it didn't work but now it does.. I probably didn't save the changes somehow.

Hello all, I'm trying to get this to work but is having a few problems. Hope someone can help. SELECT * FROM MTL_Log WHERE (((MTL_Log.AccountingName) Is Null) AND ((MTL_Log.AccountingID) Is Null) AND ((MTL_Log.AccountingDate) Is Null)); I have the above right now. But it's not working...

In my macro, it opens report BUYERREPORT, under the "Filter Name" I have it to run my query "buydaterange". buydaterange ask the user for the begin date and end date. I have it this way because I have these other macros using the same report but with different query. Such as for locations...

Paul, I think I'm probably not clear on the question. I have the query already. I have a display form. On the display form, the user clicks a button to activate a macro. The macro opens the report but the macro has a query also. The query ask the user for the dates. The user inputs in the...

Hmmm. interesting.. I have a query set up with this. Between [Type the beginning date: EX: 01/01/04] And [Type the ending date: EX: 01/30/04] When the users enters 01/03/07 and 01/05/07 as the dates, I would like the dates to appear in the report header. Something like; "Records from...

Hi Statsman, I have the criteria setup already. It's in the report header that I need the min date and max dates to show. Any ideas? I have something like =min(BuyDate) <-- unbound field and =max(BuyDate) <-- unbound field. But it errors.

Hi, Hope someone can help. I have a simple report. The report has a bunch or fields. I've created two unbound fields in my report header. This is where i'm having difficulties. I need the first field to list the min date and the second field to list the max date. This is to show that the...

Just an idea, you would probably want to use the reports through access. Run through the wizards and it should guide you through the step on how to create a report. In your reports, you can use filterings/queries that you had created also, to only select records that you would like to see...

JON!!!!! Thanks so much. You are a genius!!! I forgot all about the SQL possibilities in Access. It worked perfect with a few minor adjustments. Thanks for taking the time to help me out. Wish I can be of service to you as well. Let me know. I owe you one. BEST REGARDS...

Any more ideas to help me out. It doesn't combine the InAmount and OutAmounts at all. It only returns the record if the (per) record is more than $10,000 in the InAmount field. I need something to total like records based on the SSN.

Sorry, I was still editing the prior post and didn't see your post. I got it to work like you had mentioned. but when I input 5,000 and then 5,001, it doesn't display the result. It only displays the InAmount if it is over $10,000. Any ideas.