Search results

I don't think I'm explaining this well at all, I apologize. We have a lot different tables with many related tables. Those tables house information on properties, machines, management companies, service calls, inventory, gross sales, vandalism, commission details, etc. When the owner is in a...

Hello jdraw, here's an example of how a new property gets added and notes we take. We received an email from a property that does not currently have vending and would like us to come out and see if we can assist them. We have a property name / address / phone / email / managers name. I created...

The naming is directly related to the other tables in the database; it's how the owner describes things so it's directly named based on how he wanted things. tblProperty - has a bunch of basic property information including address, city, state, county, tax rate, email, etc. tblPropertyType -...

Thanks June7. Would you have a combo box and then write the answer to a table that the user sees and can continue to pick items and have an "add" button for each attribute they select?

The attributes table consists of items we want to quickly query to be sure we are putting in products and have signage that meet demographics; i.e., apartments have rankings, A, B, C, D and managers tend to tell us the current building ranking, seniors and 55+ tend to like different candy and...

Hello Everyone, I have a database used in a vending machine business. If I'm told about a location's attributes I put the information in notes field associated with the property. Unfortunately this is not a very useful way of doing things. I cannot easily find data on the 250+ different...

I found the issue. I had to change from a LEFT JOIN to an INNER-JOIN Didn't Work: FROM qProductsSold_Candy LEFT JOIN tblVendPricesCandy ON qProductsSold_Candy.MachineID = tblVendPricesCandy.MachineID Fixed: FROM qProductsSold_Candy INNER JOIN tblVendPricesCandy ON...

Thanks jdraw. The unique identifier is the ProductInOutID. Here's the SQL of the query: SELECT qProductsSold_Candy.ProductInOutID, qProductsSold_Candy.MachineID, qProductsSold_Candy.ProductSold, qProductsSold_Candy.ProductExpired, qProductsSold_Candy.FillWeek, qProductsSold_Candy.ProductTypeID...

Hello Everyone, I'm struggling with duplicate items in a query and completely stumped as to why it's happening. I have walked away from this issue for a week and came back to it yesterday and today and I'm still as frustrated as last week. We have a vending business and track a lot of...

Thank you. I'm just learning how to use forms to filter queries and generate the reports I need. I will certainly look into it.

Thank you Markk, this worked perfect.

I've never had to do this before and my brain is not processing how to get this to work. I have a query that pulls information based on criteria from several tables. Then I have a simple report that populates a list of information from the query. Now I have to change the report slightly and...

Thank you DBguy, it finally worked. No idea why it was being so darn stubborn but I duplicated the column as you suggested and it finally all went in correctly. I appreciate your insight.

Hi Everyone, I need help moving data into a table and I'm going crazy because no matter what I try it doesn't give me my desire results. I have 322 records in an Excel file and the records are currently sorted in Ascending order by a value called ComplexID. This ID matches a bunch of other...

Thanks Doc Man for your reply. Yes, you are correct. Each CollectionID and CollectionDate coincides with paper-money in or coins-out. I think I understand what you're saying, but I'm not sure we could dump the old records. It's certainly something I had never thought about, I'll ask our owner...

plog THANK YOU! This worked perfect. I greatly appreciate your help. Now to work on creating the rest of the queries I need based on other tables that have this same type of START indicator.

Hi Everyone, I'm trying to automate a process I currently do manually and need some help. For vending machines, we track all the money in/out of the machine. I am specifically looking for our "CHANGER" machines. These are the one-to-one coin machines that return money, example, something you...

So I deleted everything and retyped it, must have been missing something, not sure. This now works with the dates changed to strings. Thanks everyone for your help! strWhere = "WHERE qProducts_MachineCheck.MachineID IN (" & strList & ") AND qProducts_MachineCheck.FillWeek Between #" & sDate1 &...

Micron, they either have to select one machine or several machines for the query, we have over 700 machines so we don't want the report for all of them. We are trying to narrow down the data to only what is currently needed.

CJ_London, thank you for your reply. I think this might be the issue. Here's the code I'm using to get the dates. I'm not great at VBA so this may not be correct, but it does give me the dates I need. I used a MSGBox to review the WHERE code for my string and it "appears" correct but it's not...