Recent content by kloot1rr

5 replicas so multiple users can access it at once.

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?

here it is, union query

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.

It now says syntax error in JOIN operation - what is wrong with this? pic34 shows my table and pic6 is the union query.

Awesome - thank you mucho!

Yeah I am looking for one excel sheet with 3 different tabs, would that be the second option then? Thanks for the help!

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...

figured it out...criteria needed was >=Date() Thank you for the help!

heres the master estock that im using

I think this part is messing something up