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.
The fields are both non-text. I'm pretty new to access - a colleague said a union query would work best to prevent the left in estock and line items data from showing up multiple times on my reports. Thanks for the replies, so making two seperate queries and then connecting those in a union...
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...
Hey guys thanks for the replies. Pic 54 shows my query which all my data for the form comes from. Pic 55 shows the connection I have for my form to view the all the names. Hopefully this helps a little.
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...
Dates is a date field. Pic855 shows what I am currently getting when I run the query. I'd like the data for just today, not May as well. Pic856 shows what my Master Estock Report fields look like. Pic857 shows what my Left in Estock Totals query looks like. Pic858 and Pic859 show what my query...