Search results

I currently have a query that is supposed to pull out customers with a particular last name and I would like to know if my criteria is correct because when I type in a last name into a text box named txtLastName on the form FORMCusSearch and hit a button to preview a report in order to see the...

I currently have a table with a lot fields. I was wondering if it was inefficient and I should try breaking it apart and sorting it more accurately? Fields included are: First name, Last name, invoice num, date, customer ID, cost, sale, net, face, received, and notes. I read the article on...

I currently have a form set up to type in information into text boxes that will be stored on a table. The problem is that when I open the form, it is automatically at the first row, so I have to manually go to datasheet view and scroll to the bottom of the datasheet and click on a blank row then...

I have a query set up to add the total amount of sales made and the total amount of net paid for the product. I subtract both fields to create a profit field, but how do I sort it so I can choose the dates I want to see the profit? i.e. weekly profit, monthly profit, yearly profit? Thus far...

I am trying to design a customer/transaction database for my parent's office. I built up the file using office 2000's access and recently switched over to 2007. I'm still in the kinks of figuring out the new layout, but a problem that I can't seem to figure out is how to install a search...

well i tried asking for help on this earlier, but i wasn't able to find any help so here is my problem. the sales - net = profit is fine but what i want to do is have a totals at the very bottem. everytime i try to do this, i can only get the totals to show and each individual record...

hi. i have 2 queries. query1 has individual sales query2 has the total sales of each individual sale added up from the previous query. what i'm trying to do: on my report i don't know how to add query 1 and 2 on the page so that i can have all of the individual records with the total at the...

well i created a relationship between 2 tables where: tableA = invoice data tableB = company IDs i have 2 questions that i have been unable to resolve on my own. 1. i want to create a query where i am able to find all of the invoices from a single company using it's ID and add up all of the...

as the topic says, i'm a beginner playing around w/ access and i tried to make a query that used 2 tables, but the problem is that when i try to view the query, (since i'm using fields from 2 diff tables may be why) none of the data shows up and all of the fields are blank. i'm trying to create...

Hi. I just recently started studying Access independently since my school never taught it to me and I'm trying to design a invoice type of database as a summer project. I'm stumped on queries because the office 2000 guide I have only briefly goes over it. Basically, what i'm trying to do is...