Search results

I believe the answer is probably already here but I was not successful at drawing it out through my searches. What I have is a simple access database with the main table having 23 fields. I have a form that displays the fields and each field on the form is a combo box where the user simply...

I have a database whose purpose is to gather and query data from identical linked tables with the same field names. The current process is this: I have a macro that deletes all data from a temporary table. I have an input form that the user lists items from one field to get the appropriate...

No ideas or am I too confusing in my description? Thanks in advance again.

I am looking for the simplest way to add text to a record. I have a database that gets its data from linked excel tables. All the table fields are identical. I have done a union query to go through all the tables and find records by a specific field using an input form. It returns a perfect...

Argh you got to me before I could delete the post. Yes, I remembered what was missing and resolved it thank you. I will attribute my memory to your direct influence! :) Thanks again!

First let me say that I believe I am having a mental block as to the simplicity of this question. Hopefully you have all had a day like this so I am not too embarrased. I have a database that is linked to 13 tables. Each table has the same 7 fields. I simply want a query to look at all 13...

I have looked through the other threads but have not been successful with my goal. I have a single table with all the data I need, but need it sorted. To achieve that goal I created a report with subforms based on three separate queries. My problem is that all three queries will need an...

I suppose it would help if I updated the intent. I would simply like the following fields to have a two letter addition on them: Inventory Job PO Material Heat Size Thickness

Well I hate to admit defeat but here is a slim version of the dbase. I have only left the first 193-ish entries in the database. I also left another attempt at the update query. Did not want this to be too big. My results are always a full column of zeros. Thanks again. I can take a good...

No actually I got that. The fields are all Text type fields less the autoindex which is a number. Still working with it but thank you for the feedback will let you know. Just feeling a little more foolish each attempt :D. The constant result I wind up with is converting the entire column to a...

Hmm I am still playing with it. Will update tomorrow thank you for the feedback.

Boy do I hate to sound stupid but I am completely unsuccessful at solving this. Thank you for the information. In an effort to make this easy, I went to a single table and made a single query on one field. The field is just a sequential numbering and is not the index field. It is categorized...

I have an older database that has 18000 records or so in it. I have recently begun using a new software that will automatically sort data for me and post it into a database. This is all perfect. What I want to do is merge the old database with the new. My problem arises in that the new database...

I have made several other attempts but no luck as of yet. Thanks in advance.

I have a parameter query which returns me the data I need with two input parameters, a name and a date. The query provides the correct data but I need the output to be in a crosstab query so I created another crosstab query to make this happen off of the existing parameter query. The problem...

As an update I am doing this with a crosstab query but my current problem is that I get the error of: "Invalid bracketing of name "[Between [Forms]![Start Date]![txtDate] And DateAdd("d",7,[Forms]![Start Date]![txtDate])]". I have tried multiple variations of this with the brackets and the...

I originally posted this in the incorrect forum so thought I should move this to the report forum. I have a query that gives me data which includes dates. The data is captured for a week long period and subdivided by a project name. The result I would like to have in the end is a report...

Great got it and I used forms as you suggested. It is now functioning like it should. Last question I have on this is in regards to results. I now have the correct data showing in the query results. On the report I am creating to display the data from the query we created, I would like to...

Thank you for the input Bob. I only have one problem to add to that which would be that the date has to be a parameter inquiry. How would I integrate that into this situation. I am attempting to pull up records that are entered daily by using an input parameter for the date field. Really...

My goal is to have the database request a date from the user and with the date provide all the records that are within the calendar week of that date. I can manipulate the input so that the data entered is the first day of that week (i.e. Monday input only) in order to make this easier. If I...