Search results

Hey guys beginner here, I want to set up something in the background that will show me when, and how long, the users are using my database. I have 5 versions of the database that they can use in Microsoft Access. Any suggestions on where to start?

In this query I have setup I need to get my Dates field into short date format and another field needs to be with 0 decimal points. I take it there is code I have to enter but I cannot find it anywhere.

Anyone good at union queries? I have a union query where I am trying to get the "Left in Estock" and the "Left in Estock Line Items" to show only once, not multiple times like they had before. How does this look? When I go to run the query it says syntax error in FROM clause.

Hey all - I am totally new to coding but I am trying to transfer daily data that I get from three different queries all into one Excel sheet. I take it that you have to make one over-arching query which I have made called Awaiting Base. Check out my attachments to see if you think I have it...

I have a form set up (in a list box) to show our salespeople what parts they have yet to get out of inventory but have a sales order for. The list box shows a list of all the salespeoples names. My manager wants me to show ONLY the salespeople that have populated fields in this list box. The...

I have a query that is supposed to be showing todays data (as it is labeled) but it keeps pulling today's number date (i.e. the 1st, or the 17th) for every month, when i only want June 18th not including jan/feb/march etc. 18th. I started running this query in may, that's why it only shows may...

I am trying to get all of the data to show up on my query and currently I can only get 4 of the 8 rows to show. The end goal is to use this query for other queries, so I can pull specific info about where my companies' parts are currently at. I am not sure if you guys can help me with this as...

I am trying to show the Current Repair Estimate total in currency form on my report. The attachment shows my criteria, which works on the query, but does not show in the report. The second attachment shows what pops up when I try to view the report. What can I do to get this current rep...

Hey guys - I have a query all set up and now I have to add one field from another table in it. I am looking for a date which has the criteria Now() - Last Movement Date. Last Movement Date is the column I am taking from the other table which I just added which is the ZLX02 table. When I run...

Hey all, I jumped into my questioning yesterday as I was eager but I would like to introduce myself today. My name is Ryan, 22 years old, and working in Michigan, USA. I am interning at a company this summer and I have been put in place to create a large database for the company to use in the...

Hey guys, beginner here. I have created 3 forms, 1 of which will update the sum of 5 text boxes immediately after numbers are entered in, while on the other 2 forms I had to create a refresh button so that the numbers will add up. The properties in all of the forms and the text boxes seem to...

Hello fellow programmers, I just started my internship a couple weeks ago so I am still relatively new, but here's my problem...I have created a query to run the weekly statistics for my data but one column continues to show multiple times. I want the "Left in Estock" and "Left in Estock Line...