ok my questions here are working with make table queries
My first question is Can I make a form with 6 fields that a user can enter all the data in that is needed for a search and then hit a button to run a make table query?
If so how, i seem to have troulbe doing this with a make table query...
I have Six Fields that i want to have on a form for a user to enter in all known fields and return all matches.
I want it to where i can have these fields on a form
FirstName
LastName
BusinessName
PrimSiteNum
Address
City
Once the user has entered all they know i want to hit a button and then...
Well There is alot of issues here i have to work with
Yes i do want to group my sales by month
That part is easy i have a combo box and i select the month, then after update or change i have the query reun and gives me a total of what the entered month is in a separate field and all my...
I am a sales rep and have built a database to keep up with all my customers and how much i should get paid, etc.
Ok, I have a form called CustomerInfo. which i enter in all my customers in. and on this form it gives calculates all my pay etc.. on this form i have a field that has to be entered...
Ok i have a form that i have set up to run my query. this works fine but i need to fine tune how the infomation is obtained.
I want to have a form with many parameters that if info is input into them that all the info is entered you can hit a button and it will search on only the fields with...
Thanks for the help, i am new though
Is that exactly what i typ in my form or do i need to change it?
if thats it as is then that did not work, still goes to the first record
I have a form that has a subform which a query on it.
On one of the controls on my form i have a field that once info has been entered it will requery the subform and update one of my fields on the form with a new total, this works fine, the only problem is that when it requerys the form, it...
Ok, I have a form called CustomerInfo
On this form i have a field which calculates and comes to a total ([ADSCI]+[SalesTax])
The name of this field is called TotalMonthly
Now want i want to do is take this total and store in a table called CustomerInfoTbl
but the problem i run into is for the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.