How do I show all values in one form?

[Guest]

I'm setting up a warehouse overview in a form.

Simply put, every record is one location - and of course have additional info.

How do I show all these records (always same quantity) in one form, where I
can design/place the fields in a way so they match the physical layout of the
warehouse? (i.e. not a table-format).

Can I use the expressionbuilder for this; something like "=[UsedSpace]+1" to
show the next value for the specific field ?

Any help extremely appreciated,
Thanks

 

[Guest]

Post a sample of your data.

 

[Guest]

Location Available Space Used Space
a 10 6
b 20 7
c 15 8

- where 'Location' is the unique key and always (in this example) 3 locations.

Post a sample of your data.

I'm setting up a warehouse overview in a form.

Simply put, every record is one location - and of course have additional info.

How do I show all these records (always same quantity) in one form, where I
can design/place the fields in a way so they match the physical layout of the
warehouse? (i.e. not a table-format).

Can I use the expressionbuilder for this; something like "=[UsedSpace]+1" to
show the next value for the specific field ?

Any help extremely appreciated,
Thanks

 

[Guest]

Try this crosstab query --
TRANSFORM Sum([Available Space]-[Space Used]) AS Expr1
SELECT "All" AS X
FROM Warehouse
GROUP BY "All"
PIVOT Warehouse.Location;

This will produce an output field for each location and display the unused
space in that field. Put these in your form laid out like you want.

Location Available Space Used Space
a 10 6
b 20 7
c 15 8

- where 'Location' is the unique key and always (in this example) 3 locations.

Post a sample of your data.

I'm setting up a warehouse overview in a form.

Simply put, every record is one location - and of course have additional info.

How do I show all these records (always same quantity) in one form, where I
can design/place the fields in a way so they match the physical layout of the
warehouse? (i.e. not a table-format).

Can I use the expressionbuilder for this; something like "=[UsedSpace]+1" to
show the next value for the specific field ?

Any help extremely appreciated,
Thanks

 

[Guest]

Got it. Great, thanks very much !

Try this crosstab query --
TRANSFORM Sum([Available Space]-[Space Used]) AS Expr1
SELECT "All" AS X
FROM Warehouse
GROUP BY "All"
PIVOT Warehouse.Location;

This will produce an output field for each location and display the unused
space in that field. Put these in your form laid out like you want.

Location Available Space Used Space
a 10 6
b 20 7
c 15 8

- where 'Location' is the unique key and always (in this example) 3 locations.

Post a sample of your data.

:
I'm setting up a warehouse overview in a form.

Simply put, every record is one location - and of course have additional info.

How do I show all these records (always same quantity) in one form, where I
can design/place the fields in a way so they match the physical layout of the
warehouse? (i.e. not a table-format).

Can I use the expressionbuilder for this; something like "=[UsedSpace]+1" to
show the next value for the specific field ?

Any help extremely appreciated,
Thanks